The CreatorCon Call for Content is officially open! Get started here.

SLA report on incident

Shivani_singh
Tera Contributor

Hi all, 

i have to show a report to the clients.

I'm not sure how the condition will work here
SLA Compliance: Show the percentage of incidents resolved within SLA targets versus those that are overdue.

SLA Breach Trends: Identify trends in SLA breaches over time to understand and address recurring issues.

Also, what should be best practice here,

whether to show report for both response and resolution targets, or only for resolution

 

Please let me know these things

Thanks

 

 

12 REPLIES 12

Hey @Shivani_singh ,

 

Go ahead.

 

 

Accept and hit Helpful if it helps.

Thank you,
Hemanth
Certified Technical Architect (CTA), ServiceNow MVP 2024, 2025

Shivani_singh_0-1724684985248.png

Any more condition or this will be accurate result?

 

AndersBGS
Tera Patron
Tera Patron

Hi @Shivani_singh ,

First of all,rather utilize the incident_sla database view instead of the task_sla table. Next you need performance analytics due to you need to calculate the percentage. You can also export to excel, if you don't have performance analytics. At least, based on the requirement, you sjæle report both on response and resolution SLA.

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

Best regards 
Anders

If my answer has helped with your question, please mark my answer as the accepted solution and give a thumbs up.

Best regards
Anders

Rising star 2024
MVP 2025
linkedIn: https://www.linkedin.com/in/andersskovbjerg/