We've updated the ServiceNow Community Code of Conduct, adding guidelines around AI usage, professionalism, and content violations. Read more

How to create report to view Incident SLA due for breach?

rranjan
Kilo Contributor

I want to create report to view incidents for which SLA (P1, P2, P3 & P4) is about to expire or breach along with due date & time. I want to share this report with my internal management group on daily basis. If anyone can guide me steps how to create this report, that will be great help.

I have created report but it is giving me stage wise SLA due data. I am not sure whether this is giving me required input or not. Please find screenshot of my query and output.

Regards,

Rahul

6 REPLIES 6

Deepak Ingale1
Mega Sage

Add following fields and check



has breached


Business elapsed percentage.


Hi Deepak,



I have tried this but no working or not giving required out put. If you can provide me query along with conditions then i am able to recheck and then confirm the result.


Uncle Rob
Kilo Patron

I think you're going to need a criteria that defines "about to expire".   An adequate one might be "business time left < 1 day" or maybe "Planned End Time on Today".



The "Business Time Left" may not work if your SLA isn't associated with a Schedule.


Thanks for your reply but as I am using service now first time i need to know how to define criteria and how to check SLA is associated with a Schedule so "Business Time Left" may work.