Restore Deleted Records from Audit Logs in Dataverse Using XrmToolBox
This XrmToolBox tool, developed by Nguyen Nhu Hieu, allows you to review and recreate deleted records for tables with auditing enabled.
Since the Recycle Bin tool is no longer being maintained, recovering accidentally deleted data has become difficult and cumbersome. This new tool simplifies that process by retrieving deleted records from audit logs within a specified date and time range, and recreating them based on the available audit data.
⚠️ Note: This tool relies solely on audit data, so only tables with auditing enabled will be available. Additionally, only columns that are audited will be restored. The tool essentially recreates the row with the same data you'd see on the Audit History page. The Created On and Modified On timestamps will be updated to the current time since they are not included in audit data.
Tool Information
Functionalities
- Recreate deleted data from audit logs.
- Export results to Excel for further analysis.
Steps to Use
-
Load audit-enabled tables and users from the environment. (Pt. 1)
-
Select the date range for querying deleted records. (Pt. 2)
-
Adjust the time zone if it doesn't match your desired setting. (Pt. 3)
-
Choose a table name to query deleted data from. (Pt. 4)
-
Filter the table list to quickly find the target table. (Pt. 5)
-
Select a user who deleted the rows, or choose All Users. (Pt. 6)
-
Filter the user list to narrow down your selection. (Pt. 7)
-
Include disabled users in the user list if needed. (Pt. 8)
-
Retrieve deleted records from the selected table, user, and date/time range. (Pt. 9)
-
Select a deleted row to preview its audit data. (Pt. 10–11)
-
Choose the rows you want to recreate. (Pt. 12)
-
Set recovery options:
- Assign recreated rows to the current user if the original owner is disabled. (Pt. 13)
- Recreate the row using the same GUID. (Pt. 14)
-
Click to recreate the selected rows. (Pt. 15)
-
Export results to Excel, if needed. (Pt. 16)