HP Brocade 8/12c Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 47

Table 60, Ras_log, Event_notification, Event Continued

Page 47 highlights

Database tables and fields E TABLE 59 Field EVENT (Continued) Definition Format EVENT_COUNT Number of occurrences of the event.. int Default value is 1. RESOLVED Resolution status of the event. Default value is 0. smallint ACKED_TIME Time at which the event is acknowledged. Timestamp FIRST_OCCURRENCE_HOST First occurrence host time; this is set to GMT time. _TIME timestamp EVENT_AUDIT Flag to indicate if the event is audited. varchar EVENT_KEY This field is a combination of ModuleName and varchar EventNumber which is unique within the given module. EVENT_ACTION_ID Weak reference to ACTION ID present in int EVENT_ACTION table. This can be a null and hence maintained as a weak reference. DEVICE_GROUP_ID Weak reference to DEVICE GROUP ID present in int DEVICE_GROUP table. This can be a null and hence maintained as a weak reference. PORT_GROUP_ID Weak reference to PORT_GROUP ID present in int PORT_GROUP table. This can be a null and hence maintained as a weak reference. TABLE 60 Field RAS_LOG MSG_ID* MODULE_ID SEVERITY CAUSE ACTION OLD_MSG_ID Definition Message ID of the event. Module ID of the event. Severity of the event. Probable root cause for the event. Recommended action for the event. Old message ID. Format varchar varchar varchar varchar varchar varchar TABLE 61 Field EVENT_NOTIFICATION Definition Format ID* STATUS SERVER_NAME REPLY_ADDRESS SEND_ADDRESS SMTP_PORT int Status of Event Notification. value will be 0 if disabled, smallint 1 otherwise. Default value is 0. E-mail (SMTP) server name. varchar Reply E-mail address. varchar E-mail address for which a Test E-mail notification is to varchar be sent. SMTP Port number. int Default value is 25. Size 10 255 Size 15 10 10 4096 4096 45 Size 256 50 512 Brocade Network Advisor Documentation Updates 39 53-1002363-02

  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12
  • 13
  • 14
  • 15
  • 16
  • 17
  • 18
  • 19
  • 20
  • 21
  • 22
  • 23
  • 24
  • 25
  • 26
  • 27
  • 28
  • 29
  • 30
  • 31
  • 32
  • 33
  • 34
  • 35
  • 36
  • 37
  • 38
  • 39
  • 40
  • 41
  • 42
  • 43
  • 44
  • 45
  • 46
  • 47
  • 48
  • 49
  • 50
  • 51
  • 52
  • 53
  • 54
  • 55
  • 56
  • 57
  • 58
  • 59
  • 60
  • 61
  • 62
  • 63
  • 64
  • 65
  • 66
  • 67
  • 68
  • 69
  • 70
  • 71
  • 72
  • 73
  • 74
  • 75
  • 76
  • 77
  • 78
  • 79
  • 80
  • 81
  • 82
  • 83
  • 84
  • 85
  • 86
  • 87
  • 88
  • 89
  • 90
  • 91
  • 92
  • 93
  • 94
  • 95
  • 96
  • 97
  • 98
  • 99
  • 100
  • 101
  • 102
  • 103
  • 104
  • 105
  • 106
  • 107
  • 108
  • 109
  • 110
  • 111
  • 112
  • 113
  • 114
  • 115
  • 116
  • 117
  • 118
  • 119
  • 120
  • 121
  • 122
  • 123
  • 124
  • 125
  • 126
  • 127
  • 128
  • 129
  • 130
  • 131
  • 132
  • 133
  • 134
  • 135
  • 136
  • 137
  • 138
  • 139
  • 140
  • 141
  • 142
  • 143
  • 144
  • 145
  • 146
  • 147
  • 148
  • 149
  • 150
  • 151
  • 152
  • 153
  • 154
  • 155
  • 156
  • 157
  • 158
  • 159
  • 160
  • 161
  • 162
  • 163
  • 164
  • 165
  • 166
  • 167
  • 168
  • 169
  • 170
  • 171
  • 172
  • 173
  • 174
  • 175
  • 176
  • 177
  • 178
  • 179
  • 180
  • 181
  • 182
  • 183
  • 184
  • 185
  • 186
  • 187
  • 188
  • 189
  • 190
  • 191
  • 192
  • 193
  • 194
  • 195
  • 196
  • 197
  • 198
  • 199
  • 200
  • 201
  • 202
  • 203
  • 204
  • 205
  • 206
  • 207
  • 208
  • 209
  • 210
  • 211
  • 212
  • 213
  • 214
  • 215
  • 216
  • 217
  • 218
  • 219
  • 220
  • 221
  • 222
  • 223
  • 224
  • 225
  • 226
  • 227
  • 228
  • 229
  • 230
  • 231
  • 232
  • 233
  • 234
  • 235
  • 236
  • 237
  • 238
  • 239
  • 240
  • 241
  • 242
  • 243
  • 244
  • 245
  • 246
  • 247
  • 248
  • 249
  • 250
  • 251
  • 252
  • 253
  • 254
  • 255
  • 256
  • 257
  • 258
  • 259
  • 260
  • 261
  • 262
  • 263
  • 264
  • 265
  • 266
  • 267
  • 268
  • 269
  • 270
  • 271

Brocade Network Advisor Documentation Updates
39
53-1002363-02
Database tables and fields
E
EVENT_COUNT
Number of occurrences of the event..
Default value is 1.
int
RESOLVED
Resolution status of the event.
Default value is 0.
smallint
ACKED_TIME
Time at which the event is acknowledged.
Timestamp
FIRST_OCCURRENCE_HOST
_TIME
First occurrence host time; this is set to GMT time.
timestamp
10
EVENT_AUDIT
Flag to indicate if the event is audited.
varchar
255
EVENT_KEY
This field is a combination of ModuleName and
EventNumber which is unique within the given module.
varchar
EVENT_ACTION_ID
Weak reference to ACTION ID present in
EVENT_ACTION table. This can be a null and hence
maintained as a weak reference.
int
DEVICE_GROUP_ID
Weak reference to DEVICE GROUP ID present in
DEVICE_GROUP table. This can be a null and hence
maintained as a weak reference.
int
PORT_GROUP_ID
Weak reference to PORT_GROUP ID present in
PORT_GROUP table. This can be a null and hence
maintained as a weak reference.
int
TABLE 60
RAS_LOG
Field
Definition
Format
Size
MSG_ID*
Message ID of the event.
varchar
15
MODULE_ID
Module ID of the event.
varchar
10
SEVERITY
Severity of the event.
varchar
10
CAUSE
Probable root cause for the event.
varchar
4096
ACTION
Recommended action for the event.
varchar
4096
OLD_MSG_ID
Old message ID.
varchar
45
TABLE 61
EVENT_NOTIFICATION
Field
Definition
Format
Size
ID*
int
STATUS
Status of Event Notification. value will be 0 if disabled,
1 otherwise.
Default value is 0.
smallint
SERVER_NAME
E-mail (SMTP) server name.
varchar
256
REPLY_ADDRESS
Reply E-mail address.
varchar
50
SEND_ADDRESS
E-mail address for which a Test E-mail notification is to
be sent.
varchar
512
SMTP_PORT
SMTP Port number.
Default value is 25.
int
TABLE 59
EVENT (Continued)
Field
Definition
Format
Size