Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

Calculate duration of state change for Tasks

Gaurav44
Kilo Explorer

Hi All,

I've been asked to come up with a report that provides duration between states for a task (sctask).

Example - If a task was in state of Pending, and then later got changed to Pending Vendor, how long was that duration from Pending to Pending Vendor.

I dont have rights to create rules, so anything from OOB?

2 REPLIES 2

naveen14
Kilo Guru

Hi Gaurav,

In navigation type "METRICS". under that select definition table.check weather "Catalog Task State Duration" is there or not.

If it's not there then create a new record in Definition table.Same like below snippet.

find_real_file.png

 

Under METRICS --> Instance (Open the table) in that table you will find the state changes duration

find_real_file.png

 

Regards,

Naveen

Hi Naveen,

 

I want this time to reflect in task table. Can I do that?

 

Regards,

Mala