Working with Reports

 

As you drill down through reports while working in IBM Tivoli Storage Resource Manager's Reporting facility, you will notice a set of options that repeats for each report type. These By Clauses allow you to generate variations of the reports with different perspectives and groupings of the data.

 

The available By Clauses are described in the following table:

By Clause

Description

By Computer
(Oracle, SQL Server, Sybase, UDB)

Use this clause to select the computers (where Instances are running) that you want to report upon and the report that will be generated based upon those computers.

By Computer Group

(Oracle, SQL Server, Sybase, UDB)

Use this clause to select the computer groups that you want to report upon and the report that will be generated based upon those computer groups.

By Container
(UDB)

Use this clause to select the containers that you want to report upon and the report that will be generated based upon those containers.

By Data File
(Oracle, SQL Server)

Use this clause to select the data files that you want to report upon and the report that will be generated based upon those data files.

By Database

(Oracle, SQL Server, Sybase, UDB)

Use this clause to select the database that you want to report upon and the report that will be generated based upon those databases.

By Database Group

(SQL Server, Sybase, UDB)

Use this clause to select the database groups that you want to report upon and the report that will be generated based upon those groups.

By Fragments
(Sybase)

Use this clause to select the fragments that you want to report upon and the report that will be generated based upon those fragments.

By Instance
(Oracle, Sybase, SQL Server, UDB)

Use this clause to select the Instances that you want to report upon and the report that will be generated based upon those Instances.

Network Wide

(Oracle, SQL Server, Sybase)

The reports and charts that you see will be generated on all data, network wide. This allows you to get a global view of the storage and storage usage for your whole enterprise.

By Table

(Oracle, SQL Server, Sybase)

Use this clause to select the tables that you want to report upon and the report that will be generated based upon those tables.

By Table Group

(Oracle, SQL Server, Sybase, UDB)

Use this clause to select the table groups that you want to report upon and the report that will be generated based upon those table groups.

By Tablespace
(Oracle, UDB)

Use this clause to select the tablespaces that you want to report upon and the report that will be generated based upon those tablespaces.

By Tablespace Group
(Oracle, UDB)

Use this clause to select the tablespace groups that you want to report upon and the report that will be generated based upon those tablespace groups.

 

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