How to cerate a report for time spent while handling a catalog task at different stages.

[ChetanT38862099]

Hi,

Is there a possibility to generate report for analyzing the time it took for tasks to switch from one state to another.

e.g. time it too from the task was created, amount for time the task was in progress, time it to to complete the task etc.  

Are there any tables which i can use? e.g. task_time_worked.

Kind Regards,

Chetan Tendulkar.

[Dr Atul G- LNG]

Hi @ChetanT38862099 

For this, you need to create a metric in the sc_task table on the field state, and then you can see how much time has been taken at each stage. The out-of-the-box (OOTB) metrics are as follows:

https://www.servicenow.com/docs/bundle/yokohama-platform-administration/page/use/reporting/task/crea...

[jcmings]

As AG mentioned you'll need to either create a metric (metric_definition.list) or utilize an existing one. All metric records are written to metric_instance table (metric_instance.list). If you want to report on it and see metric data along with the task data, you'll need to create a database view that links metric_definition, metric_instance, and task. There are a view database views that already exist, check this doc post to see if your use case is covered.

[Shivalika]

Hello @ChetanT38862099 

The best way is metric instance table, metric definition called "field duration" already exists there. You might check if this table is included there or not. If not you can add it. There itself it will provide you duration for each "state". I had created a report for "on hold" duration for incidents some time back and I referenced this, so this works 100% . 

Thanks and Regards, 

Shivalika Gupta

Servicenow Developer - Schaeffler