Database Reference
In-Depth Information
Getting ready
You must plan to review Chapter 3 , Unpacking System Center Report Building Tools , as a
primer to this recipe.
Additionally, you must have performed the steps required to create a shared data source as
discussed in the Preparing the DPM reporting environment recipe. You will need access to
a functional DPM database with active agents to complete the steps discussed.
The following table lists the details required to complete this recipe:
Requirement or information
Description
The data source has been created and is accessible. It is stored in a folder on the reporting server
called Data_Sources .
Use a pre-created shared data source
The reporting server URL is http://<SSRS Instance>/Reports .
The reporting server runs Report Manager
The DPM views with the required data are VW_DPM_Agents ,
VW_DPM_ProtectedDataSource , and VW_DPM_ProtectedGroup .
DPM views containing the required report
data
The required fields are ServerName , Agent Version , AllocatedSpace , UsedSpace ,
DPMServer , and ProtectionGroupName .
The required columns in the report
The column is common to the views and
used as the SQL JOIN
You need a column connecting the ServerName and ProtectionGroupID views.
You need a user with the ability to connect to the DPM database using Microsoft SQL Server Man-
agement Studio (for example, <Domain Name\DPMRPT> ).
The tool and the user required to connect
and create the dataset query
This table will serve as the input for the tasks required to complete this recipe.
Search WWH ::




Custom Search