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

1456 Brocade Network Advisor SAN User Manual
53-1002948-01
Database tables and fields
H
SYS_OID This will represent the sys_oid for each product type. varchar 255
PRODUCT_FAMILY This represents the product family that each OID
belongs to.
varchar 128
BRIEF_PRODUCT_FAMILY Shorter name for the product family. varchar 32
SPEED Switch max speed. Value 0 represents NotAvailable. smallint
MULTI_CP_CAPABLE Switch is multi cp cabable or not. 0 means single CP
and 1 means multi.
smallint
MIN_IMAGE_VERSION Supported min firmware version. varchar 64
MAX_IMAGE_VERSION Supported max firmware version. varchar 64
TABLE 361 SWITCH_PORT
Field Definition Format Size
ID* Unique generated database identifier. int
VIRTUAL_SWITCH_ID DB ID of virtual_switch to which this port belongs. int
WWN WWN of the port. char 23
NAME User friendly name of the port. char 32
SLOT_NUMBER Slot number.
Default value is 0.
int
PORT_NUMBER The logical port number of the user port. There is no
assumption of any relation to the physical location of
a port within a chassis.
smallint
USER_PORT_NUMBER User port number. Unique port number in a chassis. smallint
PORT_ID Port ID of this port. varchar 8
PORT_INDEX Number used for identifying port in zoning. smallint
AREA_ID Area number the port is assigned to. smallint
MAC_ADDRESS MAC address of this port. varchar 64
PORT_MOD Stores the port module type. Not applicable if port
doesn't have a GBIC installed.
varchar 64
TYPE Port type. The specific mode currently enabled for the
port. The port type could be U-Port, F-Port, E-Port etc.
varchar 16
FULL_TYPE Refers to the full type of the port, U-Port, F-Port etc. varchar 128
STATUS Refers to the Status of the port. Eg. No Light, No
Module, Mod_inv, Online etc.
varchar 64
HEALTH Refers to the Health of the port. Eg. Unmonitored,
Healthy, Offline , Error etc.
varchar 16
STATUS_MESSAGE Any additional port level status similar to what is
seen in CLI, like Segmented, Speed Mismatch, Trunk
master etc are stored here.
varchar 255
PHYSICAL_PORT Indicates if the port is physical port. It will be 0 for
virtual ports Eg. Ports created by LISLs.
smallint
TABLE 360 SWITCH_MODEL (Continued)
Field Definition Format Size