Need Incident list based on Assignment group while it was opened

[suprakash]

Hi 

I need the incidents based on the assignment group while it was opened.

Normally if we use filter with assignment group we can only see the incidents currently in my queue or closed in my queue.  But I also need the incidents which was opened in my queue and later transferred to any other queue.

[Mike_R]

You can report on the incident_metric table. This keeps a history of all assignment group changes

instanceName.service-now.com/incident_metric_list.do?sysparm_query=mi_definition.name%3DAssignment%20Group&sysparm_view=

[suprakash]

Thank you for your response, is there any way i can add the filter in report on  incident_metric table?

[Mike_R · Accepted solution]

yes, filter on the Value field