Version : 11027

DB : PGSQL

OUTPUT :

select au.first_name AS "Support Rep",
woh.workorderid AS "Request ID",
LONGTODATE(woh.operationtime) AS "Date / Time",
woh.operation AS "Action",
wohd.columnname ||': Changed From :'||wohd.prev_value || ':Changed To :' || wohd.current_value AS "Information" FROM AaaUser au
INNER JOIN SDUser sd ON au.USER_ID=sd.USERID
INNER JOIN portaltechnicians pt ON sd.USERID=pt.userid
LEFT JOIN workorderhistory woh on pt.userid = woh.operationownerid
LEFT JOIN workorder wo on woh.workorderid = wo.workorderid
Left JOIN WorkOrderHistoryDiff wohd on woh.HISTORYID = wohd.HISTORYID
left join queue_technician qtech on pt.userid=qtech.technicianid
left join queuedefinition qdef on qtech.queueid=qdef.queueid where wo.createdtime >= <from_thismonth> and wo.createdtime <= <to_thismonth> and qdef.queuename = 'network support' order by 1