query to list incident templates
running 14005 on MSSQL
I found this thread Admin Report - Department List, Requester List ,Technician List, Incident Template List, Service Template List (manageengine.com) to be able to list all of our Incident Templates. However, management wants to see all the fields/values that have been specified in these. There are almost 200 incident templates in our system, I don't want to go through each one to get this info.
below is just the incident template list query from that above thread:
Complete Incident Template List:
select rl.templateid "Template ID",rl.templatename "Template Name",aa.first_name "Created By",rl.COMMENTS "Comments" from requesttemplate_list rl left join aaauser aa on aa.user_id=rl.createdby where (rl.parent_service is null or aa.first_name='System') order by 1;