Count of Request ID's
Ok Service Desk plus team, I have a new one for the great minds. I am using the following query to pull a report. What I would like to do is add a count of the request IDs to this report. Any ideas are appreciated.
Following Query I am using.
SELECT ti.FIRST_NAME "Technician",
wo.WORKORDERID "Request ID",
sdo.NAME "Site",
scd.NAME "Subcategory",
longtodate(wos.LAST_TECH_UPDATE) "Last Updated Time",
qd.QUEUENAME "Group",
std.STATUSNAME "Request Status",
wof.UDF_DOUBLE2 "Technician timespent" FROM WorkOrder wo
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 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
LEFT JOIN QueueDefinition qd ON woq.QUEUEID=qd.QUEUEID
LEFT join workorder_fields wof on wo.workorderid=wof.workorderid
WHERE (wo.ISPARENT='1') and std.ispending ='0'
AND qd.QUEUENAME IN ('Technical Support','Application Support') AND DATEDIFF(day, dateadd(s,datediff(s,GETUTCDATE() ,getdate()) +(wo.createdtime/1000),'2016-01-01 00:00:00'),GETDATE()) < 30 ORDER BY 1, 6