Request for report for Time spent (worklogs)

Hi all,

We have recently updated to version 11.1 Build 11140 , this has broken one of our summary reports for that weeks worklogs, could someone take a look/ provide a updated report?

SELECT rctd.FIRST_NAME "Time Spent Technician" ,cast((sum(ct.TIMESPENT)/1000 * interval '1 second') as varchar) "Total Time Spent" FROM ChargesTable ct
LEFT JOIN WorkOrderToCharge wotoc ON ct.CHARGEID=wotoc.CHARGEID
LEFT JOIN WorkOrder wo ON wotoc.WORKORDERID=wo.WORKORDERID
LEFT JOIN TaskToCharge tkc ON ct.CHARGEID=tkc.CHARGEID
LEFT JOIN TaskDetails tk ON tkc.TASKID=tk.TASKID
LEFT JOIN WorkorderToTaskDetails wtk ON tk.TASKID=wtk.TASKID
LEFT JOIN Workorder wo2 ON wtk.WORKORDERID=wo2.WORKORDERID
LEFT JOIN SDUser rcti ON ct.TECHNICIANID=rcti.USERID LEFT JOIN AaaUser rctd ON rcti.USERID=rctd.USER_ID
WHERE (wtk.WORKORDERID IS NOT NULL OR wo.workorderid IS NOT NULL) AND extract(epoch from(now()::TIMESTAMP - to_timestamp(ct.createdtime/1000)::TIMESTAMP))/3600/24 < 7 group by rctd.FIRST_NAME

MAny thanks,

Andrew