Completed Request by Date By Technician
Guys,
Since upgrading to the newest version of Servicedesk our Completed Request By Date By Technician doesn't seem to work correctly. It only shows the results for the technician who is actually running the report. I've attached the query below and double-checked the filtering options but can't seem to figure it out.
SELECT ti.FIRST_NAME "Technician",wo.WORKORDERID "Request ID",wo.COMPLETEDTIME "Completed Time" FROM WorkOrder wo LEFT JOIN WorkOrderStates wos ON wo.WORKORDERID=wos.WORKORDERID 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 LEFT JOIN WorkOrder_Queue woq ON wo.WORKORDERID=woq.WORKORDERID WHERE ((((std.STATUSNAME = N'Closed' COLLATE Latin1_General_CI_AS) AND ((((((ti.FIRST_NAME LIKE N'%Technician 6%' COLLATE Latin1_General_CI_AS) OR (ti.FIRST_NAME LIKE N'%Gareth %' COLLATE Latin1_General_CI_AS)) OR (ti.FIRST_NAME LIKE N'%Technician 2%' COLLATE Latin1_General_CI_AS)) OR (ti.FIRST_NAME LIKE N'%Technician 3%' COLLATE Latin1_General_CI_AS)) OR (ti.FIRST_NAME LIKE N'%Technician 4%' COLLATE Latin1_General_CI_AS)) OR (ti.FIRST_NAME LIKE N'%Technician 5%' COLLATE Latin1_General_CI_AS))) AND (((wo.COMPLETEDTIME >= 1440856800000) AND ((wo.COMPLETEDTIME != 0) AND (wo.COMPLETEDTIME IS NOT NULL))) AND ((wo.COMPLETEDTIME <= 1441461599000) AND (((wo.COMPLETEDTIME != 0) AND (wo.COMPLETEDTIME IS NOT NULL)) AND (wo.COMPLETEDTIME != -1))))) AND ((woq.QUEUEID IN (1,2,3,301,601,901,902,1201,1202,1203,1204,1205,1206,1207,1208,1209,1210,1211,1212,1213,1214,1215,1216,1217,1218,1219,1220,1221,1222,1223,1224,1225,1226,1227,1228,1229,1230,1231,1232,1233,1234,1235,1236,1237,1238,1239,1240,1241,1242,1501)) OR ((wos.OWNERID = 22803) OR (wo.REQUESTERID = 22803)))) AND wo.ISPARENT='1' ORDER BY 3
I basically just want a query where I can see the number of completed requests, for any technician, for any date range.
Since upgrading to the newest version of Servicedesk our Completed Request By Date By Technician doesn't seem to work correctly. It only shows the results for the technician who is actually running the report. I've attached the query below and double-checked the filtering options but can't seem to figure it out.
SELECT ti.FIRST_NAME "Technician",wo.WORKORDERID "Request ID",wo.COMPLETEDTIME "Completed Time" FROM WorkOrder wo LEFT JOIN WorkOrderStates wos ON wo.WORKORDERID=wos.WORKORDERID 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 LEFT JOIN WorkOrder_Queue woq ON wo.WORKORDERID=woq.WORKORDERID WHERE ((((std.STATUSNAME = N'Closed' COLLATE Latin1_General_CI_AS) AND ((((((ti.FIRST_NAME LIKE N'%Technician 6%' COLLATE Latin1_General_CI_AS) OR (ti.FIRST_NAME LIKE N'%Gareth %' COLLATE Latin1_General_CI_AS)) OR (ti.FIRST_NAME LIKE N'%Technician 2%' COLLATE Latin1_General_CI_AS)) OR (ti.FIRST_NAME LIKE N'%Technician 3%' COLLATE Latin1_General_CI_AS)) OR (ti.FIRST_NAME LIKE N'%Technician 4%' COLLATE Latin1_General_CI_AS)) OR (ti.FIRST_NAME LIKE N'%Technician 5%' COLLATE Latin1_General_CI_AS))) AND (((wo.COMPLETEDTIME >= 1440856800000) AND ((wo.COMPLETEDTIME != 0) AND (wo.COMPLETEDTIME IS NOT NULL))) AND ((wo.COMPLETEDTIME <= 1441461599000) AND (((wo.COMPLETEDTIME != 0) AND (wo.COMPLETEDTIME IS NOT NULL)) AND (wo.COMPLETEDTIME != -1))))) AND ((woq.QUEUEID IN (1,2,3,301,601,901,902,1201,1202,1203,1204,1205,1206,1207,1208,1209,1210,1211,1212,1213,1214,1215,1216,1217,1218,1219,1220,1221,1222,1223,1224,1225,1226,1227,1228,1229,1230,1231,1232,1233,1234,1235,1236,1237,1238,1239,1240,1241,1242,1501)) OR ((wos.OWNERID = 22803) OR (wo.REQUESTERID = 22803)))) AND wo.ISPARENT='1' ORDER BY 3
I basically just want a query where I can see the number of completed requests, for any technician, for any date range.