How can I report daily SLA time consumed by users, even if the SLA or stage started before today?

aayanarain
Tera Contributor

I'm trying to build a report in ServiceNow that shows how much business time (SLA time) each developer has consumed today, regardless of whether the:

  • SLA started today, or

  • The story/stage (e.g., "In Progress") began today on an older task.

The standard task_sla table only shows total business_elapsed_time, so I'm struggling to get a daily breakdown.

Is there a way to get per-day SLA time consumption, or a workaround to show how much time was logged by each developer today, even for SLAs that started earlier?

5 REPLIES 5

Thank you — you raise a very valid point, and I agree that SLA time doesn’t always equate to the actual time a developer spent on a task, especially if work is being done outside of ServiceNow.

However, in our case, we’re using SLA business time as a proxy to understand workload trends and SLA consumption, not as a precise time-tracking tool. We’re not using this for performance evaluation, but rather to:

  • Analyze how much SLA time is consumed daily, for planning and optimization

  • Understand how many active stories a developer is handling

  • Ensure we’re meeting our SLA targets, especially for operational reporting

I fully understand its limitations, but this level of granularity still helps with capacity reporting and effort estimation, especially when paired with other tools/data sources.

That’s why I’m looking for a way to track daily SLA/business time usage, even across multiple days.