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

TABLE 65, FABRIC, SAN Continued

Page 50 highlights

E Database tables and fields TABLE 64 Field SAN (Continued) Definition STATS_COLLECTION CREATION_TIME LAST_UPDATE_TIME 1 = statistics collection is enabled; otherwise, 0. Default value is 0. time at which this record was created. Default value is 'now()'. time when this was last updated. Default value is 'now()'. Format Size smallint timestamp timestamp TABLE 65 Field FABRIC Definition Format Size ID* int SAN_ID Foreign key to SAN table; usually 1 since there is only int one SAN. SEED_SWITCH_WWN WWN of the virtual switch used as seed switch to char 23 discover the fabric. NAME User-assigned fabric name. varchar 256 CONTACT User-assigned "contact" for the fabric. varchar 256 LOCATION User-assigned "location" for the fabric. varchar 256 DESCRIPTION User-assigned fabric description. varchar 256 TYPE Type of fabric: 0 = legacy fabric 1 = base fabric 2 = logical fabric Default value is 0. smallint SECURE 1 = it is a secured fabric. Default value is 0. smallint AD_ENVIRONMENT 1 = there are user-defined ADs in this fabric. Default value is 0. smallint MANAGED 1 = it is an actively "monitored" fabric; otherwise, it is an "unmonitored" fabric. Default value is 1. smallint MANAGEMENT_STATE Bit map to indicate various management indications for the fabric. Default value is 0. smallint TRACK_CHANGES 1 = changes (member switches, ISL and devices) in the fabric are tracked. Default value is 0. smallint STATS_COLLECTION 1 = statistics collection is enabled on the fabric. Default value is 0. smallint CREATION_TIME When the fabric record is inserted, i.e., created. Default value is 'now()'. timestamp LAST_FABRIC_CHANGED Time when fabric last changed. timestamp LAST_SCAN_TIME timestamp 42 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

42
Brocade Network Advisor Documentation Updates
53-1002363-02
Database tables and fields
E
STATS_COLLECTION
1 = statistics collection is enabled; otherwise, 0.
Default value is 0.
smallint
CREATION_TIME
time at which this record was created.
Default value is ’now()’.
timestamp
LAST_UPDATE_TIME
time when this was last updated.
Default value is ’now()’.
timestamp
TABLE 65
FABRIC
Field
Definition
Format
Size
ID*
int
SAN_ID
Foreign key to SAN table; usually 1 since there is only
one SAN.
int
SEED_SWITCH_WWN
WWN of the virtual switch used as seed switch to
discover the fabric.
char
23
NAME
User-assigned fabric name.
varchar
256
CONTACT
User-assigned "contact" for the fabric.
varchar
256
LOCATION
User-assigned "location" for the fabric.
varchar
256
DESCRIPTION
User-assigned fabric description.
varchar
256
TYPE
Type of fabric:
0 = legacy fabric
1 = base fabric
2 = logical fabric
Default value is 0.
smallint
SECURE
1 = it is a secured fabric.
Default value is 0.
smallint
AD_ENVIRONMENT
1 = there are user-defined ADs in this fabric.
Default value is 0.
smallint
MANAGED
1 = it is an actively "monitored" fabric; otherwise, it is
an "unmonitored" fabric.
Default value is 1.
smallint
MANAGEMENT_STATE
Bit map to indicate various management indications
for the fabric.
Default value is 0.
smallint
TRACK_CHANGES
1 = changes (member switches, ISL and devices) in
the fabric are tracked.
Default value is 0.
smallint
STATS_COLLECTION
1 = statistics collection is enabled on the fabric.
Default value is 0.
smallint
CREATION_TIME
When the fabric record is inserted, i.e., created.
Default value is ’now()’.
timestamp
LAST_FABRIC_CHANGED
Time when fabric last changed.
timestamp
LAST_SCAN_TIME
timestamp
TABLE 64
SAN (Continued)
Field
Definition
Format
Size