Video Screencast Help
Symantec to Separate Into Two Focused, Industry-Leading Technology Companies. Learn more.

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

Lisa, 

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... 

 

--Tom

 

 

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

 

SOLUTION