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. 
                New to ADManager Plus?

                  New to ADSelfService Plus?

                    • 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

                      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 ...
                    • Create an incident request in place of a service request depending on a resource question value.

                      Requirement: Create an incident request in place of a service request depending on a resource question value. Usecase: In many companies, same service template is used for both requesting for a "New Laptop" and "Replacement for the existing laptop", ...
                    • How to create service requests through email using Business Rule

                      Note: Template can be modified directly using BR from build 11.3 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 ...