Video Screencast Help

Need an SQL query to trim the alerts that are not clearing automatically

Created: 29 Aug 2013 • Updated: 12 Sep 2013 | 2 comments
This issue has been solved. See solution.

Need an SQL query to trim the alerts that are not clearing automatically, especially the job finalized alerts.

Operating Systems:

Comments 2 CommentsJump to latest comment

tom_sprouse's picture


Clearing the alerts via SQL will not work via Opscenter WebUI... you will need to use loadsql.bat or dbisqlc application to clear them using SQL.

However, doing so is not supported nor recommended... 

The recommended method is via the WebUI... 

To make life a little easier, go to Monitor / Alerts ...

and click on the Change Table Settings Icon - far right of screen (table w/ green check box)

120px_Symantec OpsCenter_Table_Settings.png

When the Table Settings Windows appears, change the Rows Per Page to 200... 

Click OK

This will allow more alerts to appear per page, and if you filter by Alert Policy / you can target clearing job finalized alerts in batches of 200... 


Note: If this post provides you with a solution don't forget to mark the discussion as solved...