Incident Management - Report to show the time spent in each incident state
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-27-2019 09:17 AM
Incident Management - Report to show the time spent in each incident state.
Need to know on how to generate a report that shows the incident and the different states it was in along with the time in each state. the current state of the incident can be any. (active or resolved or closed)
Incident might go through different incident states like assigned, pending user, pending vendor, pending change before its resolved. It is not mandate, but the incident might be in any of these state.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-27-2019 12:48 PM
You can build a report on the incident_metric table with conditions: Definition - is - Incident State Duration
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-28-2019 02:04 AM
Thanks Michael, it works perfectly.