Way to show incidents with no update within 24 hours

rfolino
Kilo Contributor

Is there a way to show all incidents that have not been updated within 24 hours?

For example an incident was changed to status pending and updated last Friday. It has not been updated since that day. I am wondering if there is a way to pull those tickets.

Thanks!

6 REPLIES 6

rlatorre
Kilo Sage

A simple query can be used on update time:



find_real_file.png


active=true^sys_updated_on<=javascript:gs.hoursAgo(24)



You should also investigate Inactivity Monitors.


Set an inactivity monitor


BALAJI40
Mega Sage

You can use this background script to show all incident numbers,


var gr = new GlideRecord('incident');


gr.addEncodedQuery('sys_updated_onRELATIVELT@hour@ago@24');


gr.query();


while(gr.next()){


gs.print(gr.number);


}


Keeeeev
Kilo Explorer

Also remember to always add acondition to "updated by" "is not" "system" this helps a lot in order to know if the person updated instead of the system.

Anthony Antonel
Giga Contributor

Hello is there a report to show the history of tickets not updated in 24 hours while the ticket was open? I want to see if I can get the timeline of the tickets while they were open and not updated in 24 hours even if they are closed now.