HP 3PAR System Reporter Software - Manual (Page 196)

Table 62 system_4 Table (continued)
Comment Type Column
System hardware model, for example: VARCHAR(32) NOT
NULL system_model
InServ S400X
InServ T400
Indicates the chunklet size. INTEGER NOT NULL CHSIZEMB
The alertconfig Table
The alertconfig_2 table contains a row for each alert configuration rule.
Table 63 alertconfig_2 Table
Comment Type Column
A unique identifier for each rule. INTEGER PRIMARY KEY
(AUTO_INCREMENT) alertid
The data table on which the rule operates. Currently supported
values are: statport statport_1g statport_2g statport_4g VARCHAR(32) NOT
NULL data_table
statport_8g statport_hostnodesum statport_nodesum
statport_disknodesum statport_syssum statpd, statpd_nl7
stapd_fc10 statpd_fc15 statpd_ssd150statpd_sum statpd_nl7sum
statpd_fc10sum statpd_fc15sum statpd_ssd150sum statld statvlun
statcpu
The sample resolution, one of hires, hourly or daily. VARCHAR(32) NOT
NULL resolution
The system name that the alert rule is applied to. If this is the
empty string (blank) then the alert rule is applied to all systems. VARCHAR(32) NOT
NULL inserv
If this is not the empty string, it should match one of the values
in the name column of the system_4 table.
The metric that is calculated. The supported values depend on
the data_table value. VARCHAR(32) NOT
NULL metric
How the metric is compared against the limit_val. Currently this
should be either > (greater than) or < (less than). VARCHAR(32) NOT
NULL direction
The calculated metric is compared based on direction against
limit_val. DOUBLE PRECISION
NOT NULL limit_val
In each sample interval if the number of objects for which the
metric values exceed limit_val when compared using direction
is greater than limit_count then an email alert is generated. INTEGER NOT NULL limit_count
Defines an additional condition that must be met for certain alerts
to be generated. See
“Condition” (page 124) .
VARCHAR(32) condition_code
Defines a value used in conjunction with condition_code. See
“Condition Value” (page 124) .
DOUBLE PRECISION
NOT NULL condition_val
The email address to which alerts for this rule should be sent. VARCHAR(64) recipient
The scheduled_report Table
The scheduled_report_2 table contains a row for each scheduled report and defines where the
report should be stored, when it should be run and parameters used to generate the report.
196 Database Schema