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.
To view the query statement in a Configuration Manager report
In the Configuration Manager console, navigate to System CenterConfiguration Manager / Site Database / Computer Management / Reporting / Reports.
Right-click the report of your choice, and then click Properties.
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.