All groups (DW)

Thanks to Daniel Savage for helping with this one.

/*
Get all groups from Data Warehouse
*/
USE OperationsManagerDW
SELECT DISTINCT DisplayName
FROM vManagedEntity
WHERE (ManagedEntityTypeRowId IN
(SELECT ManagedEntityTypeRowId
FROM dbo.ManagedEntityDerivedTypeHierarchy
((SELECT ManagedEntityTypeRowId
FROM vManagedEntityType
WHERE (ManagedEntityTypeSystemName = 'system.group')), 0)))

Back to SQL queries main menu