Reporting on when field values are updated

[Robin Hearne]

I have a requirement to produce a report of all Risk (grc_risk) records that have had the 'Description' field updated during the past month.

I could create a new date field in the table and use a Business Rule to update date it with the current date whenever the Description field changes, but I figure that there aught to be a better way.   I have been told that I should be able to use a Metric to capture this information but I've not created custom Metrics before and all the examples are based on capturing a duration, not a single point in time.

Any suggestions for how to best accomplish this would be appreciated.

Regards,

Robin

[Pradeep Sharma]

Hello Robin,

You are right. It should be via metrics. Navigate to Metrics->Definitions->Create new screenshot for reference.

Once done make sure you have the metric related list on change request form i.e to configure go to change record->Configure->Related list and add metrics on the form.

Reference:

http://wiki.servicenow.com/index.php?title=Metric_Definition_Support#Sample_Field_Value_Duration_Scr...

[Pradeep Sharma]

Let me know if that answered your question. If so, please mark the response as correct so that others with the same question in the future can find it quickly and that it gets removed from the Unanswered list. Thank you

How To Mark Answers Correct From Community Inbox

[Robin Hearne]

Hi Pradeep,

Thank you for your reply.   I think I must be missing something however as I created the Metric and made a change to the field but a Metric Instance was not created.

Here's a screenshot of the Metric definition.   Please note that the field I'm trying to track is in the grc_risk table, not the change_request table.

Regards,

Robin

[Pradeep Sharma]

Thanks Robin for the update. Can you try to update the risk field on existing record to another value and check once?