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.