Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

How to report on SLA breach on incidents for a month

Snehal13
Kilo Sage

‎07-05-2024 04:19 AM

I see that some SLA records are complete skipped. Why are these so ?

 

Which table to refer  - task_sla or incident_sla or something else 

 

I understand that one incident might have multiple sla attached so what is best way to report on sla breach on incidents for a given month?

 

Please guide with table, filters abd right grouping

0 Helpfuls
  • 391 Views
2 REPLIES 2

Dr Atul G- LNG
Tera Patron
Tera Patron

‎07-05-2024 04:29 AM

Hi @Snehal13 

 

Refer to task_sla table only. You can use condition as breach = True and then group by = Type or task

 

AGLearnNGrow_0-1720178971337.png

 

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************
0 Helpfuls