Brocade Communications Systems IP250 TABLE 50 0 , TABLE 501 , TABLE 50 2

Brocade Network Advisor IP User Manual 1597
53-1003056-01
Database tables and fields I
TABLE 50 0 VR_CONN_SERVER_PROFILE
Field Definition Format Size
ID Unique generated database identifier. serial
VCEM_PROFILE_ID Foreign key references the ID of the VCEM
server that the server profile belongs to.
int
VR_CONN_DOMAIN_GROUP_I
D
Nullable foreign key references the ID of the
domain group that the server profile may
belong to.
int
VCEM_ASSIGNED_ID The ID assigned by the VCEM server. bigint
NAME varchar 256
BAY_NAME varchar 256
BAY_NUMBER smallint
VIRTUAL_SERIAL_NUMBER varchar 32
CREATION_TIME timestamp
LAST_UPDATE_TIME timestamp
BAY_ENCLOSURE_UUID The UUID extracted from the enclosure
object inside the bay object inside the
server profile. The value matches the
domain GUID.
varchar 512
TABLE 501 VR_CONN_WWN
Field Definition Format Size
ID Unique generated database identifier. int
VR_CONN_FC_CONNECTION_ID Foreign key references the ID of the FC
connection that the WWN belongs to
int
PORT_ADDRESS Port WWN char 23
NODE_ADDRESS Node WWN char 23
SAN_NAME varchar 256
CREATION_TIME timestamp
LAST_UPDATE_TIME timestamp
TABLE 50 2 WIRELESS_PRODUCT_DETAILS
Field Definition Format Size
ID The primary key of the table. int
DEVICE_ID Each AP or Controller has an entry in the
table. No other device will have entries
here. The foreign key reference to device
table.
int
CONTROLLER_DEVICE_ID The reference to the APs controller in
device table. If APs controller gets deleted,
the value sets to null. If the entry is
controller the value is null.
int
PROFILE_NAME Profile name that the AP is using. varchar 64