Database Reference
In-Depth Information
INNER JOIN vManagedEntity ME ON
MEM.ManagedEntityRowId = ME.ManagedEntityRowId
INNER JOIN vManagedEntityType MET ON
ME.ManagedEntityTypeRowId =
MET.ManagedEntityTypeRowId
ORDER BY
MET.ManagedEntityTypeDefaultName
6. In Enter Data Source Credentials , select Use the current Windows user , and
then click on OK .
7. In the Report Data area, right-click on Parameters and add a parameter named
Type . Select the Text data type and ensure that all options regarding blank, null
and allow multiple values are unchecked. Also, set the visibility to Visible .
8. Under Available Values , choose Get values from a query , pick the PSTypes
dataset and pick Id as Value field and Name as Label field . Then, click on OK .
9. In the Report Data area, right-click on Datasets and add a dataset named PSOb-
jects . Select the Use a dataset embedded in my report option, select the Oper-
ationsManagerDW data source, select the Text query type, and paste the fol-
lowing query. Then, click on OK :
SELECT DISTINCT
ME.ManagedEntityRowId AS [Id],
ME.FullName AS [Name]
FROM
vManagedEntityMonitor MEM
INNER JOIN vManagedEntity ME ON
MEM.ManagedEntityRowId = ME.ManagedEntityRowId
WHERE
ME.ManagedEntityTypeRowId = @Type
ORDER BY
ME.FullName
10. In the Report Data area, right-click on Parameters and add a parameter named
Object . Select the Text data type and ensure that all options regarding blank, null,
and allow multiple values are unchecked. Also, set the visibility to Visible .
11. Under Available Values , choose Get values from a query , pick the PSObjects
dataset, and pick Id as Value field and Name as Label field . Then, click OK .
12. In the Report Data area, right-click on Datasets and add a dataset named
PSMonitors . Select the Use a dataset embedded in my report option, select the
Search WWH ::




Custom Search