Exporting Audit Trail Data

(0) Share

Report

Posted on by Jason Brzoska

Hi-

I've got an interesting one... we have a VERY complex Excel template that we use very often. My boss wants to make sure the reports, which have 3000 cells or more (probably double that including formula cells), are absolutely perfect.

So he wants to be able to compare the old versions of the report to the new versions. We used Adobe Document Compare and it didn't work well. He'd like the new version to highlight changes made.

We do have auditing turned on, so every field has the date updated in that audit. Is there a way I can export those dates when I export the data? I'd then use formulas to conditionally format cells based on those changes.

Thanks,

Jason Brzoska

Newton and Rochelle Becker Charitable Trust

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

Jomy Jose 290 on at

Like (0)

Report
Copy link

Link copied!

Currently Microsoft does not allow us to export the audit data, but we can export using some custom tools like XrmToolBox. Also we can create some custom console application and we can customize the export format.

But there is no way to export the audit along with data export.

Was this reply helpful? Yes No