Technician Acitivity
Query to find number of requests assigned to a technician. (MSSQL & PGSQL)
Tested in builds PGSQL (14300) or MSSQL (14306) This query is used to show how many tickets are assigned to a particular technician within a given timeframe (even if these tickets end up being re-assigned again) PGSQL: SELECT aau.FIRST_NAME AS ...
Query to show who closed the request
PGSQL & MSSQL: select wo.workorderid "Request ID", aau.first_name "Request Closed By", cit.typename "Role", queuedefinition.queuename "Group" from WorkOrder wo LEFT JOIN WorkOrderHistory woh ON wo.WORKORDERID = woh.WORKORDERID LEFT JOIN ...
Query to track technician activity on tickets (MSSQL & PGSQL)
Tested in build PGSQL (14300) and MSSQL (14306) Use case: This query will help you find what are all activities that the technicians have done on requests other than the assigned ones SELECT au.first_name "Technician" ,wo.WORKORDERID "Request ...
Query to show request first updated by technician. (MSSQL & PGSQL)
Tested in Build PGSQL (14300) or MSSQL (14306) Go to Reports-New Query Report and execute this query. SELECT wo.WORKORDERID AS "Request ID", wo.TITLE AS "Subject",aau.FIRST_NAME AS "Requester", ti.FIRST_NAME AS "Technician", queuedefinition.queuename ...