Aging Reports on Incident and Service Request

Sasha8
Kilo Contributor

How to create Aging report for the tickets which are not updated in last 48 hours, 96 to 144 hours and >144 hours?  

5 REPLIES 5

sachin_namjoshi
Kilo Patron
Kilo Patron

Create a report on task table and use task type to differentiate between service request and incidents.

 

Go through the below thread which will be useful:

 

https://community.servicenow.com/community?id=community_blog&sys_id=b11e226ddbd0dbc01dcaf3231f961988

 

Regards,

sachin

 

 

 

 

Joaquin Campos
Mega Sage

Hi Sasha,

You'd need a report like this one:

find_real_file.png

 

As indicated by Sachin, depending on the taks type that you want to check, you'd need to update the filter on task type. In this example I included incidents, requested items and catalog tasks.

In this example I'm checking the ones that were not updated in 48 hours. You'd need to change its value depending on the time frame that you're checking.

Hope it helps!

 

Joaquín

Hi Joaquin, 

 

Thanks for your help. Can you please let me know how to schedule the reports in tabular column having 5 columns with 0-48 hours, 48-96 hours, 96-144 hours and >144 hours as per the assignment groups?

 

Hi Joaquin, 

In this report, it shows the tickets which are updated in last 48 hours but I am looking for the report where tickets are not updated in last 48 hours.