CMDB Health Remediation Task Days in WIP Metric

[adamtoth]

Hello,

My team uses the WIP state on CMDB Health Tasks for when an INC, Story, or Decom is related to a task. We would like to be able to report on the number of days a task has been in the WIP state. What are the best practices for tracking this metric? Is there a way to do so without creating a custom field?

Thank you,

Adam

[Dr Atul G- LNG]

Yes, create a trend or bar graph report and put group by updated something like this work for you

[CasperJT]

Hi Adam,

I would suggest creating a metric definition for the state field on the table that holds the CMDB health tasks.

Define a metric

This way you can measure the time the task has spent in any state. If I remember correctly it does not calculate the duration until the state changes, meaning you can only measure after the fact, however you can use the metric_instance created field to tell you when the record went in to a certain state.

Alternatively you might be able to use SLA's, however I am unsure if this table is supported.

Create an SLA definition

Hope this helps

//Casper