Database Reference
In-Depth Information
OperationsManagerDW
data source, select
Text
query type, and type the fol-
lowing query. Then, click on
OK
:
SELECT DISTINCT
M.MonitorRowId AS [Id],
M.MonitorDefaultName AS [Name]
FROM
vManagedEntityMonitor MEM
INNER JOIN vMonitor M ON
MEM.MonitorRowId = M.MonitorRowId
WHERE
MEM.ManagedEntityRowId = @Object
ORDER BY
M.MonitorDefaultName
13. In the
Report Data
area, right-click on
Parameters
and add a parameter named
Monitor
. Select the
Text
data type and disable all the options regarding blank,
null, and multiple values. Also, set the visibility to
Visible
.
14. Under
Available Values
, choose
Get values from a query
, pick the
PSMonitors
dataset, and pick
Id
as
Value field
and
Name
as
Label field
. Then, click on
OK
.
15. In the
Report Data
area, right-click on
Datasets
and add a dataset named
DSState
. Select the
Use a dataset embedded in my report
option, select the
OperationsManagerDW
data source, select
Text
query type, and type the fol-
lowing query. Then, click on
OK
:
SELECT
S.DateTime,
HSOld.HealthStateDefaultName AS OldState,
HSNew.HealthStateDefaultName AS NewState
FROM
State.vStateRaw S
INNER JOIN vManagedEntityMonitor MEM ON
S.ManagedEntityMonitorRowId =
MEM.ManagedEntityMonitorRowId
INNER JOIN vHealthState HSOld ON
S.OldHealthState = HSOld.HealthStateRowId
INNER JOIN vHealthState HSNew ON
S.NewHealthState = HSNew.HealthStateRowId
WHERE