Policy Manager - how to delete old alerts from database
In policy manager we have more than 124.000 alerts – oldest are from year 2012. How can I delete old alerts? Manually is out of question! I know that I can hide them, but when policy manager generate scheduled report, I get all the infections...
1) The easiest and most radical way is to to a database recovery and skip the alerts and reports, but you will loose all.
2) disable "hide alerts" to show all. move to the first to be deleted, mark all below (shift-PgDn), click on delete
do a database recovery (to shrink it)
3) with the risk of breaking something:
You could access the database diretly using SQL-statements.
But I think that is tricky and overdoing for a one time task.
Please request detailed information from Support.6 1Like
great, dont forget to do the recovery.
This discussion has been closed.