AX 2012 Database Log Cleanup Automation

Update: This can be downloaded here; https://github.com/NathanClouseAX/DynamicsAX2012R3/blob/master/SharedProject_AAX_DatabaseLogCleanup.xpo

The database log is a great tool to capture and troubleshoot odd or unexpected behaviors in AX. Depending on what and how much you log, there is a lot of helpful info that can be stored for review later. However, if you are collecting info, you either need someone to clean up data you no longer want or need or just let it sit and take up space which could slow down finding meaningful info on newer entries. For instance, if you have 3 years worth of database logs but are only interested in the last 90 days, depending on how you access the database log, there may be long waits while AX digs through the logs to find exactly what you are looking for. Searching for something like "SO*1234" or "*1234*" in System Administration > Inquiries > Database > Database Logs may take minutes, even hours if you have tons of database logs there. The attached project aims to help keep things clean in an automated fashion. It adds a batch executable job that will allow you define the number of days of history by table group that you would like to keep.

This includes my recommendations on number of days to keep but it varies entirely on your industry, needs and auditing requirements. This is driven by table group so please do your own analysis of what you would like to keep and not keep by table group. Table Group is available on the table node in the AOT.

This is meant to be a generic solution to cleaning up database logs. If there are any features you would like to see added, please let me know on twitter: @NathanClouseAX