Retrieving a list of all SCOM Agents

If you want to grab a list of all of your Agents, you can do that a few ways.

1. In the console from the “Administration View”.

2. Use the “Get-SCOMAgent” cmdlet.

3. A SQL Query against the OperationsManager Database.

use OperationsManager
SELECT * FROM ManagedEntityGenericView
INNER JOIN ManagedTypeView ON ManagedEntityGenericView.MonitoringClassId = ManagedTypeView.Id
WHERE (ManagedTypeView.Name = ‘microsoft.systemCenter.agent’)
order by ManagedEntityGenericView.DisplayName


, ,

Leave a Reply

Your email address will not be published.