Service catalog
Query to find Service Template Associated to "All Accounts"
Kindly execute the query under Report -> New Query Report to get the list of Service Template Associated to All Accounts. select sd.name "Service Name", rtl.templatename "Service Template Name", rtl.comments "Template description", rtf.description ...
Query to show active Field and form rules in a service template.
Please go to Reports-New Query Report and execute the query. SELECT rtf.templatename "Template Name", rd.rulename "Rule Name", ry.ruletype "Event", rd.usertype "Applies To", rd.jscode "Script", rat.actionname "Action Name", RuleFormField.fieldname ...
Query to show service catalog template details
select sd.name "Service Name", rtl.templatename "Service Template Name", rtl.comments "Template description", rtf.description "Description field" from requesttemplate_list rtl LEFT JOIN requesttemplate_fields rtf ON rtl.templateid=rtf.templateid LEFT ...