User Manual

9 Database Schema
Using The Database Schema
The description of the database schema is provided as a convenience to those wishing to query
the database directly instead of using the web queries described in “Web Queries” (page 127).
However, if you wish to write your own applications that directly query the database, it is important
to note the following caution:
CAUTION: The database schema may change between releases of the System Reporter and
users must be prepared to revise their applications accordingly.
HP does not provide direct assistance in generating SQL queries and only users who are confident
of their own database expertise to use the schema description in this chapter should attempt to use
it to create applications.
Users may only issue queries that read the database, not alter it.
Table Versions and Naming Conventions
All tables are versioned and their version number appears at the end of the table names.
Administrative tables contain only the base name and version number. For example policy_1 is
the policy table and it is version 1.
The sample data tables and the inventory tables include the base name, sampling resolution and
the version number. For example, pdspace_hourly_3 contains the PD (physical disk) space data
for hourly resolution samples and the table is version 3. Similarly, the pdspaceinv_hourly_2 table
contains the inventory of the distinct PDs in the pdspace_hourly_3 table and is of revision 2. Note
that the revision number of the inventory table need not be the same as the revision number of the
data table whose inventory it contains.
When System Reporter is upgraded some tables may need to be converted to new version numbers.
This is done automatically by the System Reporter when the sampling service starts.
Administrative Tables
The administrative tables are used to control the behavior of System Reporter and to keep track of
the systems that are to be sampled.
The policy Table
The policy_1 table stores the names and values of the sampling policy parameters. There are a
fixed number of rows, one per parameter. The parameters are described in Table 54 (page 113).
Table 59 policy_1 Table
CommentTypeColumn
Name of the policy parameterVARCHAR(32) PRIMARY KEYname
Value of the policy parameterVARCHAR(255)val
The sampleinserv Table
The sampleinserv_5 table contains a row for each of systems that the System Reporter must sample.
192 Database Schema