SQL query for AD Integration

April 27 2010, 11:41am

Have you ever wanted to check if AD Integration is enabled for an Agent using a SQL query? Today I wanted to do that and I created the next SQL Query. You may find it usefull. /Find all Agent where AD Integration is configuredRun on OperationsManager DatabaseAuthor: Stefan Stranger/SELECT bme.DisplayName, mths.ActiveDirectoryManagedFROM MT_HealthService mths INNER JOIN BaseManagedEntity bme on bme.BaseManagedEntityId = mths.BaseManagedEntityId WHERE ActiveDirectoryManaged = 1ORDER BY DisplayName /Find all Agent where AD Integration is not configuredRun on OperationsManager DatabaseAuthor: Stefan Stranger/SELECT bme.DisplayName, mths.ActiveDirectoryManagedFROM MT_HealthService mthsINNER JOIN BaseManagedEntity bme on bme.BaseManagedEntityId = mths.BaseManagedEntityIdWHERE ActiveDirectoryManaged = 0ORDER BY DisplayName