(imported topic written by SystemAdmin)
We found out that a database query to remove property results from the database for deleted properties was removed from BES 7.0 and 7.1. This means that when you delete properties the database size doesn’t actually go down because the property results from BES Clients are left behind.
We made this tool that you can run to delete the results and reclaim the disk space from the database. The results are not used in anyway after the property is deleted and there isn’t a direct way to undelete properties anyway.
http://software.bigfix.com/download/bes/util/BESPropertyResultsCleaner.exe
Command line options.
-r : Stop the FillDB Server before running the script and restart afterwards to prevent possible deadlocks.
-s : Perform a database shrink on the BFEnterprise database after deleting results to reclaim disk space.
-c : Count the number of rows that will be removed, does not delete any results.