Brocade Network Advisor SAN User Manual v12.0.0 (53-1002696-01, April 2013)

1224 Brocade Network Advisor SAN User Manual
53-1002696-01
Database tables and fields
H
SERIAL_NUMBER The serial number of the chassis. varchar 32
PRODUCT_TYPE Product type based on sysoid or architecture type
and management module main board id.
varchar 32
TABLE 140 FOUNDRY_PHYSICAL_PORT
Field Definition Format Size
PHYSICAL_PORT_ID Database ID of PHYSICAL_PORT instance. int
CONNECTOR_TYPE The type of connector that the port offers. Refer
snSwPortInfoConnectorType of foundry.mib for more
details and possible values.
smallint
MEDIA_TYPE The media type for the port. Refer
snSwPortInfoMediaType of foundry.mib for more
details and possible values.
smallint
GIG_TYPE smallint
TABLE 141 FPORT_TRUNK_GROUP
Field Definition Format Size
ID* Unique generated database identifier. int
VIRTUAL_SWITCH_ID Virtual switch ID where this F_Port Trunk Group is
defined.
int
MASTER_USER_PORT User port number for the master port of this trunk. smallint
WWN WWN of the trunk group. char 23
TRUNK_AREA User-assigned area number used to group together
F_ports of the trunk.
smallint
TABLE 142 FPORT_TRUNK_MEMBER
Field Definition Format Size
GROUP_ID* Foreign key to the PORT_TRUNK_GROUP table. int
PORT_NUMBER* Member user port number. smallint
WWN Member port WWN. char 23
TABLE 143 FRU
Field Definition Format Size
ID Unique generated database identifier. int
CORE_SWITCH_ID int
TAG provides the TAG number of FRU element, requested by
SMIA and values filled in by Switch Asset Collector. Field
probably contains information such as asset tag or
serial number data. This value varies depending on the
type of physical package
varchar 64
TABLE 139 FOUNDRY_PHYSICAL_DEVICE (Continued)
Field Definition Format Size