Aging Reports on Incident and Service Request
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-25-2020 08:52 AM
How to create Aging report for the tickets which are not updated in last 48 hours, 96 to 144 hours and >144 hours?

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-25-2020 09:02 AM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-25-2020 09:50 AM
Hi Sasha,
You'd need a report like this one:
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-25-2020 10:52 AM
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?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-25-2020 11:04 AM
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.