Historical Incident data for specific Assignment group

[kumar22]

Hi Team, 

How can I fetch incidents that were handled by Network Assignment users, meaning that at some point in the incident’s lifecycle it was assigned to a Network user? I tried creating a database view for this, but I’m not able to retrieve the data. Has anyone achieved this before and can guide me?

Order	Table	Variable prefix	Where clause
100	metric_instance	mi
200	metric_definition	md	md.name = mi.definition && mi.definition = 'Assigned to duration' && md.table = 'incident'
300	incident	inc	inc.sys_id = mi.id
400	sys_user	u	u.sys_id = mi.value
500	sys_user_grmember	grm	grm.user = u.sys_id && grm.group = 'd625dccec0a8016700a222a0f7900d06'

Thanks in advance!

[Rafael Batistot]

Hi @kumar22 

As Admin is posible to check the historical of the incident > 'sys_history_set'

May you find those information

[Dr Atul G- LNG]

Hi @kumar22 It will not work on this assignment if the metric was not defined earlier, as metrics only work on new data/records. Once defined, you can use the metric data to check where the assignment group name is "Network" and then find the relevant records. Not sure about the use of a database view here, since you can get this information directly from the metric itself.

[kumar22]

Hi @Dr Atul G- LNG - We have the records in the incident_metric & metric_instance tables for the incidents. 

[Dr Atul G- LNG]

so where you stuck mate?