Timestamp of the State Change in Change Request and Incident

[Rajitha Ashokan]

In Reports module, How to retrieve Timestamp of State Change in Change Request and Incident

For Eg. How do I retrieve Timestamp of Change Requests with State: Pending UAT

Basically I need Timestamp when the State was Updated as Pending UAT

[AnubhavRitolia]

Hi @Rajitha Ashokan 

You can use 'Metric Definition' feature of ServiceNow to store the Timestamp of any record to track duration spend at particular State. You can than generate reports on that Metric Definition.

https://docs.servicenow.com/en-US/bundle/tokyo-platform-administration/page/administer/time/referenc...

https://docs.servicenow.com/bundle/tokyo-governance-risk-compliance/page/product/grc-metrics-irm/con...

[Community Alums · Accepted solution]

Hi @Rajitha Ashokan 

Follow the steps to achieve

1. Create a Metric definition on Change Table for the field to be tracked. In your case it would be - State

2. Create a Metric Instance, by selecting the Metric Definition you created above and make sure you update the Field value and value. In your case it would be 'Pending UAT'

3. Create a Report and select table as 'metric_instance' and in the filter option, select the Definition column and the Metric Definition you created. Then select the 'Start' and 'End' column to get time stamp in the report. 

Do let me know if you need any other information.

Please mark this as correct answer and helpful if it resolved, or mark this helpful, if it is inline with your expectation.

Regards,

Gagan