SELECT qd.QUEUENAME "Group",wo.WORKORDERID "Request ID",mdd.MODENAME "Request Mode",qd.QUEUENAME "Group",ti.FIRST_NAME "Technician",aau.FIRST_NAME "Requester",dpt.DEPTNAME "Department",

Convert(varchar(10),CONVERT(date,(dateadd(s,datediff(s,GETUTCDATE() ,getdate()) + ((wo.createdtime)/1000),'1970-01-01 00:00:00')),106),101) "Created Date",

datename(hh,(dateadd(s,datediff(s,GETUTCDATE() ,getdate()) + ((wo.createdtime)/1000),'1970-01-01 00:00:00'))) + ':' + datename(mi,(dateadd(s,datediff(s,GETUTCDATE() ,getdate()) + ((wo.createdtime)/1000),'1970-01-01 00:00:00'))) "Created TIme",

wo.TITLE "Subject",std.STATUSNAME "Request Status" 

FROM WorkOrder wo 

LEFT JOIN ModeDefinition mdd ON wo.MODEID=mdd.MODEID 

LEFT JOIN SDUser sdu ON wo.REQUESTERID=sdu.USERID 

LEFT JOIN AaaUser aau ON sdu.USERID=aau.USER_ID LEFT JOIN DepartmentDefinition dpt ON wo.DEPTID=dpt.DEPTID 

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 

LEFT JOIN QueueDefinition qd ON woq.QUEUEID=qd.QUEUEID 

WHERE  (((((std.STATUSNAME != N'Closed' COLLATE SQL_Latin1_General_CP1_CS_AS) AND (std.STATUSNAME != N'Closed - Special' COLLATE SQL_Latin1_General_CP1_CS_AS)) AND (std.STATUSNAME != N'Resolved' COLLATE SQL_Latin1_General_CP1_CS_AS)) OR (std.STATUSNAME IS NULL)) AND (((((qd.QUEUENAME = N'CDA, IT' COLLATE SQL_Latin1_General_CP1_CI_AS) OR (qd.QUEUENAME = N'Components, IT' COLLATE SQL_Latin1_General_CP1_CI_AS)) OR (qd.QUEUENAME = N'Lawson' COLLATE SQL_Latin1_General_CP1_CI_AS)) OR (qd.QUEUENAME = N'TDIC IS, IT' COLLATE SQL_Latin1_General_CP1_CI_AS)) OR (qd.QUEUENAME = N'TDIC, IT' COLLATE SQL_Latin1_General_CP1_CI_AS)))  AND wo.ISPARENT='1'  ORDER BY 1, 5