
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎09-01-2022 03:33 AM
One of our managers is requesting SLA timelines/reporting on how long it is between an Incident being opened, to the state changing to In Progress. So not the base SLA timer that starts once the state changes, but some way of reporting on how long between the ticket being opened, and the state changing to In Progress.
OOB I can't see a way of doing this via reporting, so hoping someone can shed some light for me?
Solved! Go to Solution.
- Labels:
-
Incident Management
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎09-01-2022 03:41 AM
Hi,
you can report on incident_metric table and use the metric capability and give condition as Definition = Incident State Duration
Regards
Ankur
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎09-01-2022 03:41 AM

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎09-01-2022 03:56 AM
That's great, thank you very much! That does exactly what I'd expect, and should be exactly what they are wanting to see.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-12-2024 05:43 AM
Ankur,
That worked perfectly.
I do have a follow-up question I'm sure you could assist me with.
The filter only returns results for active tickets. How would I go about capturing historical data? Our NOC team would like to see their response time from the beginning of the year till now. All my modifications return current data only.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-12-2024 06:56 AM
Ankur,
That worked perfectly.
I do have a follow-up question I'm sure you could assist me with.
The filter only returns results for active tickets. How would I go about capturing historical data? Our NOC team would like to see their response time from the beginning of the year till now. All my modifications return current data only.