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. You must have access to a configured System Center Configuration
environment that has the
Reporting Service Point
role successfully enabled. Additionally,
the account you use must be a member of either the Configuration Manager
Full Adminis-
trator
role or a role with delegated access to create reports.
The following table lists the details required to complete this recipe:
Requirement or information
Description
SharedDS_SCCM
. Follow the steps provided in the
Prepar-
ing the SCCM reporting environment
recipe.
Data source name
Reporting server running the Report Manager for the Config-
uration Manager site
The reporting server URL is
http://<SSRS Instance>/Reports
The
List_Collections
dataset query,
SELECT SiteID AS CollectionID
,CollectionName , CollectionComment AS Description
The query for the
List_Collections
dataset.
FROM v_Collections
Where IsBuiltIn=0
The
CollsForComputers
dataset query,
SELECT v_R_System.Name0 As [Computer Name],
v_Collection.Name As [Collection Name]
FROM v_FullCollectionMembership
The query to get computer collection membership.
JOIN v_R_System ON
v_FullCollectionMembership.ResourceID =
v_R_System.ResourceID
JOIN v_Collection ON
v_FullCollectionMembership.CollectionID =
v_Collection.CollectionID
Draft custom reports
Folder for customer reports
The table will serve as an input for the tasks required to complete this recipe.