We were running a report where we would report on Last updated time. I understand that it would show the last time when a note was added to the ticket. However now we are encouraging the technicians to add worklogs as they track the time for the techs. But now the Last updated report does not show the true picture of the last update of tickets.

Is there a fix for this?

Below is the current query:

SELECT ti.FIRST_NAME AS "Technician", wos.LAST_TECH_UPDATE AS "Last Update Time", wo.CREATEDTIME AS "Created Time", ti.FIRST_NAME AS "Technician", wo.WORKORDERID AS "Request ID", wo.TITLE AS "Subject" FROM WorkOrder wo 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 WHERE  (((std.STATUSNAME::TEXT != 'Closed'::TEXT) AND (std.STATUSNAME::TEXT != 'Resolved'::TEXT)) OR (std.STATUSNAME::TEXT IS NULL))  AND wo.ISPARENT='1'  ORDER BY 1 NULLS FIRST , 2 NULLS FIRST , 3 NULLS FIRST  limit 50000

Thanks