4 the alertconfig table, The alertconfig table – HP 3PAR System Reporter Software User Manual

Page 297

Advertising
background image

10.5

Administrative Tables

System Reporter 2.8

3PAR System Reporter User’s Guide

10.3.4 The alertconfig Table

The alertconfig_2 table contains a row for each alert configuration rule.

Table 10-4. alertconfig_2 Table

Column

Type

Comment

alertid

INTEGER PRIMARY

KEY

(AUTO_INCREMENT)

A unique identifier for each rule.

data_table

VARCHAR(32) NOT

NULL

The data table on which the rule operates.

Currently supported values are:

statport

statport_nodesum

statport_syssum

statpd, statpd_nl7

stapd_fc10

statpd_fc15

statpd_ssd150

statpd_sum

statpd_nl7sum

statpd_fc10sum

statpd_fc15sum

statpd_ssd150sum

statld

statvlun

statcpu

resolution

VARCHAR(32) NOT

NULL

The sample resolution, one of hires,

hourly or daily.

inserv

VARCHAR(32) NOT

NULL

The InServ system name that the alert rule

is applied to. If this is the empty string

(blank) then the alert rule is applied to all

InServ systems. If this is not the empty

string, it should match one of the values in

the name column of the system_3 table.

Advertising