How do you report on a field's history?

[smorri]

I am trying to put together a report that will show if the "Planned start date" or "Planned end date" has changed after the approval on a change request.

[arijal1]

I would start out by turning Auditing History On for your change table.

Wiki Link - http://wiki.servicenow.com/index.php?title=Turning_on_Auditing_(History)_for_a_Table

~   Enabling auditing tracks the creation, update, and deletion of audited records.

Also, when in a change record, you can right-clicking on the change header, and then select "History" to view the history of any field changes in either a list or calendar view. This will give you the field that was changed, the values of the field, the number of times it has changed, the user who changed it, etc.

Wiki Link - http://wiki.servicenow.com/index.php?title=Viewing_a_Record%27s_Change_History

OR

If you want to take it to the next level: and want to see a graph of all change records that had planned dates changed after approval.   For example, a pie chart of change assignee showing how many of their changes had planned date changes after approval, or a trend chart over time, stacked by assignee showing the same info.   To do that, you would want to leverage Metrics.  

[smorri · Accepted solution]

I don't see how to make the report.   There is the sys_audit table, but it does not show anything to connect back to the change request.   The metrics does not have the field changes within it.   Any help with this will be appreciated.

[smorri]

I think I might of figured out the issue.   We are still on Berlin - that might be why we are not seeing the fields to pull.