- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-08-2020 10:55 PM
The results of Service offering commitments is stored in table SLA Results [service_sla_result] using Script include SLAResultSummarizer. But when an SLA is breached or completed the records in this table should be updated to increase the count of the breached/completed SLAs. This should be done on periodic basis, may b using some scheduled jobs.
As per Servicenow documentation a scheduled job 'Calculate SLA Results'' is used to do the same, but it is not present in New York and Madrid release.
Please let me know how records in table SLA Results are updated.
Solved! Go to Solution.
- Labels:
-
Service Portfolio Management

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-09-2020 03:32 PM
Hi Vividha,
Is Service Owner Workspace plugin active on the instance? Calculate SLA Results and Calculate Availability jobs are deleted when this plugin gets activated and a new job is introduced called 'SPM Performance Score Computation' sys_id - 222c6326372023006289cc9fbe41f18f, which calls a script include which in turn calls the script include you mentioned.
P.S. - Please mark the answer helpful if it helped!
--
Sameep
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-09-2020 03:14 AM

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-09-2020 03:32 PM
Hi Vividha,
Is Service Owner Workspace plugin active on the instance? Calculate SLA Results and Calculate Availability jobs are deleted when this plugin gets activated and a new job is introduced called 'SPM Performance Score Computation' sys_id - 222c6326372023006289cc9fbe41f18f, which calls a script include which in turn calls the script include you mentioned.
P.S. - Please mark the answer helpful if it helped!
--
Sameep
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-10-2020 04:06 AM
Hi Sameep,
Thanks for the response. I found the Schedule job that is using the mentioned script include.
But now there is one more issue. The Service Offering SLA attached to incident was breached 2 days ago i.e 8th June. After that the schedule job has executed twice but there is no update on the Breached field on SLA Results table [service_sla_result]. Data from this field is displayed on Service owner workspace for Metric Breached SLA.
Below is the screenshot.
Please let me know if you find something for it.
Thanks,
Vividha
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-01-2021 12:28 PM
Hi Vividha,
I ran the job "SPM Performance Score Computation". There are some breached sla. Those records are attached to service offering. However, breached field in SLA Result is still 0. Have you figured it out how these breached field get populated?
Thanks,
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-08-2023 04:51 AM
@Padam - Whether you found a solution for this? I am also facing same issue.