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.
Search WWH ::




Custom Search