Is there a possibility to find out if incident change state from new directly to close?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-23-2024 12:20 AM
Is there a possibility to find out if incident change state from new directly to close? I tried to create report for it but without any luck... is there some way to find out?
Thank you
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-23-2024 12:37 AM
Check on your metrics. There are several OOB metric definitions on incident state. I don't think it will directly show you New to Closed, but it can help you in creating your own.
Also check out the 'First Call Resolution' one. Depending on your exact use case, it will be created on inactivation of the incident, with start date = created and no other updates in between.
If you need it for current records, you will need to query the sys_audit or sys_history_line table, which could be a performance thingy, but 'old value = new' and 'new value = closed' on the state field, could show you what you are looking for.
Please mark any helpful or correct solutions as such. That helps others find their solutions.
Mark