- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-02-2022 09:45 AM
Hello - I would like to run a report to get data on how many times an incident priority changed for each incident. I have already ran the incident metrics report, but there is no definition "Incident Priority Changes"
I have already tried past posts on this topic and it has come to a dead end. Also, we do not have ServiceNow PA, we are trying to get this data with the base reporting in ServiceNow.
Any and all advices are appreciated. I am not a reporting analyst, so please consider that in your response. Thank you!
Solved! Go to Solution.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-02-2022 11:47 AM
Hi Sam,
It may be reported via the sys_audit table, but this is usually only accessible by the sys admin for performance reason. A sys admin can well schedule a report for you at specific interval.
If you need some data from the incident record itself, a DB view will then have to be created and you may be allowed to report via that DB view.
Regards.
JP
JP

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-02-2022 09:56 AM
Hello,
Why don't you try to create Metric Definition on Priority field and see if that works, Basically it will give time duration but still you can group up incident number and see how many times priority has been changed.?
Regards,
Musab
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-02-2022 10:08 AM
will that show the old incidents?

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-02-2022 10:13 AM
No sure, give a try but also go through this from Servicenow
https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0827908
Regards,
Musab
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-02-2022 10:18 AM
Thank you Musab. I tried, and unfortunately it will only track changes from now on and not the past tickets