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.

[Musab Rasheed]

Hello Eric,

Do dot walking of SLA definition field and select target like below. Mark my answer as correct if that helps.

[Eric Levinson]

Thanks, Musab - I created a report for response SLA's and will need to wait until one is breached.

I also updated my Resolution SLA report so now it has a condition explicitly using the target for Resolution.

Without the condition: SLA Definition target IS Resolution - I see tickets with breached resolution SLA.

When I add that condition - SLA definnition Target is Resolution - they disappear.

AAny idea what might be happening?

[Musab Rasheed]

should work perfectly, see it is working for me, can you post screenshot of Condition builder?, looks like you are not doing dot walking of Sla definition field

[Musab Rasheed]

Hello,

If issue is resolved Kindly mark my answer as correct and close the thread.

Regards