select Arc_Workorder.WORKORDERID AS "RequestID", Arc_Workorder.TITLE AS "Subject", (select case when Arc_Workorder.CREATEDTIME=0 then null when Arc_Workorder.createdtime=-1 then null else DATEADD(MILLISECOND, Arc_Workorder.CREATEDTIME % 1000, DATEADD(SECOND, Arc_Workorder.CREATEDTIME / 1000, '19700101')) end) "Created Time", (select case when duebytime=0 then null when duebytime=-1 then null else DATEADD(MILLISECOND, Arc_Workorder.duebytime % 1000, DATEADD(SECOND, Arc_Workorder.duebytime / 1000, '19700101')) end) "DueBy Time", (select case when Arc_Workorder.completedtime=0 then null when Arc_Workorder.completedtime=-1 then null else DATEADD(MILLISECOND, Arc_Workorder.completedtime % 1000, DATEADD(SECOND, Arc_Workorder.completedtime / 1000, '19700101')) end) "Completed Time", (select case when Arc_Workorder.TIMESPENTONREQ=0 then null when Arc_Workorder.TIMESPENTONREQ=-1 then null else Arc_Workorder.TIMESPENTONREQ end) "Time Elapsed", (select case when Arc_Workorder.resolvedtime=0 then null when Arc_Workorder.resolvedtime=-1 then null else DATEADD(MILLISECOND, Arc_Workorder.resolvedtime % 1000, DATEADD(SECOND, Arc_Workorder.resolvedtime / 1000, '19700101')) end) "Resolved Time", Arc_Workorder.ISOVERDUE AS "Overdue Status", Arc_Workorder.DEPTNAME AS "Department", AaaUser.FIRST_NAME AS "Requester", Arc_Workorder.QUEUENAME AS "Group", Arc_Workorder.SITENAME AS "Site", Arc_Workorder.SERVICENAME AS "Service Category", Arc_Workorder.PRIORITYNAME AS "Priority", Arc_Workorder.LEVELNAME AS "Level", Arc_Workorder.STATUSNAME AS "Request Status", (select case when Arc_Workorder.respondedtime=0 then null when Arc_Workorder.respondedtime=-1 then null else DATEADD(MILLISECOND, Arc_Workorder.respondedtime % 1000, DATEADD(SECOND, Arc_Workorder.respondedtime / 1000, '19700101')) end) "Responded Time", Arc_Workorder.REOPENED AS "ReOpened", Arc_Workorder.CINAME AS "Workstation", Arc_Workorder.modename AS "Mode", Arc_Workorder.slaname AS "SLA", Arc_Workorder.IMPACTNAME AS "Impact", Arc_Workorder.URGENCYNAME AS "Urgency", Arc_Workorder.is_catalog_template AS "Service Request", Arc_Workorder.CATEGORYNAME AS "Category" FROM Arc_Workorder LEFT JOIN SDUser ON Arc_Workorder.REQUESTERID=SDUser.USERID LEFT JOIN AaaUser ON SDUser.USERID=AaaUser.USER_ID