Database Reference
In-Depth Information
Getting ready
You must have installed the Report Builder application using one of the two options dis-
cussed in the Installing Report Builder recipe. Additionally, you must have performed the
steps required to create a shared data source, as discussed in the Creating data sources re-
cipe. You will need access to a functional SCCM database with active agents to complete
the steps discussed.
The following table lists the details required to complete this recipe:
Requirement or information
Description
Create a report that lists the computers in SCCM with operating system names. The report must
be accessed using Internet Explorer.
This is the report requirement, including
output target
Data source has been created. It is accessible and stored in a folder on the reporting server called
Data_Sources .
You can use a precreated shared data source
This is the reporting server running the Re-
port Manager
The reporting server URL is http://SEUKSCCM01/Reports .
These are SCCM views containing required
report data
SCCM views with required data: V_GS_SYSTEM and V_GS_OPERATING_SYSTEM
Fields required: computer name and operating system name
These are the required columns in the report
This is a column common to both views and
used as the join
Column that connects the views RESOURCEID
The table will serve as an input for the tasks required to complete this recipe.
Search WWH ::




Custom Search