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
Column | Type | Comment |
|
|
|
alertid | INTEGER PRIMARY | A unique identifier for each rule. |
| KEY |
|
| (AUTO_INCREMENT) |
|
|
|
|
data_table | VARCHAR(32) NOT | The data table on which the rule operates. |
| NULL | 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 | The sample resolution, one of hires, |
| NULL | hourly or daily. |
|
|
|
inserv | VARCHAR(32) NOT | The InServ system name that the alert rule |
| NULL | 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. |
|
|
|
Administrative Tables | 10.5 |