Change Log Cleanup for Microsoft Dynamics 365 Business Central
Over time the change log can grow to a very large number of entries, and the change log entry table is protected, so it cannot simply be cleared from a page. Import Export PowerTool can delete change log entries when protected table access is enabled. This is a completely free app from Insight Works for Business Central.
How Change Log cleanup works in Import Export PowerTool
- A manager grants protected table access on the setup page.
- The user sets the Operation to Delete and selects the change log entry table.
- The user filters the entries to remove and previews them.
- The user runs the delete and completes the confirmation.
Key capabilities
Filtered cleanup
Use the Delete operation with a filter, for example by date or table, to remove only the entries you no longer need.
Protected access required
The change log entry table is protected, so cleanup requires protected table access, granted on the setup page by a manager.
Pairs with prevention
Turning off the change log during large imports avoids many of these entries in the first place. See Disable Change Log During Import.
Preview and confirm
Preview the entries the filter selects. Any enhanced confirmation set on the setup page applies before the delete runs.
Details that matter on the floor
Check your retention needs
Change log entries can be part of an audit trail. Agree what may be removed before deleting them.
Who uses Change Log cleanup
Business Central administrators
Keep the change log to a manageable size.
Business Central consultants
Remove change log entries created by data loads.
Questions about Change Log cleanup
Can I delete change log entries in Business Central?
Yes. With protected table access enabled, Import Export PowerTool can delete change log entries using a filtered delete.
Why is protected table access required?
The change log entry table is a protected table, so removing its entries needs the access a manager grants on the setup page.
Who can delete change log entries?
Users who have delete access and protected table access, both granted on the Import Export PowerTool Setup page by a user with the manager permission set.
Related Import Export PowerTool features
All Import Export PowerTool features →Part of Import Export PowerTool
Import, export, update, and delete Business Central data in bulk, for data migration and ongoing data management.
Have a question about Change Log cleanup?
Send us a note and the Import Export PowerTool team will reply by email. Ready to plan a rollout? Contact your Microsoft Partner.