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 ...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 ...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 ...To automate an approval for Incident Request Templates
Follow the below steps to add approval script. 1. Go to Admin --> Request Custom Functions -->Request --> Paste the content from the attachment 1. approvals.txt and save it with a name. 2. Configure the custom trigger as in the attached screenshot. ...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 ...