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.

[Ankur Bawiskar]

Hi,

you can check sys_history_line table where it has old and new value; that is the only place which gives you old and new

Yes it is not recommended to use that as that table is large.

If not then you will have to create custom reference field on incident table and store the older group whenever it gets changed to newer one.

Regards
Ankur

[Ritesh kumar si]

Hi Ankur,

Thanks but is there any other way than creating new field.

[Ankur Bawiskar]

I don't think so.

[Tsura Andreeva]

check out the incident_metric table with filter on md_field = priority, group it by inc_number and active is false