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

PrasadWT
Tera Contributor

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 

makku22
Tera Contributor

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?