Freigeben über


Alerts that are closed do not dissapear from the console

PROBLEM
=========

Customer says that alerts in the Active Alerts view in OpsMgr console (Monitoring Section) are not updated as expected. It takes a lot of time for those alerts to be Closed. Or the alerts may change to Closed State but may not dissapear from the console.

Action Plan
=========

To identify computers with future time stamps, run the following query

SELECT * FROM dbo.AlertView WHERE TimeRaised > getutcdate() OR StateLastModified > getutcdate()
clip_image002

- We ran the following t-sql commands to update the OperationsManager Database

UPDATE dbo.AlertView SET TimeRaised = getutcdate() WHERE TimeRaised > getutcdate()

UPDATE dbo.State SET LastModified = getutcdate() WHERE LastModified > getutcdate()

clip_image006

Solution
=========

Apply hotfix 957135

Comments

  • Anonymous
    January 01, 2003
    The Solution is to avoid unwanted events by uing AdtAdmin along with WQL Query as listed below An ACS collector can use Windows Management Instrumentation (WMI) Query Language (WQL) queries as filters to limit the events that are stored in the ACS database.