Creating Reports for SCOM and SCVMM - Microsoft System Center Reporting - page 192

To retrieve a list of all managed entities including their 16 x 16 icon and diagram image,
you can run the following query using the OperationsManagerDW database:
SELECT
ME.ManagedEntityRowId,
ME.FullName,
MET.ManagedEntityTypeSystemName,
METIicon.Image AS [Icon_16x16],
METIdiagram.Image AS [Icon_Diagram]
FROM
vManagedEntity ME
INNER JOIN vManagedEntityType MET ON
ME.ManagedEntityTypeRowId = MET.ManagedEntityTypeRowId
INNER JOIN vManagedEntityTypeImage METIicon ON
MET.ManagedEntityTypeRowId =
METIicon.ManagedEntityTypeRowId
AND METIicon.ImageCategory = 'u16x16Icon'
INNER JOIN vManagedEntityTypeImage METIdiagram ON
MET.ManagedEntityTypeRowId =
METIdiagram.ManagedEntityTypeRowId
AND METIdiagram.ImageCategory = 'DiagramIcon'
vManagementPack
You can use the vManagementPack view to filter objects in the OperationsMan-
agerDW database by specific management packs. A typical example includes filtering
managed entities by entity types that derive from a particular management pack, or you
can filter rules and monitors by the management packs they are defined in.
The following query using the OperationsManagerDW database returns all the man-
aged entities that are of a managed type, which is defined in the Mi-
crosoft.Windows.Library management pack:
SELECT
ME.ManagedEntityRowId,
ME.Name,
ME.FullName,
MET.ManagedEntityTypeSystemName
FROM