How to View the SQL Statement in a Report

Aplica-se a: 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 queries 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 query is used in a Configuration Manager report.


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.

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

Consulte Também

For additional information, see Configuration Manager 2007 Information and Support.
To contact the documentation team, email