- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎01-20-2015 05:29 AM
Hi,
I have created SLA for my Service Catalogs. For these Catalogs I want the SLA to run once the Catalog Approved so that it takes Start time as Service Catalog approved time. So I have not selected Retroactive Start. But the issue is the Actual elapsed time, percentage, business elapsed time and percentage fields are not running live i.e, only if the state of the Service Catalog is in "Awaiting user info" or "Closed" it is showing elapsed time and percentage.
I want to these fields to run and show upto date. Any solution?
Thanks,
Vimal
Solved! Go to Solution.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎01-20-2015 07:35 AM
Elapsed time & elapsed percentage updated according to schedule below:
2.4.2 Scheduled Jobs
ServiceNow recalculates SLAs based on when they are breached, using these scheduled jobs on the Schedule Item [sys_trigger] table.
- SLA update (already breached): repeats every day
- SLA update (breach after 30 days): repeats every 5 days
- SLA update (breach within 1 day): repeats every hour
- SLA update (breach within 1 hour): repeats every 10 minutes
- SLA update (breach within 10 min): repeats every 1 minute
- SLA update (breach within 30 days): repeats every day
Your screen shot shows Business elapsed time and business elapsed percentage. They will only populate if your SLA has a schedule other than 24x7. So 8x5 schedule would cause those fields to populate. Otherwise, they are blank as their isn't anything to calculate.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-22-2015 01:18 PM

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-22-2015 01:32 PM
Your duration field doesn't look correct.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-22-2015 01:46 PM
I am using the following Relative Duration, which was shared on this community board and has been used by others (for a task's "due_date" field):
var baseTable = new TableUtils(current.getRecordClassName()).getAbsoluteBase();
if (baseTable == 'task')
myTask = current;
else if (baseTable == 'task_sla')
myTask = current.task;
var dueBy = myTask.due_date.getGlideObject(); // due_date - a glide_date_time field on our associated Task record
calculator.endDateTime = dueBy;
calculator.seconds = ((dueBy.getNumericValue() - calculator.startDateTime.getNumericValue()) / 1000);
calculator.totalSeconds = calculator.seconds;
..
With it calculating an endDateTime, I figured it would be able to calculation business elapsed percentage.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-10-2015 11:44 AM
Good day,
I have been testing out the above script, and continue to have issues with getting a relative duration. Checking the SLA logs, the duration is returning a "NaN" result, and due to this the Business Relative Duration is also returning "NaN".
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎11-06-2015 08:14 AM
I am also having this issue.
I have a schedule set with 2 SLAs to trigger. If I use Retroactive on Created, then it works like a charm, however, I only want the SLA clock along with the 'business time left' and 'business elapsed' time to begin once the incident gets assigned to a specific assignment group.
I tried to change retro off, but there is no business calculation, then i tried to set to retro, as 'updated' to start, however, the time does not show a live calculation???
Once I achieve the SLA though, it updates and provides the calculation.
*I would like to point out though, that the email notice still goes out as it should. Only the calculation is not working.
I have a screenshot of the issue showing the start time of the SLA...and I check current time and no calculation is there.