SCCM : The “Creating Custom Reports by Using Configuration Manager 2007 SQL Views” documentation package is now available for download!!

November 3, 2008 at 6:09 am in ConfigMgr, ConfigMgr 2007, SCCM 2007 by Kenny Buntinx [MVP]

Creating custom reports in Configuration Manager can be a challenge, not only to create the SQL statement for the report, but to figure out what SQL view contains the information you need and how the SQL views can be joined together. The Windows Installer CreatingCustomReportsByUsingSQLViews.msi package provides information that will help you to create custom reports, determine which Configuration Manager SQL views contain the information you need for your reports, and identify a path between the necessary SQL views and determine what columns can be used to join them. The download package includes the following files:

· Before You Use – Readme document (BeforeYouUse_Readme.doc): Provides information about how to use the other documents in the Windows Installer download package.

· Using Configuration Manager 2007 SQL Views to Create Custom Reports help file (CM2007CustomReports.chm): Provides 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. This documentation will be your main resource throughout the process of creating your custom report.

· Configuration Manager 2007 SQL View Schema Microsoft Visio document (CM2007SQLViewsSchema.vsd): Provides the Configuration Manager 2007 SQL views schema, organized by category.

· Configuration Manager 2007 SQL Views Excel spreadsheet (CM2007SQLViews.xls): Provides a list of the Configuration Manager 2007 SQL views with descriptions, a list of the SQL views and columns ordered by SQL view name, and a list of the SQL views and columns ordered by column name.

The Windows Installer CreatingCustomReportsByUsingSQLViews.msi package can be downloaded from: http://www.microsoft.com/downloads/details.aspx?FamilyId=87BBE64E-5439-4FC8-BECC-DEB372A40F4A&displaylang=en.

This has been written by the configuration manager writers .

Hope it helps ,

Kenny Buntinx