1 of 1 people found this helpful
there's no simple way of achieving this, but I think the following steps should get you mostly there:
1. Temporarily decrease the following variables in System Properties in Advanced Setup:
Days to retain performance data hourly rollups (default: 90)
Days to retain raw performance data(default: 14)
months.to.keep.alerts (default: 12)
months.to.keep.trends (default: 12)
2. Wait for a day (not sure if you don't have to wait for the end of month to get rid of alert and trend data)
3. Reset them to default
There's also an interactive database cleanup script located in /var/hyper9/bin/db_cleanup.sh , so if you log in using SSH, you can remove sample and configuration data older than the specified amount of days as well as data which remains in the database after some entities were deleted or are no longer being monitored. The script will also offer to compact the database, but I would advise against doing this as it takes ages to complete and the database would fill up to the same size in about a month or so anyway.
Thanks very much for your help.
Decreasing the values in conjunction with running the cleanup script did the trick