Servers

    Creating Custom Reports By Using Configuration Manager 2007 SQL Views

    Language:
    English
    This documentation provides the information to help you create custom reports, determine which Configuration Manager 2007 SQL views contain the information you need for your reports, and identify the path between the necessary SQL views and determine what columns can be used to join them.
    • Version:

      1.0

      File Name:

      CreatingCustomReportsByUsingSQLViews.msi

      Date Published:

      10/29/2008

      File Size:

      2.2 MB

        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.

        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.
    • Supported Operating System

      Windows Server 2003, Windows Vista, Windows XP

        Microsoft Visio, Microsoft Excel, Microsoft Word
        1. Click the Download button to start the download.
        2. Do one of the following:
          • To start the installation immediately, click Open.
          • To copy the download to your computer for installation at a later time, click Save.
          • To cancel the installation, click Cancel.

    Popular downloads

    Loading your results, please wait...

    Free PC updates

    • Security patches
    • Software updates
    • Service packs
    • Hardware drivers

    Microsoft suggests

    Download a free trial of Windows Server 2012 R2.
    Windows Server 2012 R2 free trial
    Experience the new and enhanced capabilities.
    Free trial