Share via

All Collections Report

  • Article

The All collections report is one of the predefined reports in SMS 2003 and is a good example of a basic report. To open the report, use the following procedure:

To open the All collections report

  1. In the SMS 2003 console tree, navigate to and click the Reports node to display all of the available SMS 2003 reports in the display pane:

    Systems Management Server

      + Site Database (site code - site name)

        + Reporting

          + Reports

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

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

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

  5. 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 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 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.