Advanced Monitoring with System Center Operations Manager 2007 and System Center Virtual Machine Manager

This blog will now focus on advanced monitoring of heterogeneous data centers. This includes traditional physical servers, both Microsoft and non-Microsoft platforms. It will also include the virtual space, both Hyper-V as well as VMware. Lastly, it absolutely will include networking components!

Identifying Gray (Uncommunicative Agents) in OpsMgr Directly from the OpsMgr Database

Courtesy of Pete Zerger - http://www.systemcenterforum.org/news/tipidentifying-gray-uncommunicative-agents-in-opsmgr-directly-from-the-opsdb/ 

Source: MS Newsgroups (AdamZ)

I posted a tip a few months ago about where to see which agents are not communicating with their management server (CLICK HERE) within the Operations Console. These appear as the checkmark icon that has turned gray (indicating agent is not longer communicating).

AdamZ thought that was a bit to involved, and instead offered up this query to retreive this data from the OperationsManager database. (Gave this a quick test, and seems to be accurate in my lab).

SELECT ManagedEntityGenericView.DisplayName,
ManagedEntityGenericView.AvailabilityLastModified
FROM ManagedEntityGenericView INNER JOIN
ManagedTypeView ON
ManagedEntityGenericView.MonitoringClassId = ManagedTypeView.IdWHERE (ManagedEntityGenericView.IsAvailable = ‘false’) AND
(ManagedTypeView.Name = ‘Microsoft.SystemCenter.Agent’)
ORDER BY ManagedEntityGenericView.AvailabilityLastModified

Published Monday, January 12, 2009 1:23 PM by walterch
Filed under:

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

No Comments

Leave a Comment

(required) 
(optional)
(required) 

  
Enter Code Here: Required
Submit

© 2009 Microsoft Corporation. All rights reserved. Terms of Use  |  Trademarks  |  Privacy Statement
Microsoft
Page view tracker