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

[aayanarain]

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?

[AndersBGS]

Hi @aayanarain ,

 why? what benefit do you think you will gain by this? According to my observations, micro managed have never brought anything good.’

[aayanarain]

Hello @AndersBGS ,

Thanks for your input! Just to clarify, I’m not trying to micro-manage individuals.

The goal is to generate an accurate report of business time consumed per day, so we can:

• Track SLA consumption trends

• Understand developer workload

• Improve reporting accuracy for planning and compliance

This is especially important when stories span multiple days but we need to know how much time was spent today — regardless of when the SLA started.

If there's a technical workaround or best practice to achieve this, I’d really appreciate the help!

[aayanarain]

Hello @AndersBGS ,

Thanks for your input! Just to clarify, I’m not trying to micro-manage individuals.

The goal is to generate an accurate report of business time consumed per day, so we can:

• Track SLA consumption trends

• Understand developer workload

• Improve reporting accuracy for planning and compliance

This is especially important when stories span multiple days but we need to know how much time was spent today — regardless of when the SLA started.

If there's a technical workaround or best practice to achieve this, I’d really appreciate the help!

[jameswoodfo]

Additionally, how accurate is what you are looking to do going to be. Let's say I have this scenario:

• I review my story for work done in an external system
• I either leave that record up on the ServiceNow screen or I go away from it
• I do the work that I was asked to do in that external system

There is no way to accurately correlate the work that I did in the external system with any updates that I'm made on the story.