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

Brocade Network Advisor SAN User Manual 1227
53-1002696-01
Database tables and fields
H
MAX_SPEED Port maximum speed supported. bigint
MAC_ADDRESS MAC Address of that port. varchar 64
PORT_NAME GigE Port Name. varchar 64
OPERATIONAL_STATUS LED status. int
LED_STATE LED status. smallint
SPEED_LED_STATE GigE Port type details. smallint
PORT_TYPE Port type for the GigE Port. varchar 64
PERSISTENTLY_DISABLED Whether the GigE Port is persistently disabled. smallint
INTERFACE_TYPE smallint
CHECKSUM varchar 16
FCIP_CAPABLE 1 = FCIP capable; otherwise, 0.
Default value is 2.
smallint
ISCSI_CAPABLE 1 = ISCSI capable; otherwise, 0.
Default value is 2.
smallint
REMOTE_MAC_ADDRESS MAC address of attached port of the 10G GigE Port. varchar 64
INBAND_MANAGEMENT_ST
ATUS
1 = Inband Management status is enabled;
otherwise, 0.
Default value is 0.
smallint
OCCUPIED Default value is 0. smallint
LAST_UPDATE bigint
TABLE 147 GIGE_PORT_ETHERNET_CLOUD_LINK
Field Definition Format Size
ID Unique generated database identifier. int
CLOUD_ID int
SWITCH_PORT_ID The unique id of the switch TE port that this member
connects to.
int
TRUSTED smallint
CREATION_TIME timestamp
MISSING smallint
MISSING_TIME timestamp
TABLE 148 GIGE_PORT_STATS
Field Definition Format Size
ID* Unique generated database identifier. int
SWITCH_ID References the ID in CORE_SWITCH table. int
PORT_ID References the ID in SWITCH_PORT table. int
CREATION_TIME The polling time. timestamp
TABLE 146 GIGE_PORT (Continued)
Field Definition Format Size