User Manual

Table 61 system_4 Table (continued)
CommentTypeColumn
System hardware model, for example:VARCHAR(32) NOT
NULL
system_model
InServ S400X
InServ T400
Indicates the chunklet size.INTEGER NOT NULLCHSIZEMB
The alertconfig Table
The alertconfig_2 table contains a row for each alert configuration rule.
Table 62 alertconfig_2 Table
CommentTypeColumn
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_3 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 NULLlimit_count
Defines an additional condition that must be met for certain alerts
to be generated. See “Condition” (page 121).
VARCHAR(32)condition_code
Defines a value used in conjunction with condition_code. See
“Condition Value” (page 122).
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.
194 Database Schema