Taiwan CSS Platform Team

Your Potential, Our Passion.

Alerts that are closed do not dissapear from the console

Alerts that are closed do not dissapear from the console

  • Comments 1
  • Likes

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

Your comment has been posted.   Close
Thank you, your comment requires moderation so it may take a while to appear.   Close
Leave a Comment