How to run report on Priority changes

Sam196
Kilo Expert

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!

 

find_real_file.png

1 ACCEPTED SOLUTION

JP - Kyndryl
Kilo Sage

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.

find_real_file.png

 

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

 

Regards,
JP

View solution in original post

10 REPLIES 10

Musab Rasheed
Tera Sage
Tera Sage

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.?

find_real_file.png

Please hit like and mark my response as correct if that helps
Regards,
Musab

will that show the old incidents?

No sure, give a try but also go through this from Servicenow

https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0827908

Please hit like and mark my response as correct if that helps
Regards,
Musab

Thank you Musab. I tried, and unfortunately it will only track changes from now on and not the past tickets