you should be able to use oob database view "incident_metric" and then filter by the new metric you have created, and the value you want. Just add the assignment group (and any other fields you want to see) to the list layout.
e.g.
please note that this will show current assignment group, and not the one it was assigned to at the time the metric recorded the priority.
if you need the assignment group at time of the priority, then you will probably need something a bit more complex
if we've been helpful, please click the little button thing 🙂
Hi @pramodkumar
As mentioned by Kai, you can define a Metric Definition [metric_definition] to capture the Priority changes on the Incident table.
Sample below.
=> Just keep in mind that the Metric Instance only generate after you create the Metric Definition. That means there's no P2 Incidents in the past capturing in the metric.
If you would like to retrieve Incidents that was previously P2. You can look into the Audit [sys_audit] table.
Let me know if it works for you.
Cheers,
Tai Vu
