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!
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
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