How to get report of incident where Priority was changed

[Ritesh kumar si]

I want to get reports of incidents where Priority was changed for some particular groups. Report should include Old value and New value both.

I tried using metrics but that only gives the current value when changed. Also tried creating Database view using metrics and history tables but that was not giving proper data, since history is not reportable directly and is not preferred for reporting please help on this.

[Ritesh kumar si]

Hi Tsura,

This will give me the current value of the priority but I actually need the old value also and if you know any other way let me know.

Thanks

[Tsura Andreeva · Accepted solution]

Look at the value field for previous priority, sort by start in my sample I picked a ticket that I knew was changed and group by ticket number 

[sandhya123456]

@Tsura Andreeva  can we use this method  for past year's data(incidents)?

[Krishna64]

Hi Tsura, Is this possible with normal tables what we have in Servicenow? as i do not have access to create the metric table, i am just trying to find the incidents which are downgraded/upgraded the priorities? I'm doing it manually checking every Inc please help me on this

[Tsura Andreeva]

This is only available for reporting in "normal" tables (I am guessing you mean the incident table)

The incident_metric table should be available