How to track time for a story?

[Linda Kendrick]

Have been asked to see how can track the amount of time it takes to get a story completed in ServiceNow. In Jira there is a workflow associated with story to see how much time is takes for gather requirement, development, QA, completion so I need to figure out how to do the same in ServiceNow.

Is there an OOB way to do this? If not, wondering if doing an SLA for the story would work. We are doing 2 weeks sprints.

We are wanting to determine the bottlenecks of story completion. Comparing to an incident getting completed with the ability to look at how long the story was in different states.

thank you for helping

[Chuck Tomasi]

Have you looked at metrics?

Metric Definition Support - ServiceNow Wiki

[Linda Kendrick]

Looked at that and may be getting what is needed.

Need to get a report that shows the story and then the time in each state. Any idea?

Tried using the metric_definition table for the report but can't get the story listed.

Tried using the rm_story table but can't get to the metric definition.

[mrswann]

have you got a business rule running for the new metric definition?

under metrics > business rules

you need to configure what tables to record the metrics you have defined on

[Sheeba_Sriniva1]

Hi Linda,

To report on metrics, you will have to create a database view that links the metric to the table - Database Views - ServiceNow Wiki

You can look at incident_metric database view as an example.

Thanks

Sheeba Srinivasan