Database Reference
In-Depth Information
How to do it...
In this example, we will create a report using Report Builder; this report shows all state
changes for a particular monitored object and monitor. Both the monitored object and the
monitor will be made available as parameters in the report.
For this to work, we will use several datasets in our report; they are described in the follow-
ing table:
Dataset
Description
This dataset is used as the source of a parameter in our report. This parameter allows us to pick the managed entity type for the
report.
PSTypes
This dataset is used as the source of a parameter in our report. This parameter allows us to pick the managed entity for the re-
port.
PSObjects
PSMonitors
This dataset is used as the source of a parameter in our report. This parameter allows us to pick the monitor for the report.
DSState
This dataset returns state changes of the selected managed entity and monitor.
Perform the following steps:
1. Start Report Builder (use the Report Manager website or run from a standalone in-
stallation).
2. Under
New Report
, select
Blank Report
.
3. In the
Report Data
area, right-click on
Data Sources
and add the
Operation-
sManagerDW
shared data source.
4. Click on
Test Connection
. Then, click on
OK
.
5. In the
Report Data
area, right-click on
Datasets
and add a dataset named
PSTypes
(type this in the
Name:
field). Select the
Use a dataset embedded in
my report
option, select the
OperationsManagerDW
data source, select
Text
for the query type, and type the following text. Then, click on
OK
:
SELECT DISTINCT
MET.ManagedEntityTypeRowId AS [Id],
MET.ManagedEntityTypeDefaultName AS [Name]
FROM
vManagedEntityMonitor MEM