Pavleck.NET Operations Manager Wiki > Useful OpsMgr SQL Queries

Useful OpsMgr SQL Queries

Table of contents
No headers

This page contains useful SQL queries to poll for various information from Operations Manager.

Remember - these pages ARE editable, so remember to double check any SQL code before you execute it!


List of agents that are grey, but still pingable

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



Tag page
You must login to post a comment.

Wik portal where you can upload your ideas and interests and educational mind set for a free website account please apply here