Process Management
Query to fetch additional fields configured in request templates
Postgres: SELECT ca.aliasname AS "UDF field Name", ca.columnname AS "UDF Column Name", ca.field_type AS "UDF Field Type", sd.name AS "Service Category", rtl.templatename AS "Template Name" FROM columnaliases ca LEFT JOIN form_customizer fc ON ...
Query to fetch Checklist Information
DB Compatibility : PGSQL & MSSQL Build Compatibility : Builds above 11107 PGSQL : SELECT wo.WORKORDERID AS "Request ID", aau.FIRST_NAME AS "Requester", wo.TITLE AS "Subject", cd.CATEGORYNAME AS "Category", scd.NAME AS "Subcategory", icd.NAME AS ...
Query to fetch Task Worklog and related entity ID
DB Compatibility : PGSQL & MSSQL Build Compatibility : Builds above 9400 SELECT taskdet.TASKID AS "Task ID", taskdet.TITLE AS "Title", taskowner.FIRST_NAME AS "Owner", taskdet.MODULE AS "Module", wotask.WORKORDERID AS "Request ID", taskprob.PROBLEMID ...
Query on displaying columns in percentage values
PGSQL: SELECT aau.first_name AS "Technician", Count(wo.workorderid) AS "Total No. of Tickets Created", Sum(CASE WHEN std.internalname LIKE 'closed' THEN 1 ELSE 0 END) ...
Query to fetch the templates
The query fetches all the fields with display name used across Request templates PQSQL: select Distinct (CASE when fc.field_name like 'udf_%' then ca.aliasname else fc.field_name END) "Fields", rt.templatename "Template name" , sd.name "Service ...
Request Time Analysis Reports (Status, Group, Technician Fields changes and its timespent)
This report contains the time analysis for each status/group/technician changes in a request. For builds lower than 11122. Status Changes: SELECT wo.WORKORDERID AS "Request ID", sisd.STATUSNAME as "Changed From",sinsd.STATUSNAME as "Changed ...
Shared Request - Group
SELECT wo.WORKORDERID AS "Request ID", wo.TITLE AS "Subject", aau.FIRST_NAME AS "Requester", qd.QUEUENAME AS "Group", ti.FIRST_NAME AS "Technician", std.STATUSNAME AS "Request Status", qa.queuename "Shared to group" FROM WorkOrder wo LEFT JOIN SDUser ...
Request Dependency
SELECT wo.WORKORDERID "Request ID", wo.TITLE "Subject", ti.FIRST_NAME "Technician", pd.PRIORITYNAME "Priority", wo.CREATEDTIME "Created Time", wo.DUEBYTIME "DueBy Time", std.STATUSNAME "Request Status", CASE WHEN wos.ISOVERDUE='1' THEN 'Yes' ELSE ...
Request created in out of business hours
This report is used to find the request created out of business hours. Based on this report, resources can be allocated to manage the load. To make any changes to a query, refer to the KB article below. ...
Task Comments and Description
This report is used to find the task comments and Description. 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 taskdet.TASKID AS ...
Request Approval Details
This report is used to view the historical details of Approved and Denied approval processes and their individual steps. We can also use this report to display all details for which an approval decision is pending. To make any changes to a query, ...
Report on Notes
This report gives an overview of all Notes added by the Technician. This report helps to find a specific word in the Notes, specific technician name etc.. To make any changes to a query, refer to the KB article below. ...
Last reply by from technician or requester
This report gives the last Conversation of Technician and requester. 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 ...
Report on Conversation
This report gives an overview of all Conversation of Technician and requester. 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 ...
Onhold comments
This report helps to find the reason for the request that are placed onhold 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 ...
Service catalog Resource Questions
This report helps to find the resource questions and values chosen in the request. 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 ...
Request with ServiceCatalog Additional fields
Service catalog additional fields are category specific fields. These fields are stored in a dynamic table, so we need to join the specific template to get the resultant. To make any changes to a query, refer to the KB article below. ...
Request recipient email
This report is used to find the recipient email address. Some requests are forward to others through the mail, this report helps to find the statistics how many requests are forward to others using the email address filter. To make any changes to a ...
Request based on SLA name
This report is used to get the name of the sla applied in the request. 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 ...
Request Problem association.
This Report is used to find the request, problem association. 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 wo.WORKORDERID ...
Request change association
This Report is used to find the request, problem and change association with the status of the association. To make any changes to a query, refer to the KB article below. ...
Shared Request
This report is used to get the list of shared request. 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 wo.WORKORDERID AS "Request ...
Linked request
This report is used to find the child request id that are linked to the parent request id. To make any changes to a query, refer to the KB article below. ...
Merged request
To make any changes to a query, refer to the KB article below. https://pitstop.manageengine.com/support/manageengine/ShowHomePage.do#Solutions/dv/24000633501275 MSSQL SELECT Workorderid "Parent Request", (SELECT STUFF( (SELECT cast(Child_woid AS ...
Count of Request inflow per hour
This report provides a quick view of monthly opened incidents per hour. It provides you a quick determination of which hour have a large number of incidents opened. This information can then be used by an Incident Management administrator to ...
Request Summary (Inbound,completed and overdue)
This report provides a quick overview of monthly opened, closed and overdue incidents. It provides you a quick determination of a large number of incidents. This information can then be used by an Incident Management administrator to determine if a ...
Top Requester based on Request
This report is used to get the top 10 requesters count based on the request. To make any changes to a query, refer to the KB article below. https://pitstop.manageengine.com/support/manageengine/ShowHomePage.do#Solutions/dv/24000627781192 SELECT ...
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 ...
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. https://pitstop.manageengine.com/support/manageengine/ShowHomePage.do#Solutions/dv/24000633501275 SELECT ...