how to create report for SLA met cases from task_sla table

[poornima batchu]

hi

  I am trying to create a report to show sla met cases from task_sla table. Is it possible to create report to show only the current status as there are several sla's will be trigerred for a particular case but how to create a report to showonly single sla status.

[Community Alums]

Hi @poornima batchu ,

You can run a report on incident_sla table and use has_breached field in that. 

Mark my answer correct & Helpful, if Applicable.

Thanks,

Sandeep

[Community Alums]

Hi @poornima batchu ,

Any update to this ?Any follow-up required? if not

Kindly mark the answer as Correct & Helpful both such that others can get help.

Thanks,
Sandeep

[Community Alums]

Hi @poornima batchu ,

Any update to this ?Any follow-up required? if not

Kindly mark the answer as Correct & Helpful both such that others can get help.

Thanks,
Sandeep

[Susan Britt]

Is there a specific SLA you want to report on (e.g., resolution SLA vs response)?  Your report on the task_sla table can include the appropriate "SLA definition" and/or "Target" if appliable that you are looking for.  To pull those SLAs that were met, filter on "Has breached" = false and whatever other criteria you need (e.g., Stage=Completed, Task.active=false, Task.task type is a HR Case).