Display Breached assignment group for an incident in a reporting using data base view

[Priyanka145]

Hi All,

I want to display the assignment group in which the incident is breached. We are trying using data base view between metric instance table and task table. I am trying to write a logic in where clause like start time of incident sla is less than breach time and breach time is less than end time of incident sla. But I'm unable to achieve it.

Could anyone of you please help me in achieving it or if is there any other approach also kindly let me know.

Thanks 

[Mike_R]

There's already a database view for this OOTB called incident_sla

instanceName.service-now.com/incident_sla_list.do?sysparm_query=&sysparm_view=

[Priyanka145]

Hi Mike,

Incident_sla is giving the latest assignment group but not the breached assignment group for an incident

[prashant8]

Group it by has breached field 

[Saurav11]

Hello,

Please do the below:-

Create a database view with the below configurations:-

Then create a report on that database view and apply filter breach time is not empty:-

Select these fields as column:-

Then you will get all the incidents with their breach time and you can check which incident was in which group during the breach time comparing the breach time and created date.

Please mark answer correct/helpful based on Impact.