Brocade Network Advisor 12.1.X Documentation Updates (53-1003016-05, January 2014)

1392 Brocade Network Advisor SAN User Manual
53-1002948-01
Database tables and fields
H
MEDIA_TYPE The media type for the port. Refer
snSwPortInfoMediaType of foundry.mib for more
details and possible values.
smallint
GIG_TYPE smallint
TABLE 201 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 202 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 203 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
PART_NUMBER provides the part number of the FRU element,
requested by SMIA and values filled in by Switch Asset
Collector. Field probably contains the part number
assigned by the organization responsible for producing
or manufacturing the physical element
varchar 64
SERIAL_NUMBER provides the serial number of the FRU element,
requested by SMIA and values filled in by Switch Asset
Collector
varchar 64
VENDOR_PART_
NUMBER
provides the Vendor-assigned part number of this
package, requested by SMIA and values filled in by
Switch Asset Collector
varchar 64
TABLE 200 FOUNDRY_PHYSICAL_PORT (Continued)
Field Definition Format Size