Service Category Report
Hi!
I have the following query (from elsewhere on the forum) that reports my service categories and templates, (title and description). I would like to group the output by category and also add the SLA data (name only) if it exists. I also want to exclude any template that is flagged as no longer in use.
I have the following query (from elsewhere on the forum) that reports my service categories and templates, (title and description). I would like to group the output by category and also add the SLA data (name only) if it exists. I also want to exclude any template that is flagged as no longer in use.
- SELECT case when serd.ciid in(select ciid from businessservice) then 'Business Service' ELSE 'IT Service' END "Service Type", serd.Name "Service Category",serd.Description "Service category desc", list.Templatename "Template Name", list.Comments "Description",aaauser.first_name "Technician" FROM RequestTemplate_list list LEFT JOIN RequestTemplate_fields field ON list.TEMPLATEID=field.TEMPLATEID LEFT JOIN Aaauser aaa ON list.Createdby=aaa.USER_ID LEFT JOIN sduser sd ON field.TechnicianID=sd.userid LEFT JOIN AaaUser aau ON sd.userid=aau.user_id LEFT JOIN ServiceDefinition serd ON list.PARENT_SERVICE=serd.SERVICEID left join aaauser on field.Technicianid=aaauser.user_id
ORDER BY 2
The output looks like this:
My SDP version is 9305 and I am using PGSQL
Thanks in advance!
John