Report on Assignment Group that breached SLA instead of the last Assignment Group which Resolved.

[SRJ1]

Need some help, O Wise Folks. I am a newbie.

I have Incidents flowing through multiple Assignment Groups. I need to report the name of the Assignment Group under which the SLA breached. 

Example: I have 4 Assignment Groups A, B, C, D. If the Incident was ultimately resolved by D. However it already breached SLA in B.

How do I get a report listing B is the one that breached SLA?

Any pointers will be greatly appreciated.

[Ketan Patel1]

Follow this thread: 

 
https://community.servicenow.com/community?id=community_question&sys_id=fbf08ba5db98dbc01dcaf3231f9619c7

[Ketan Patel1]

task_sla is a table you need

[SRJ1]

Could you help me the structure of the report filter?

[Ketan Patel1]