Local_Object_Defs table growing

Hi everyone,

I wanted to know is there a way to reduce/trim the rows in the LOCAL_OBJECT_DEFS table?
Would it be safe to make changes to this table without breaking BigFix?
What would be the best way to reduce the size of this table?
Would running the Audit Trail Cleaner be the best option?

It’s not safe to make changes to the database.
I don’t recall exactly what’s in that table but should have time to look it up next week.

The Audit Trail Cleaner has largely been replaced by the “Maintenance” tab of the BESAdmin Tool. That includes both the Computer Remover and the Audit Trail Cleaner utilities. Those should be safe to run, but be sure you have good backups of the database.

If you’re already running the maintenance cleanup jobs regularly, you may have to do things like remove unnecessary custom properties / analyses if you want the table to get smaller. I’ll check into what that table actually contains next week

1 Like

Ok, I did look into it a bit further. LOCAL_OBJECT_DEFS contains copies of all of the custom fixlets, tasks, analyses, and properties that have been written in your deployment. It also retains copies of every version, every time you edit the fixlet/task/etc.

The “BES Audit Trail Cleanup” tool in the “Clean Up” tab of BESAdmin is the correct way to clean the older or deleted items from the table. You’ll need to specify the retention date (it defaults to 180 days), and older copies or deleted items older than that will be removed.

1 Like

Thank you so much @JasonWalker.