Query to list Service Category its templates and associated accounts.

Go to Reports-New Query Report and execute the query.



select sdef.name “Service Category”, reql.templatename “Service Template”, adef.org_name “Associated Accounts” from servicedefinition sdef
LEFT JOIN requesttemplate_list reql ON reql.parent_service=sdef.serviceid
LEFT JOIN servicetempaccmapping stm ON stm.templateid=reql.templateid
LEFT JOIN accountdefinition adef on adef.org_id=stm.accountid
where is_catalog_template= ‘true’ order by 1,2

This entry was posted in Reports.

Need More Help?

Are you looking for a personalized customer support? Submit your question or Call our Toll Free Number to speak with ServiceDesk Plus MSP Expert who can offer a better solution for your requirements.

Submit a Ticket
Email : sdpmsp@manageengine.com
Toll Free : 1-888-720-9500