Creating Custom Reports by Using Configuration Manager 2007 SQL Views
Applies To: System Center Configuration Manager 2007, System Center Configuration Manager 2007 R2, System Center Configuration Manager 2007 R3, System Center Configuration Manager 2007 SP1, System Center Configuration Manager 2007 SP2
Microsoft System Center Configuration Manager 2007 queries SQL Server views in the Configuration Manager site database when retrieving the information displayed in reports. The Configuration Manager site SQL database contains a large collection of information about the network, computers, users, user groups, and many other components of the computing environment. The database also contains objects that represent Configuration Manager 2007 items such as advertisements, software update deployments, configuration baselines, reports, and status messages. Configuration Manager administrators need to understand the different categories of the SQL views, what information is stored in each view, and how the SQL views can be joined to one another to create reports that return the desired information. Because Configuration Manager queries and collections retrieve information from Windows Management Instrumentation (WMI) instead of Configuration Manager SQL views, it is also helpful to know how the SQL view schema is related to the WMI schema.
This documentation assumes that you have a basic understanding of Configuration Manager 2007 and SQL statements, that you have an active Configuration Manager 2007 infrastructure in place, and that you have a basic understanding of Configuration Manager 2007 reports. For more information about creating reports in Configuration Manager 2007, see Reporting in Configuration Manager (http://go.microsoft.com/fwlink/?LinkId=120047). For more information about how to write basic SQL statements, search for Query Fundamentals in the Microsoft SQL Server 2005 Books Online (http://go.microsoft.com/fwlink/?LinkId=60544).
This documentation includes an overview of the Configuration Manager 2007 SQL view schema and SQL views, an overview of the existing reports and associated reporting procedures, sample SQL statements for each Configuration Manager SQL view category, scenarios for creating custom reports, exercises for creating custom reports, an overview for writing report SQL statements, and an overview of the Configuration Manager Provider WMI schema.
In This Section
- Configuration Manager 2007 SQL Server Views
Provides an overview of Configuration Manager SQL Server views and the types of views created and used by Configuration Manager 2007.
- Configuration Manager Reports
Provides an overview of Configuration Manager 2007 reports, the elements that make up a report, and report procedures.
- Technical Reference
Provides sample SQL statements for each Configuration Manager SQL view category, real-world scenarios and exercises for modifying existing Configuration Manager reports and creating new reports, information about writing SQL statements and the query design tools available in SQL Server that can be used when writing report SQL statements, and an overview of the Configuration Manager WMI Provider schema.
For additional information, see Configuration Manager 2007 Information and Support.
To contact the documentation team, e-mail SMSdocs@microsoft.com.