Search

Search for words used in entries on this website

Enter the words[s] to search for here:

Sponsors

OpsMgr: Get Agent-Managed Computer

The other day I needed to get a list of all SCOM 2007 agent-managed computers in my environment, because they needed to have a registry key fixed. I constructed a SQL query to do so:

SELECT MEGv.[Displayname] AS Object FROM dbo.ManagedEntityGenericView AS MEGv
INNER JOIN dbo.[ManagedTypeView] AS TMv
ON TMv.[id] = MEGv.[MonitoringClassId]
WHERE TMv.[Name] = 'Microsoft.SystemCenter.HealthService'
ORDER BY MEGv.[Displayname]

I saved the results to a file called "servers.txt". Essentially, it queries the OpsMgr operational DB for any instance of the HealthService class. Enjoy!

Name:			Remember personal info? Yes No
Email:
URL:
Comment:		Emoticons / Textile
Before sending a comment, you have to correctly answer a simple question you know the answer to. This is a countermeasure against automated spam bots. What are the first four letters of Techlog?     ( Register your username / Log in )
Notify:		Yes, send me email when someone replies.
Hide email:		Yes, hide my email address.
Small print: All html tags except <b> and <i> will be removed from your comment. You can make links by just typing the url or mail-address.