to get report of incidents with changed incident priority

[ayushchandra202]

How to get list of incidents whose priority has been changed with ITIL role

[Ankur Bawiskar]

@ayushchandra202 

whose priority has been changed with itil role? can you explain what it means?

[Tai Vu]

Hi @ayushchandra202 

Let's have a look into the Sys Audits [sys_audit] table. Filter as following:

Table Name: incident

Field Name: priority

And you will have the list of incident with priority changes. There's an User column which capture who did the change. 

If you'd like to filter with role, you can define a Database View to map to the User table. Then do the report in that database view with the condition Roles is itil

Cheers,

Tai Vu 

[AndersBGS]

Hi @ayushchandra202 ,

This is where the incident_metric should be utilized to capture the priority change. Go to Metric defintion:

And create a metric definition as below:

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

best regards

Anders

[AndersBGS]

Hi @ayushchandra202 

If my answer has helped with your question, please mark my answer as accepted solution.

Best regards

Anders