Dear All,

 

Greetings!

 

Can anyone help me with my below query on SLA breach.

 

I just want a query to find out the amount of time a ticket has remained "open" after it has breached the SLA. The report should exclude the time the ticket has been under "onhold" status even after breach.

 

Regards,
Rama.