how to fetch the time of update if state changes in incident using incident metric table

[Guptha123]

Hello everyone,

Iam trying to fetch the time of state changes of incident to fetch the report using incident metrics . I come accross there three types of created, created by, updated,updatedby,updates(mi,md,inc) respectively. please help me how to fetch the time when the state of incident is changed and who has changed and also please help me to understand more on (mi,md,inc) in detail.

Thanks in advance,

sai Prakash

[AndersBGS · Accepted solution]

Hi @Guptha123 ,

When looking into the incident_metric database view you will as below and as you has also described:

inc_sys_created_on: refers to the incident itself

md_sys_created_on: refers to the metric definition

mi_sys_created_on: refers to the Metric Instance

So basically:

when the state of incident changed = mi_sys_created_on

A metric definition does not capture incident state and updated by at the same time, hence who has updated it will not be captured in the same definition. If both needs to be captured, a custom table and an "after" business rule can be created to capture the data - but this is a whole other solution.

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

Best regards

Anders