Product guide

Configuring database space for a new application 39
Reporting on Your Datacenter
Building the custom query
To build a custom query displaying database configurations in the environment, the
storage administrator:
1. Selects Analysis > Queries > Query Builder
2. Selects Create and the Query Builder Wizard opens.
Note: For full documentation of the Query Builder, refer to the StorageScope
online help. The procedures listed below are described in detail under
“Identifying IT assets for accounting” on page 8.
3. On the Define Initial Settings step of the wizard, chooses a Name, Description,
Category, and Time Period for the query.
4. Selects the following Areas of Interest for the query:
• Hosts: Hosts, Host Devices
•Arrays: Arrays, LUNs
• Databases: Databases, Database Datafiles, Oracle Tablespaces
5. On the Select Columns step of the Query Wizard, chooses the following columns
and orders them as shown below:
• Database.Database Name
• Databases.Database Type
• Oracle Tablespaces.Tablespace Name
• Database Datafiles.Data File Name
•Database Datafiles.Resides On
• Database Datafiles.Data File Capacity (KB)
• Database Datafiles.Used Data File (KB)
• Hosts.Host Name
• Host Devices.Host Device Name
• Arrays. Array Name
• LUNs.LUN Name