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

[mregragui_ext]

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

[Mark Roethof]

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.

[mregragui_ext]

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

[mregragui_ext]

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]

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.