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

Capability, TABLE 3

Page 26 highlights

E Database tables and fields TABLE 3 Field ACH_EVENT_FILTER_MAP Definition FILTER_ID * EVENT_ID * ID of the event filter. Event ID which needs to be associated with the filter. Format int int TABLE 4 Field ACH_EVENT Definition ID * REASON_CODE FRU_CODE DESCRIPTION SEVERITY TYPE Reason code of the event. FRU code of the event. Description of the event. Severity of the event. Type of the event. Format int varchar varchar varchar int varchar TABLE 5 Field ACH_INFO Definition ID* SWITCH_WWN WWN of the switch. FILTER_ID If an event filter is assigned to the switch - the filter ID if no filter is assigned - null. CALL_CENTER_ID ID of the call center to which the switch is assigned. SUPPORT_SAVE 1 = Support save is enabled for the switch. 0 = Support save is disabled for the switch. MANAGED_ELEMENT_ID Managed element Id for the device. Default value is -1. Format int varchar int int smallint int TABLE 6 Field ACH_FILTER Definition ID* NAME DESCRIPTION Name of the event filter. Description of the event filter. Format int varchar varchar Capability TABLE 7 Field CAPABILITY_ Definition NAME * DESCRIPTION Name of the capability. Optional detailed description about the capability. Format varchar varchar Size Size 256 256 256 256 Size 23 Size 256 256 Size 256 512 18 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

18
Brocade Network Advisor Documentation Updates
53-1002363-02
Database tables and fields
E
TABLE 3
ACH_EVENT_FILTER_MAP
Field
Definition
Format
Size
FILTER_ID *
ID of the event filter.
int
EVENT_ID *
Event ID which needs to be associated with the filter.
int
TABLE 4
ACH_EVENT
Field
Definition
Format
Size
ID *
int
REASON_CODE
Reason code of the event.
varchar
256
FRU_CODE
FRU code of the event.
varchar
256
DESCRIPTION
Description of the event.
varchar
256
SEVERITY
Severity of the event.
int
TYPE
Type of the event.
varchar
256
TABLE 5
ACH_INFO
Field
Definition
Format
Size
ID*
int
SWITCH_WWN
WWN of the switch.
varchar
23
FILTER_ID
If an event filter is assigned to the switch - the filter ID
if no filter is assigned - null.
int
CALL_CENTER_ID
ID of the call center to which the switch is assigned.
int
SUPPORT_SAVE
1 = Support save is enabled for the switch.
0 = Support save is disabled for the switch.
smallint
MANAGED_ELEMENT_ID
Managed element Id for the device.
Default value is -1.
int
TABLE 6
ACH_FILTER
Field
Definition
Format
Size
ID*
int
NAME
Name of the event filter.
varchar
256
DESCRIPTION
Description of the event filter.
varchar
256
Capability
TABLE 7
CAPABILITY_
Field
Definition
Format
Size
NAME *
Name of the capability.
varchar
256
DESCRIPTION
Optional detailed description about the capability.
varchar
512