Database Reference
In-Depth Information
Getting ready
To demonstrate the capabilities of the PowerPivot add-in, System Center Operations Man-
ager data is gathered in the dataset and further updated in this recipe. The data is perform-
ance data and the data of interest is the logical free disk space.
You must have access to a fully deployed Operations Manager environment in order to per-
form the steps in this recipe.
To complete this query, follow the instructions from the previous recipe with the informa-
tion that follows:
1. Connect to the
OperationsManager
database and select (after checking the
Select multiple items
option)
Views and Tables
(you will be presented with all
Views and Tables in the database when you connect). These items are sorted first
by
Views
and then by
Tables
in descending order:
◦ The
PerformanceDataAllView
view
◦ The
Rulesview
view and the
BaseManagedEntity
table
◦
PerformanceSource
table
2. Once you have made your selection in the
Navigator
, click on the arrow next to
Load
. Select
Load to…
and click on
Load
.
3. Right-click on
PerformanceDataAllView
and select
Edit
to extend the dataset.
4. Click on
Merge Queries
from the ribbon. Use
PerformanceDataAllView
as the
source (top part of the
Merge
dialog box).
5. Click on the little arrow in the lower pane of the
Merge
window. Select
Perform-
anceSource
as the target.
6. Click on the
PerformanceSourceInternalId
column in the source (
Performan-
ceDataAllView
) and the target (
PerformanceSource
) to be used as the merge
column. Then click on
OK
.
7. Click on the double arrow icon to the right-hand side of the
NewColumn
; uncheck
Select All Columns
; select
BaseManagedEntityId
,
RuleId
, and
PerfmonIn-
stanceName
; and then click on
OK
.
8. Click on
Merge Queries
from the ribbon. Note that you do not need to select a
new source. The result of the previous query (the extended
Performan-
ceDataAllView
view) is the source (top part of the
Merge
dialog box).
9. Click on the little arrow in the lower pane of the
Merge
window and select
RuleView
as the target.
10. Click on the
NewColumn.RuleId
column in the extended source (
Performan-
ceDataAllView
).