Share via

How to View a Configuration Manager Report SQL Statement

  • Artikel

Betrifft: 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

Reports in Configuration Manager 2007 can be based on simple SQL statements or very complex ones that prompt the user for information, join several Microsoft SQL Server views, and use filters to limit the results. Use the following procedure to find out what SQL statement is used in a Configuration Manager report.

Procedure

To view the query statement in a Configuration Manager report

  1. In the Configuration Manager console, navigate to System CenterConfiguration Manager / Site Database / Computer Management / Reporting / Reports.

  2. Right-click the report of your choice, and then click Properties.

  3. Click Edit SQL Statement to open the Report SQL Statement dialog box. The SQL statement for the report is listed in the SQL Statement pane.

    Hinweis

    To copy the SQL statement so that it can be modified in Query Designer, highlight the entire SQL statement and press Ctrl+c.