Want to create report in which Prioroity upgrades, State changes visible

[SHUBHAM78]

I need all the a report for incident data for Moderate and High Priority Incidents (Priroity levels - 1 2 and 3)
that are Resolved for some queues.

The data I am interested is the field changes e.g. Prioroity upgrades, State changes etc. the Incident[Incident] table only provides Comments and work notes.

we can't use sys_audit table and sys_history_line and sys_journal_field are not reportable in the report.

I have created Metric Definition(metric_definition) for state, assignment group, priority, assigned to. Now I want to create report. How can I proceed further and create report with the above details 

[Tanushree Maiti]

To report on ServiceNow incidents that have had their priority upgraded (e.g., P4/P5 to P3, or any to P1), use the OOB metric_incident Database View to track historical changes rather than the current incident state.

The best approach is creating a report on the metric_instance table, filtered by definition 'Priority', and comparing the old value with the new value

Check this Thread. Hope it will help you.

Metric to show Max Priority throughout an incident... - ServiceNow Community