History of Tasks not updated in 24 hours

[Anthony Antonel]

Hello,

I am trying to get a report of tasks that were not updated in 24 hours while they were open tickets. I need a timeline of the tickets that were open and not updated in 24 hours even if they are closed now. Any help would be appreciated!

[Saurav11]

Hello,

You can create report on task table then add the condition Updated relative before 24 hours from now as below:- 

You will get all tickets which were not updated in the last 24 hours. Now I don't think you can get any report where the difference of last update is captured in ServiceNow. For that you will have to build something custom.

Please mark my answer as correct based on Impact.

[Anthony Antonel]

This is great. Do you know where I might be able to locate how to customize this? 

[Saurav11 · Accepted solution]

Hello,

For this you probably will have to create a custom table and whenever a update happens on any record a business rule will check the difference between the update times and whenever the gap is more that 24 hours just capture that record in the custom table along with the assignment  group name.

Please mark my answer correct based on Impact.

[Mike_R]

Do you have performance analytics? PA is made exactly for use cases like this.