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 ADSelfService Plus?

                    • Related Articles

                    • Convert Incident to Service Request

                      For builds before 10536 The option will be available at: open the respective request > Actions > Convert incident to service request For builds after 10600. Edit the respective request > click on the Template dropdown [top-right corner] > Choose the ...
                    • 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 use URL ( external link ) in the service catelog - service templates in self service portal

                      The application has an option to add link in the self service portal customization. But if the requirement is to add the URL inside the below templates The requirement is that , to have a specific template that can redirect to an external URL and not ...
                    • Query to display additional field associations with templates (MSSQL)

                      Tested in build MSSQL (14306) Use case The reports shows in which templates the created additional fields are associated Query select sd.name "Service Catalog Name", rt.templatename "Template name", fc.field_name "Fields" from requesttemplate_list rt ...
                    • Customize the category list/selection based on template.

                      The Category applies to all the templates in SDP-MSP. You can hide them using the field and form rules to make them unavailable for users. Under Admin >> Incident Template >> Edit the template in questions >> Field and Form Rules tab. You can create ...