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

Table 22, Collector_end_timestamp, Virtual_switch_collection, Security_policy

Page 33 highlights

Database tables and fields E TABLE 22 Field COLLECTOR_END_TIMESTAMP Definition Format COLLECTOR_SOURCE * COLLECTOR_NAME * TIMESTAMP_ LAST_COLLECTED_STATUS Internal key for switches and fabrics for which collection is undertaken. varchar Collection name, Java class used to collect specific varchar fabric or switch information. When the last successful collection is done. timestamp Status of the last collection, successful or not. 200 is smallint for successful. Values are standard HTTP protocol values. TABLE 23 Field VIRTUAL_SWITCH_COLLECTION Definition VIRTUAL_SWITCH_ID * COLLECTOR_NAME * LAST_VIRTUAL_SW_ MODIFICATION DB ID of virtual switch. Collector name. Last modified time on switch. Format int varchar timestamp TABLE 24 Field VIRTUAL_SWITCH_CHECKSUM Definition VIRTUAL_SWITCH_ID * CHECKSUM_KEY * CHECKSUM DB ID of virtual switch. Checksum key. Checksum value. Format int varchar varchar TABLE 25 Field CORE_SWITCH_CHECKSUM Definition CORE_SWITCH_ID * CHECKSUM_KEY * CHECKSUM DB ID. Checksum type. Checksum value. Format int varchar varchar TABLE 26 Field CORE_SWITCH_COLLECTION Definition CORE_SWITCH_ID * COLLECTION_NAME * LAST_CORE_SW_ MODIFICATION Core switch ID. Collector name. Last core switch modification time. Format int varchar timestamp TABLE 27 Field SECURITY_POLICY Definition Format VIRTUAL_SWITCH_ID * POLICY_NUMBER* DB ID of virtual_switch. int IPSec Policy Number. The number can range from 1 to smallint 32. Size 256 256 Size 256 Size 32 16 Size 32 16 Size 256 Size Brocade Network Advisor Documentation Updates 25 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
25
53-1002363-02
Database tables and fields
E
TABLE 22
COLLECTOR_END_TIMESTAMP
Field
Definition
Format
Size
COLLECTOR_SOURCE *
Internal key for switches and fabrics for which
collection is undertaken.
varchar
256
COLLECTOR_NAME *
Collection name, Java class used to collect specific
fabric or switch information.
varchar
256
TIMESTAMP_
When the last successful collection is done.
timestamp
LAST_COLLECTED_STATUS
Status of the last collection, successful or not. 200 is
for successful. Values are standard HTTP protocol
values.
smallint
TABLE 23
VIRTUAL_SWITCH_COLLECTION
Field
Definition
Format
Size
VIRTUAL_SWITCH_ID *
DB ID of virtual switch.
int
COLLECTOR_NAME *
Collector name.
varchar
256
LAST_VIRTUAL_SW_
MODIFICATION
Last modified time on switch.
timestamp
TABLE 24
VIRTUAL_SWITCH_CHECKSUM
Field
Definition
Format
Size
VIRTUAL_SWITCH_ID *
DB ID of virtual switch.
int
CHECKSUM_KEY *
Checksum key.
varchar
32
CHECKSUM
Checksum value.
varchar
16
TABLE 25
CORE_SWITCH_CHECKSUM
Field
Definition
Format
Size
CORE_SWITCH_ID *
DB ID.
int
CHECKSUM_KEY *
Checksum type.
varchar
32
CHECKSUM
Checksum value.
varchar
16
TABLE 26
CORE_SWITCH_COLLECTION
Field
Definition
Format
Size
CORE_SWITCH_ID *
Core switch ID.
int
COLLECTION_NAME *
Collector name.
varchar
256
LAST_CORE_SW_
MODIFICATION
Last core switch modification time.
timestamp
TABLE 27
SECURITY_POLICY
Field
Definition
Format
Size
VIRTUAL_SWITCH_ID *
DB ID of virtual_switch.
int
POLICY_NUMBER*
IPSec Policy Number. The number can range from 1 to
32.
smallint