Selection Tab

 

Use the Selection tab to:

 

 

The following table describes the fields that might appear on the Selection tab (depending on the report you want to generate):

Field Name

Description

Report Filter Specifications. Use the options in this section to fine-tune the generation of the report.

Profile

Use this box allows you to pick what Profile to use when generating the report. If you just want to use the supplied default Profile, then leave the field as is and generate the report. However, if you want to use a customized Profile that you have set up for this reporting, choose that Profile from the drop-down list. Keep in mind that Profiles control what statistics are gathered and also what files are included in that statistical analysis.

Return maximum of __ rows per computer

Use this field to control how many rows are generated in the report. This will allow you to control the size of the report that is generated.

For example, in the Usage > All DBMSs > Tables > Largest Tables > By Instance report, you can enter 10 in the Return maximum of __ rows per <object> field and to limit the number of rows in the report to only 10 tables per Instance. If you have set up scans to collect many more rows than that per Instance, this is an effective and efficient way to control the size of the generated report.

Limit to this time range:

(for Availability reports only)

Use the fields in this section to determine the date range from which to gather availability information for the objects you select.

Selection....

Click the Selection... button to determine the objects (computers, tablespaces, databases, instances, etc.) upon which you want to report. The Select Resources window will be displayed. If you un-check a resource on the Select Resource window, a red triangle icon will be displayed on the Selection... button.

 

If you are generating a Network-wide report, the Selection... button will be disabled because you have chosen to generate the report network wide, for all objects.

Filter...

 

Click the Filter... button to further select or restrict objects on which you want to report. Filters enable you to apply general rules to the report. When you click this button the Edit Filter window will be displayed. For more information on this window, see Filtering the Resources that Appear in a Report.

 

For example, select all computers with the name beginning with w2s-*, or select all tablespaces with percent used space >= to a specific value.

 

If a filter is defined for this report, a red triangle icon is displayed on the Filter... button.

Available Columns /
Included Columns

  • Available Columns. This list box displays the columns that you can include in the generated report that are not already included. If a column appears in the Included Columns list box it will not appear in this list box.
     

  • Included Columns. This list box displays the columns that will appear in the generated report. By default, all the columns for a report are listed in this list box and will be displayed in the generated report. The greyed-out names shown at the top of the list box are frozen columns of the report. They cannot be selected, removed, or re-ordered.

If a column appears in the Available Columns list box it will not appear in this list box.

 

To include a column in a report:

 

  1. Click the name of the column in the Available Columns list box. Use shift+click and crtl+click to select multiple columns.

  2. Click the right arrow button (>>). The columns will now appear in the Included Columns list box.

 

To remove a column in a report:

 

  1. Click the name of the column in the Included Columns list box. Use shift+click and crtl+click to select multiple columns.

  2. Click the left arrow button (<<). The columns will now appear in the Available Columns list box.

Use these buttons to rearrange the order of columns that will appear in a report. To change the order of a column, highlight the column name and click the up or down arrow.

 

Related Topics

RDBMS Support

Working with Reports

Selecting a Report

Selection Tab

Selecting Resources Upon Which to Report

Filtering the Resources that Appear in a Report

Generating a Report

Sorting Columns

Drilling Down a Report Row

Generating a Report Chart

Navigating Tabs

Trending with Historical Data

Printing Reports or Charts