+6
Shelved

Audit Trail Report for Records

Bridget Pounsberry 5 months ago in Digital Asset Management updated by petra.tant 3 months ago 6

We would like the ability to use the stored values of fields within the DAM in a record audit trail report. We have created a custom report to track specific fields from records but the report only shows the new value of the field. For this report we would like to leverage the stored value database so we can view to the historic values of the field as well. For example, if a specific record changed from Version A to Version B we would like to view both values within our report. This type of report would be ideal for our catalogers to view overall changes of records. It would also give them an easy way to view field changes for specific records without them having to go to each specific record to view the changes on each logged field.

Reporting / Analytics

This would be a valuable feature, and I've seen this in other DAMs. The ability to view a full action history on an individual record would help to identify specific actions made and by whom and when. For example, when troubleshooting a metadata error or when reviewing the history of changes or user actions, we could see who did what and when to help determine why or what future action might be necessary. Just a simple log on the record to indicate user name, time, and action (ie update field X with value Y) would be beneficial.

We are building an audit trail viewable for the record. So that's on its way. The audit trail report request is what has the 'shelved' state for the moment.

This is the voice ticket linking to the audit trail feature with status 'in progress': https://adam.userecho.com/communities/42/topics/1708-enable-logging-of-field-metadata-changes-for-dam

Shelved

I'll shelve it to see how important this is to other customers.

Hi Petra, we would leverage insights reporting to view the field changes for those fields that we are tracking through historic changes. This way it gives our administrative team an easier way to view changes of record field values without having to go to each specific record. Instead they would have the ability to search multiple records at one time and view field value changes for auditing purposes.

In Review

We are currently working on making the audit trail for DAM records available through the DAM UI. Here you will be able to see the value changes on specific fields over time through a filterable UI. This is not through a report. Can you explain how you see this in a report? A report of all changes on all records sounds as it would be un-oversee-able. 

Agree completely.  Also important for us as a Validated client that for auditing research purposes we can track who changed validated values from A to B and when.