The All collections report is one of the existing reports in Configuration Manager 2007 and is a good example of a basic report. To open the report, use the following procedure:

To open the All collections report
  1. Open the Configuration Manager console.

  2. Navigate to System Center Configuration Manager / Site Database / Computer Management / Reporting / Reports. The Configuration Manager reports display in the Report pane.

  3. In the display pane, right-click the All collections report, and then click Properties to open the All collections Report Properties dialog box.

  4. Click Edit SQL Statement to open the Report SQL Statement dialog box. The SQL statement is listed in the SQL statement: pane.

  5. Click Close to close the Report SQL Statement dialog box.

  6. Click the Links tab for information about the linked target report.

The SQL statement and report link properties of the All collections report are listed below:

SQL statement

SELECT Name, Comment, CollectionID FROM v_Collection order by Name

Link Properties

Link Type: Link to another report

Target Report Name: All resources in a specific collection

Column: 3

The query retrieves the Name, Comment, and CollectionID columns from the v_Collection view and sorts the results by the Name column. This report also has a report link to the All resources in a specific collection report. The data from the third column of the All collections report will be passed to the All resources in a specific collection report report prompt variable. In this case, the CollectionID is defined in the SQL statement as the third column. The All collections report does not contain a report prompt.