Sign In with your
Trend Micro Account
Need Help?
Need More Help?

Create a technical support case if you need further support.

Purging alerts from the Deep Security 9.0 database

    • Updated:
    • 18 Jun 2014
    • Product/Version:
    • Deep Security 9.0
    • Platform:
    • VMware vCenter 5.0
Summary
Delete alerts from the database if they are too many to dismiss manually from the Deep Security Manager (DSM) console.
By running database commands, you can do the following:
  • Remove dismissible alerts from the web console.
  • Remove alerts that are not dismissible, but these will reappear when Deep Security scans again for alerts.
Details
Public
To remove alerts, use the following database commands:
Dismissible alerts
update alert2s set TimeResolved = getdate()
go
update alert2hosts set TimeResolved = getdate()
go
update alert2administrators set TimeResolved = getdate()
go
Indismissible alerts
  • For Firewall and Stateful events:
    delete from alert2network
    go
  • For alerts assigned to Integrity rules:
    delete from alert2integrityrules
    go
  • For alerts assigned to specific Log Inspection rules:
    delete from alert2loginspectionrules
    go
Premium
Internal
Rating:
Category:
Troubleshoot
Solution Id:
1103855
Feedback
Did this article help you?

Thank you for your feedback!

To help us improve the quality of this article, please leave your email here so we can clarify further your feedback, if neccessary:
We will not send you spam or share your email address.

*This form is automated system. General questions, technical, sales, and product-related issues submitted through this form will not be answered.

If you need additional help, you may try to contact the support team. Contact Support


To help us improve the quality of this article, please leave your email here so we can clarify further your feedback, if neccessary:
We will not send you spam or share your email address.

*This form is automated system. General questions, technical, sales, and product-related issues submitted through this form will not be answered.


Need More Help?

Create a technical support case if you need further support.