Way to show incidents with no update within 24 hours
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎09-27-2016 11:59 AM
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!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎09-27-2016 12:14 PM
A simple query can be used on update time:
active=true^sys_updated_on<=javascript:gs.hoursAgo(24)
You should also investigate Inactivity Monitors.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎09-27-2016 12:35 PM
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);
}
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-10-2020 12:53 AM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-19-2022 08:32 AM
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.