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!
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
We can generate the report by using Incident Matrix,
1) In Data Table select Incident Matric.
2) In Type Select List.
3) In Configure Select the columns as shown below( you can add other column based on the requirement).
4) In the Filter use: Definition is Incident Priority & Value is 1- Critical( if you want to generate for the report for the P1 which are downgrading to other priorities. )
