Brocade Network Advisor Documentation Updates v11.1.x (53-1002363-03, August 2011)

22 Brocade Network Advisor Documentation Updates
53-1002363-02
Database tables and fields
E
ENTITY_CATEGORY Either "fabric" or "product (switch or device)" or "port"; or
combination of these 3 basic categories.
Default value is 0.
varchar 128
COLUMN_INDEX 0 = Predefined column.
1 = First user-defined column.
2 = Second user-defined column.
3 = Third user-defined column.
Default value is 0.
small int
DESCRIPTION Column description, typically populated for user-defined
columns.
varchar 255
ICON_ID Not used. int
VISIBLE 1 = all predefined / fixed columns.
0 = user-defined columns.
Default value is 0.
smallint
EDITABLE 1 = column is editable.
0 = column is not editable.
Default value is 1.
smallint
TABLE 16 CLIENT_VIEW_MEMBER
Field Definition Format Size
CLIENT_VIEW_ID * Foreign key to CLIENT_VIEW table. int
FABRIC_ID * Foreign key to FABRIC table. int
TABLE 17 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.
smallint
SECURE 1 = it is a secured fabric. smallint
AD_ENVIRONMENT 1 = there are user-defined ADs in this fabric. smallint
MANAGED 1 = it is an actively "monitored" fabric; otherwise, it is an
"unmonitored" fabric
smallint
TABLE 15 CLIENT_VIEW_COLUMN (Continued)
Field Definition Format Size