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