Request based on Incident and Service Catalog Templates

Request based on Incident and Service Catalog Templates

This report is to get the name of the Template applied to the request. 

To make any changes to a query, refer to the KB article below.



SELECT reqtl.TEMPLATENAME "Template Name",
       wo.WORKORDERID "Request ID",
       dpt.DEPTNAME "Department",
       sdo.NAME "Site",
       cd.CATEGORYNAME "Category",
       scd.NAME "Subcategory",
       std.STATUSNAME "Request Status",
       ti.FIRST_NAME "Technician" FROM WorkOrder wo
LEFT JOIN RequestTemplate_list reqtl ON wo.TEMPLATEID = reqtl.TEMPLATEID
LEFT JOIN DepartmentDefinition dpt ON wo.DEPTID = dpt.DEPTID
LEFT JOIN SiteDefinition siteDef ON wo.SITEID = siteDef.SITEID
LEFT JOIN SDOrganization sdo ON siteDef.SITEID = sdo.ORG_ID
LEFT JOIN WorkOrderStates wos ON wo.WORKORDERID = wos.WORKORDERID
LEFT JOIN SubCategoryDefinition scd ON wos.SUBCATEGORYID = scd.SUBCATEGORYID
LEFT JOIN CategoryDefinition cd ON wos.CATEGORYID = cd.CATEGORYID
LEFT JOIN SDUser td ON wos.OWNERID = td.USERID
LEFT JOIN AaaUser ti ON td.USERID = ti.USER_ID
LEFT JOIN StatusDefinition std ON wos.STATUSID = std.STATUSID
WHERE wo.CREATEDTIME >= <from_thisweek> AND wo.CREATEDTIME <= <to_thisweek>
ORDER BY 1

Note : Login to ServiceDesk Plus, go to Reports tab > New Query Report > Copy the query to the query editor and run the report. 
          • Related Articles

          • Incident and Service Catalog Template Frequency

            1 . This report is used to find the most used template in the application.   To make any changes to a query, refer to the KB article below. https://pitstop.manageengine.com/support/manageengine/ShowHomePage.do#Solutions/dv/24000633501275 SELECT ...
          • How to create service requests through email using Business Rule

            This post describes the use of a python script to create a service request through email based on keywords in the subject. When a request is created with specific keywords in the subject of a incoming mail , the Business Rule will be invoked. The ...
          • How to create service requests through email

            This post describes the use of a python script to create a service request through email , based on keywords in the subject.When a request is created with specific keywords in the subject of a incoming mail , the custom trigger will be invoked.The ...
          • Template configuration

            This report will give you the complete list of templates configured in the application.  MSSQL SELECT serd.Name "Service Category", max(list.Templatename) "Template Name", STUFF( (SELECT ',' + tgm.QUEUENAME FROM TemplateToGroupMapping tgm WHERE ...
          • How to close associated incident requests of change request automatically

            This post describes the use of a python script to close change that are in a specific stage using Custom Schedules. Use Case: There may be a scenario where number of Change Requests that have got closed and the associated incident is still in open ...