SELECT wo.WORKORDERID "Request ID",aau.FIRST_NAME "Requester",dpt.DEPTNAME "Department",std.STATUSNAME "Request Status",wo.TITLE "Subject",cd.CATEGORYNAME "Category",scd.NAME "Subcategory",icd.NAME "Item",pd.PRIORITYNAME "Priority" ,woh.OPERATION,LONGTODATE(wo.CREATEDTIME) CREATEDTIME,LONGTODATE(wo.DUEBYTIME) DUEBYTIME,LONGTODATE(wo.COMPLETEDTIME)COMPLETEDTIME,aau1.FIRST_NAME PERFORMEDBY,LONGTODATE(OPERATIONTIME) OPERATIONTIME, (COLUMNNAME) FIELDNAME,

(select aau.FIRST_NAME from AaaUser aau where wohd.COLUMNNAME = 'OWNERID' and cast(cast(wohd.prev_value as varchar) as int) = aau.USER_ID) "Changed From",  

(select aau.FIRST_NAME from AaaUser aau where wohd.COLUMNNAME = 'OWNERID' and cast(cast(wohd.current_value as varchar) as int) = aau.USER_ID) "Changed To"  from WorkOrder wo  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 SubCategoryDefinition scd ON wos.SUBCATEGORYID=scd.SUBCATEGORYID LEFT JOIN ItemDefinition icd ON wos.ITEMID=icd.ITEMID LEFT JOIN CategoryDefinition cd ON wos.CATEGORYID=cd.CATEGORYID LEFT JOIN PriorityDefinition pd ON wos.PRIORITYID=pd.PRIORITYID LEFT JOIN StatusDefinition std ON wos.STATUSID=std.STATUSID LEFT JOIN WorkOrderHistory woh ON wo.WORKORDERID = woh.WORKORDERID LEFT JOIN WorkOrderHistoryDiff wohd ON woh.HISTORYID = wohd.HISTORYID LEFT JOIN AaaUser aau1 ON aau1.USER_ID = woh.OPERATIONOWNERID where wohd.COLUMNNAME in ('OWNERID') and 

dateadd(s,datediff(s,GETUTCDATE() ,getdate()) + (wo.createdtime/1000),'1970-01-01 00:00:00') >= convert(varchar,'2015-08-31 00:00',21) and dateadd(s,datediff(s,GETUTCDATE() ,getdate()) + (wo.createdtime/1000),'1970-01-01 00:00:00') <= convert(varchar,'2015-09-04 23:59',21)  order by 1,OPERATIONTIME