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.
SELECT * FROM ManagedEntityGenericView
INNER JOIN ManagedTypeView ON ManagedEntityGenericView.MonitoringClassId = ManagedTypeView.Id
WHERE (ManagedTypeView.Name = ‘microsoft.systemCenter.agent’)
order by ManagedEntityGenericView.DisplayName