Idle Call Report

Idle Call Report

Hi All,

I have been trying to find a way to create a query report to report on calls that have not been updated in X amount of days for a single technician

I found this old post below, however It did not give me the answer I was looking for. most of the reports crashed.

https://forums.manageengine.com/topic/report-using-last-update-date



I was trying to do this through the standard report function however it was showing all work logs older than a certain date on specific tickets, Looking for something that checks tickets that are not in Closed or Resolved status that have not been updated in over 2 days, being able to run this report on a single technician basis would be a bonus, if not group by technician should be sufficient.


I managed to piece together the below but could not figure out how to add in filtering it down to 1 technician only, only show tickets that are not closed or resolved, how to check the last worklog time and then see if it is greater than 2 days and then filter back the results in a presentable format.


SELECT ti.FIRST_NAME "Technician",wo.WORKORDERID "Request ID",aau.FIRST_NAME "Requester",cd.CATEGORYNAME "Category",ti.FIRST_NAME "Technician",sdo.NAME "Site",longtodate(wos.LAST_TECH_UPDATE) "Last Updated Time" FROM WorkOrder wo LEFT JOIN SDUser sdu ON wo.REQUESTERID=sdu.USERID LEFT JOIN AaaUser aau ON sdu.USERID=aau.USER_ID LEFT JOIN SiteDefinition siteDef ON wo.SITEID=siteDef.SITEID LEFT JOIN SDOrganization sdo ON siteDef.SITEID=sdo.ORG_ID LEFT JOIN WorkOrderStates wos ON wo.WORKORDERID=wos.WORKORDERID LEFT JOIN CategoryDefinition cd ON wos.CATEGORYID=cd.CATEGORYID LEFT JOIN SDUser td ON wos.OWNERID=td.USERID LEFT JOIN AaaUser ti ON td.USERID=ti.USER_ID LEFT JOIN PriorityDefinition pd ON wos.PRIORITYID=pd.PRIORITYID LEFT JOIN StatusDefinition std ON wos.STATUSID=std.STATUSID 




If someone could help me out this would be highly appreciated,

Thanks :D


Version 9.0 Build 9007
Database mssql
              New to ADManager Plus?

                New to ADSelfService Plus?