Restore Deleted Records

This XrmToolBox tool allows you to review and recreate the deleted rows for tables with auditing enabled (developed by Nhu Hieu Nguyen).

Since the Recycle Bin tool is no longer updated, recovering the accidentally deleted data can be tricky and cumbersome.

With this new tool, you can retrieve the list of deleted rows of the selected table from the audit data within a specific date and time range and re-create those from the audit data.

The tool can only retrieve the deleted data from the audit data, so only the auditing-enabled tables will be available. When the data is recreated, only the values of the auditing-enabled columns will be recreated. Basically, the tool will simply recreate the row with the data that you would see on the audit details page. Recreated data will have the updated Created/Modified data because those are not available in the audit details.

• Tool Information
• Functionalities
• Recreate the deleted data from the audit data
• To start using the tool, load all audit-enabled tables and users from the environment (Fig. 1, Pt. 1)
• Select the date range to query the deleted data (Fig. 1, Pt. 2)
• Update the timezone if the pre-populated time zone of the current user does not match the desired one (Fig. 1, Pt. 3)
• Select the name of the table to query the deleted data (Fig. 1, Pt. 4)
• Filter the list of tables if the list is long or there are a lot of tables with similar names (Fig. 1, Pt. 5)
• Select the name of the user who deleted the rows (or leave it as All Users) (Fig. 1, Pt. 6)
• Filter the list of users if the list is long or there are a lot of users with similar names (Fig. 1, Pt. 7)
• Include disabled users in the list (Fig. 1, Pt. 8)
• Retrieve the list of deleted rows of the selected table from the audit which were deleted by the selected user with the date/time range (Fig. 1, Pt. 9)
• Select the deleted row (Fig. 1, Pt. 10) to preview the data before deletion captured in the audit (Fig. 1, Pt. 11)
• Select the rows which need to be recreated from the results (Fig. 1, Pt. 12)
• Set recover settings
• Assign the rows owned by the disabled user to the current user because the disabled users may no longer have security roles assigned (Fig. 1, Pt. 13)
• Recreate the rows with the same GUID (Fig. 1, Pt. 14)
• Recreate the selected rows (Fig. 1, Pt. 15)
• Additionally, the tool can export the results to Excel (Fig. 1, Pt. 16)
• Similar Tools
• Recycle Bin

Fig. 1 - Restore Deleted Records

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.