how to find the report for sla's about to breach for the incidents as an itil user?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-04-2016 04:47 AM
I am fetching a report in which i have to find out the SLA which are about to breach for incident tickets,so that team can work on those incidents before they get breached(as an itil user)?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-04-2016 04:56 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-04-2016 05:07 AM
I have tried this and it's working,Thanks Srini..and could you please tell me one more thing as i want to fetch reports for the response time and resolution time for the incident as well.what filters i could add up to fetch the reports.?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-04-2016 05:15 AM
Hi Himangi,
Do you have any SLA's with name contains "Response" or "Resolution".
If not, I would assume you need to go to incident_metric table.
Thanks
Srini
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-24-2016 06:08 PM
Are you certain this is working? The SLA duration fields are not updated real-time, they are updated by scheduled jobs which run periodically based on the time left to breach.
More information here Service Level Agreements - ServiceNow Wiki
What you could do is take advantage of the Escalation field on the Incident table. It has values such as 'Normal, Moderate, High, Overdue'. You can modify your SLA workflow to update these values. For example when 50% of the SLA duration has passed then set the escalation field to 'Moderate', when 75% passes you can set it to 'High' and when it breaches you can set it to 'Overdue'.
This would allow for ITIL users to easily group incidents by escalation