How to create a report to show where a field value has been changed

[jennvasconcelos]

Our auditors have requested a report from ServiceNow that will show them all of the approvals that were first approved by the approver and then rejected since ServiceNow allows multiple changes to the approval state field.

I have tried to create this report but the condition options for the state field don't have anything that allow me to show a change in a field value. Is this something that can be done in ServiceNow?

Table: syapproval_approver
Conditions: State changed from Approved to Rejected
Created between 01-APR-2015 and Today

[ghsrikanth]

You should try out this logic and module given by Servicenow, this module will keep track of the changes happens to a particular field and this will give you the history that you are looking for -

Metric Definition Support - ServiceNow Wiki

Hopefully it will help

[Uncle Rob]

Yeah the big problem is that tables don't track changes as elements to that table.   If you're searching for Approval records, you can only use whatever data is currently in the approval.   Best you can do there is look and see if the "Updates" field is greater than 1.   That will tell you the record was saved more than once, which probably means a change in opinion or comments.

To get more specific results you would need to time travel back to build a Metric Definition on the Approval State field, which would log an entry any time that field changed.   Barring that, I think your only option is reporting on the history table, which I'm not even sure you can do anymore.   Anyone know?

[jennvasconcelos]

Thanks Robert! I was able to find the data that I needed on the history tables.