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.

Procedure

To view the query statement in a Configuration Manager report

  1. In the Configuration Manager console, navigate to System Center Configuration 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.

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

See Also