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

Table 234, Event_category, Event_description, Event_details

Page 130 highlights

E Database tables and fields TABLE 234 EVENT_CATEGORY Field Definition ID DESCRIPTION 0 - Unknown 1 - Product Event 2 - Link Incident Event 3 - Product Audit Event 4 - Product Status Event 5 - Security Event 6 - User Action Event 7 - Management Server Event Format int varchar TABLE 235 EVENT_DESCRIPTION Field Definition ID DESCRIPTION Format int varchar TABLE 236 EVENT_DETAILS Field Definition ID EVENT_ID FIRST_OCCURRENCE_SWI TCH_TIME LAST_OCCURRENCE_SWIT CH_TIME CONTRIBUTORS Populated only for SAN events OPERATIONAL_STATUS Populated only for SAN events - check the constants NODE_WWN Populated only for SAN events PORT_WWN Populated only for SAN events OID VIRTUAL_FABRIC_ID Virtual Fabric Id of the switch UNIT From INM EVENT_MAIN table SLOT From INM EVENT_MAIN table PORT From INM EVENT_MAIN table PRODUCT_ADDRESS RAS_LOG_ID Reference to RAS_LOG table. This will be used to retrieve Probable cause and Recommended cause information in addition to showing MESSAGE_ID information retrieved from SAN switches. Format int int timestamp timestamp varchar varchar varchar varchar varchar smallint smallint int int varchar varchar Size 50 Size 1024 Size 512 255 23 23 50 122 Brocade Network Advisor Documentation Updates 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

122
Brocade Network Advisor Documentation Updates
53-1002363-02
Database tables and fields
E
TABLE 234
EVENT_CATEGORY
Field
Definition
Format
Size
ID
0 - Unknown
1 - Product Event
2 - Link Incident Event
3 - Product Audit Event
4 - Product Status Event
5 - Security Event
6 - User Action Event
7 - Management Server Event
int
DESCRIPTION
varchar
50
TABLE 235
EVENT_DESCRIPTION
Field
Definition
Format
Size
ID
int
DESCRIPTION
varchar
1024
TABLE 236
EVENT_DETAILS
Field
Definition
Format
Size
ID
int
EVENT_ID
int
FIRST_OCCURRENCE_SWI
TCH_TIME
timestamp
LAST_OCCURRENCE_SWIT
CH_TIME
timestamp
CONTRIBUTORS
Populated only for SAN events
varchar
512
OPERATIONAL_STATUS
Populated only for SAN events - check the constants
varchar
255
NODE_WWN
Populated only for SAN events
varchar
23
PORT_WWN
Populated only for SAN events
varchar
23
OID
varchar
50
VIRTUAL_FABRIC_ID
Virtual Fabric Id of the switch
smallint
UNIT
From INM EVENT_MAIN table
smallint
SLOT
From INM EVENT_MAIN table
int
PORT
From INM EVENT_MAIN table
int
PRODUCT_ADDRESS
varchar
RAS_LOG_ID
Reference to RAS_LOG table. This will be used to
retrieve Probable cause and Recommended cause
information in addition to showing MESSAGE_ID
information retrieved from SAN switches.
varchar