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
‎02-19-2023 07:40 PM
hi,
Am looking for a query / filter condition, where the ticket is NOT Assigned for more than 12 hrs.
Could you please help, whats the query, i need to apply for generating this
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-25-2023 06:06 AM
Hi Everyone,
I have a slight similar case, but in my case I'm using Service Now API through Power Automate (as connector) and i just want to query the incident tickets being handled within the last 24 hours.
In the Query section in Service Now connector List Record action, I used assignment_group=12345dsftyrgh3454^system_updated_on>=javascript:gs.hours(24). These two combined queries didn't return any data, but if I test them individually/separately it works. By the way, this service Id that we used in Service Now API is a read only account, not sure if that's the cause. Could someone guide me the right direction?