For the longest time, System Center Configuration Manager customers have had to rely on community participation to understand, create, and utilize custom reports. On the backend, ConfigMgr utilizes WMI to retrieve information for collections and queries, but the SQL views are used for reporting with SQL Server Reporting Services (SSRS).
Until now, the creation of custom reports has been left up to the community, but Microsoft has now released actual documentation to help customers learn how to create their own.
The main page, Creating Custom Reports by Using SQL Server Views in System Center 2012 Configuration Manager, contains three main sections:
- SQL Server Views in System Center 2012 Configuration Manager
- Working with Reports in System Center 2012 Configuration Manager
- Technical Reference for SQL Server Views in System Center 2012 Configuration Manager
For those interested in how the WMI schema relates to the SQL View schema, the last one, the technical reference, is a great resource.
This new documentation offering was co-developed and tested by the community.