create a report on incident with p1 or the priority was previously p1

mregragui_ext
Tera Contributor

Hello everyone, I need to create a report on incident with p1 or the priority was p1 and has been downgrade to p2 ..

9 REPLIES 9

Mark Roethof
Tera Patron
Tera Patron

Hi there,

 

Do you have perhaps metrics or PA in place which keeps this history? So that can be used for the reporting?

 

In theory you could also get that from sys_audit, though reporting on sys_audit is a bad practice.

 

Kind regards,

 

Mark Roethof

Independent ServiceNow Consultant

10x ServiceNow MVP

---

 

~444 Articles, Blogs, Videos, Podcasts, Share projects - Experiences from the field

LinkedIn

How can i create metrics to any Incidents upgraded to P1 or downgraded from P1 to something else

Hi, i created a database base view with incident and sys_audit tables now how can filter in the report on the incident that was P1

Aman Kumar S
Kilo Patron

Hi @mregragui_ext ,

You can follow below approach for the same:

1. Add table Histroy(sys_history_line) in the system property glide.ui.permitted_tables.

2. Create a new report on the history table as shown in screenshot.

history_property.PNGhistory_report.PNG

 

Best Regards
Aman Kumar