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 and the dataset query discussed in the
Preparing the DPM reporting en-
vironment
and
Preparing a dataset query for a DPM agent status report
recipes in this
chapter.
The following table lists the details required to complete this recipe:
Requirement or information
Description
You need to make sure a data source has been created and should be accessible.
It is stored in a folder on the reporting server called
Data_Sources
.
Use a pre-created shared data source
Ensure the reporting server URL is
http://<SSRS Instance>/Re-
ports
.
The reporting server runs Report Manager
See the steps for creating the required dataset in the
Prepar-
ing a dataset query for a DPM agent status report
recipe
Ensure the dataset query is prepared and tested.
You need a user with the ability to connect to the DPM database using Report
Builder.
Tool and user to connect and create the report
You will need the report name.
The name of the report is
DPM Agent Details
This table will serve as the input for the tasks required to complete this recipe.