How can I create a "Breached" response SLA report?

[Eric Levinson]

I've created a report for breached resolution SLA.  I used the INCIDENT_SLA table and checking Has Breached IS True.

We also use response SLA's as well.  I can't find anywhere a Has Breached for response SLA's in this table.

Can anyone guide me to the right field in the right table to check to see if a response SLA is breached?

Any help would be greatly appreciated.

[Aman Kumar S]

INCIDENT_SLA  is a database view to map task_sla and incident record and I think in your database joins you might have modified something, it looks fine in my instance.

[Eric Levinson]

Hi Aman.  Thanks for your quick response!  I'm not doing any joins, just using the built in reporting tool as is.

[Aman Kumar S]

The filter conditions that you are using, did you verify if there are matching records for that in task_sla table, like your assignment group filter?

[Karun S]

"Has breached" will be in the [incident] table and not in [incident_sla] table.