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
From:

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 

cx

 


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