Creating Custom Reports By Using Configuration Manager 2007 SQL Views

Microsoft has released a new document to help you create custom reports.

You can download it here.

Overview

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.

Continue reading at our new blog - http://www.dario.co.il/blog/?p=366