How can I access/report the Field Changes data?

[GPenetito]

Hi team. I am a lowly user with expanding analytics access

I am in the Action record and want to be able to export the Field Changes data in the Activities field. I can export the Worknotes content, but can't find how/if I can access the Field Changes data for export

Any help appreciated

[Muhammad Khan]

Hi Gpenetito,

As far as I understand you requirement, you can navigate to sys_audit table and apply filter to the list view of this table as per you requirements to find a list of audits/field changes to all records or a particular record.

Those changes are only stored in this table if auditing is enabled on your target table or on fields of your table.

For reference purpose, I am providing an image below in which I am looking for changes happened to a particular record of incident table.

It is not recommended to query this table because it contains huge amount of data.

Hopefully, this will give you a direction.

[GPenetito]

Thanks Muhammad. I appreciate the quick response. Your solution looks like it might require Admin access to make it work, so I am just checking with the Admin team to see how I can access this table using the solution you provided. I see some wider opportunity if I can so fingers crossed