Reports - Need to get only Incidents upgraded to "P1 or P2"

[Mad3]

Hi Team,

I have incidents with different priorities. I should get Incidents only which are changed ( from P3 or P4, or P5) to ' P1 or P2' . 

Your reply my helps me.

Regards

Mad3

[Shekhar Navhak1 · Accepted solution]

Hi @Mad3 ,

You can create metric definitions for incident priority and create reports on the basis of changed values.

[Sohail Khilji]

Hi @Mad3 ,

You can do this with standard reporting but would need to use the audit table data to check which inc got changed from P3 P4 P5  to p1 p2.

It may be reported via the sys_audit table

If you need some data from the incident record itself, a DataBase view will then have to be created and you may be allowed to report via that DB view.

I hope this helps !!!

[Mad3]

Hi Thanks for the help,

But I want to filter the Table is incident_sla instead of sys_audit tablke. I have some conditions on this existing report.

Please reply back.

[Sohail Khilji]

Yes i have suggested to create a database view and use that table for reporting  ! i hope this help.. Kindly mark the question correct if it helped you...

[Shekhar Navhak1 · Accepted solution]

Hi @Mad3 ,

You can create metric definitions for incident priority and create reports on the basis of changed values.