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()
- 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()
Solution
=========
Apply hotfix 957135