Hoping I get lucky here!
Has anyone developed a customization to purge the AuditHistory table?
I’m thinking a simple screen called Purge Audit History with a PURGE button, a Days Old field, and a Save button so the Days Old value can be saved for the next time you launch the screen.
When you press the PURGE button, it would delete records in the AuditHistory table that are more than the Days Old value that you input on the screen. The SQL Code would be something like Gabriel mentions here:
Bonus points if you could add a schedule to this screen, but, honestly, I’d be perfectly happy to manually press the PURGE button. I just need a way to clear a table that has grown out-of-control.
If no one has developed this, maybe someone like