Query to view the templates in ServiceDesk based on Service Category
Query:
Prem Maheswaran
SDP Support - FAQ
ServiceDesk Plus - Help Desk Software of your Choice
select rtl.templatename'Template based on Service Category', sdef.name from requesttemplate_list rtl
left join servicedefinition sdef on rtl.parent_service=sdef.serviceid where rtl.is_catalog_template=1 order by 2
Result:
SDP Support - FAQ
ServiceDesk Plus - Help Desk Software of your Choice