Timespent by each technician, group and status analysis report

Query to get status details:

SELECT WO_Status_Info.TIMESPENT, WorkOrder.CREATEDTIME AS “Request Created Time”, WorkOrder.WORKORDERID AS “RequestID”, FROMSTATUSDEF.STATUSNAME AS “FROM STATUS”, TOSTATUSDEF.STATUSNAME AS “TO STATUS” FROM WO_Status_Info INNER JOIN WO_Assessment ON WO_Status_Info.ASSESSMENTID=WO_Assessment.ASSESSMENTID LEFT JOIN WorkOrder ON WO_Assessment.WORKORDERID=WorkOrder.WORKORDERID LEFT JOIN StatusDefinition FROMSTATUSDEF ON WO_Status_Info.STATUSID=FROMSTATUSDEF.STATUSID LEFT JOIN StatusDefinition TOSTATUSDEF ON WO_Status_Info.NEXTSTATUSID=TOSTATUSDEF.STATUSID where Workorder.WORKORDERID is not null

Query to get Technician details:

SELECT WO_Tech_Info.TIMESPENT, WorkOrder.CREATEDTIME AS “Request Created Time”, WorkOrder.WORKORDERID AS “RequestID”, FROMUSER.FIRST_NAME AS “FROM Technician”, TOUSER.FIRST_NAME AS “TO Technician” FROM WO_Tech_Info INNER JOIN WO_Assessment ON WO_Tech_Info.ASSESSMENTID=WO_Assessment.ASSESSMENTID LEFT JOIN WorkOrder ON WO_Assessment.WORKORDERID=WorkOrder.WORKORDERID LEFT JOIN AaaUser FROMUSER ON WO_Tech_Info.TECHNICIANID=FROMUSER.USER_ID LEFT JOIN AaaUser TOUSER ON WO_Tech_Info.NEXTTECHNICIANID=TOUSER.USER_ID where Workorder.WORKORDERID is not null

Query to get Group details:

SELECT WO_Group_Info.TIMESPENT, WorkOrder.CREATEDTIME AS “Request Created Time”, WorkOrder.WORKORDERID AS “RequestID”, FROMGROUP.QUEUENAME AS “FROM Group”, TOGROUP.QUEUENAME AS “TO Group” FROM WO_Group_Info INNER JOIN WO_Assessment ON WO_Group_Info.ASSESSMENTID=WO_Assessment.ASSESSMENTID LEFT JOIN WorkOrder ON WO_Assessment.WORKORDERID=WorkOrder.WORKORDERID LEFT JOIN QueueDefinition FROMGROUP ON WO_Group_Info.GROUPID=FROMGROUP.QUEUEID LEFT JOIN QueueDefinition TOGROUP ON WO_Group_Info.NEXTGROUPID=TOGROUP.QUEUEID where Workorder.WORKORDERID is not null

This entry was posted in Reports.

Need More Help?

Are you looking for a personalized customer support? Submit your question or Call our Toll Free Number to speak with ServiceDesk Plus MSP Expert who can offer a better solution for your requirements.

Submit a Ticket
Email : sdpmsp@manageengine.com
Toll Free : 1-888-720-9500