Audit History Extractor

This XrmToolBox tool allows you to analyse the audit data by filtering in the preview and exporting to CSV file (developed by Aldo Gillone).

With out-of-the-box audit functionality, the audit details can only be viewed for each row by opening the form and there is no way to export the audit either.

To analyse the audit data more efficiently, you can use this tool to select the table, filter data by view/FetchXML and export the audit data to the CSV file.

• Tool Information
• Documentation
• Functionalities
• Preview the audit data for specified criteria (Fig. 1, Pt. 8, 10)
• Select the table to retrieve the audit data (Fig. 1, Pt. 2)
• Select the column to identify in the RecordKeyValue column (Fig. 1, Pt. 3)
• Retrieve the audit data for specific rows (Fig. 1, Pt. 4)
• Filter by selecting a system view (Fig. 1, Pt. 6)
• Filter by selecting a personal view (Fig. 1, Pt. 5)
• Filter by FetchXML (Fig. 1, Pt. 7, 12)
• Filter the preview data
• Filter by date range (Fig. 2, Pt. 1)
• Filter by Operation Type (Fig. 2, Pt. 2)
• Filter by Action (Fig. 2, Pt. 3)
• Search and filter by selected users (Fig. 3, Pt. 1, 2)
• Search and filter by selected columns (Fig. 4, Pt. 1, 2)
• Apply selected filters for the preview data (Fig. 2, Pt. 4)
• Clear selected data (Fig. 2, Pt. 5)
• Export the audit data to a CSV file (Fig. 1, Pt. 9) (Fig. 6)
• Additionally, the tool can
• Show the tables without audit enabled to view the historic audit data before the audit is disabled for the particular table (Fig. 1, Pt. 1)
• Set the number of rows of data per page to retrieve the related audit data
• Show the logs of how many rows retrieved based on the selected view/FetchXML and how many audit changes are found for each row (Fig. 5)
• Similar Tool
• Attribute Audit Explorer

Fig. 1 - Audit History Extractor Preview

Fig. 2 - Audit History Extractor Advanced Filters

Fig. 3 - Audit History Extractor User Filters

Fig. 4 - Audit History Extractor Attribute Filters

Fig. 5 - Audit History Extractor Logs

Fig. 6 - Audit History Extractor CSV Export

This is part of the #TooLDR series where I test and review the tools for Power Platform. You can check out the information for the other tools on this page.