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