How can I report daily SLA time consumed by users, even if the SLA or stage started before today?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-05-2025 09:06 AM
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?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
a month ago
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.