Is it possible to create reports on Audit Logs or download audit data?

(0) Share

Report

Posted on by Community Member

Hello,

Can I create custom views or reports based on CRM audit logs? If so, how? Also, is it possible to download audit data to an Excel file?

Thanks!

I have the same question (0)

All responses (6)

Answers (3)

Verified answer

LuHao 40,892 on at

Like (0)

Report
Copy link

Link copied!

Hi tgiard,

Unfortunately, there is no OOB way to create custom views or reports based on CRM audit logs.

We can use ‘Attribute Audit Explorer’ of XrmToolBox to download audit data to Excel file.

This is the download page of XrmToolBox: https://www.xrmtoolbox.com/

After downloading and unzipping it, open XrmToolBox.exe, connect to your D365 organization. Install 'Attribute Audit Explorer' in the plugin library and open it.

First click ‘Load Entities’, then check entities that will show audit data, then click 'Preview Data', finally click 'Export to Excel' to download it.

You could also select author and time filters in the lower left corner.

Was this reply helpful? Yes No
Verified answer

Mick_4711 552 on at

Like (0)

Report
Copy link

Link copied!
Hi,

I made a report and used this fetchxml structure:

You can build a report and export this to excel.

Kind regards,

Mick

Was this reply helpful? Yes No
Paul_Owen 2,027 on at

Like (0)

Report
Copy link

Link copied!

I think you can export them from the O365 Security and Compliance Centre?

Was this reply helpful? Yes No
Verified answer

Arun Vinoth 11,615 Moderator on at

Like (1)

Report
Copy link

Link copied!

Read my answer for better idea in this SO question: stackoverflow.com/.../7920473

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Thank you all. One more quick question related to this if you don't mind: how can I give users access to the audit logs? I've given users the permissions in the screenshot below but they're still unable to view the audit logs.

Below is what they're seeing under Advanced Settings currently:

Thanks!

Was this reply helpful? Yes No
Arun Vinoth 11,615 Moderator on at

Like (1)

Report
Copy link

Link copied!

I see you submitted another question.

community.dynamics.com/.../need-help-giving-users-the-proper-permissions-to-view-audit-logs

Was this reply helpful? Yes No