SELECT wo.WORKORDERID "Request ID",aau.FIRST_NAME "Requester",cd.CATEGORYNAME "Category",wo.TITLE "Subject",ti.FIRST_NAME "Technician", std.STATUSNAME "Request Status",datediff(d,dateadd(s,datediff(s,GETUTCDATE() ,getdate()) + (wo.CREATEDTIME/1000),'1970-01-01 00:00:00'),GETDATE())"Aging(Days)" FROM WorkOrder_Threaded wot INNER JOIN WorkOrder wo ON wot.WORKORDERID=wo.WORKORDERID LEFT JOIN SDUser sdu ON wo.REQUESTERID=sdu.USERID LEFT JOIN AaaUser aau ON sdu.USERID=aau.USER_ID LEFT JOIN WorkOrderStates wos ON wo.WORKORDERID=wos.WORKORDERID LEFT JOIN CategoryDefinition cd ON wos.CATEGORYID=cd.CATEGORYID 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
WHERE (( std.STATUSNAME = 'Onhold') OR ( std.STATUSNAME = 'Open')) AND wot.THD_WOID=wot.WORKORDERID