Brocade Network Advisor IP User Manual v12.3.0 - Manual (Page 1642)

1590 Brocade Network Advisor IP User Manual
53-1003153-01
Database tables and fields
I
EFCM_USER Management application user who has generated
this report. varchar 128
REPORT_OBJECT Report object BLOB. bytea
TIMESTAMP_ Timestamp when the report is generated. timestamp
FABRIC_NAME Fabric Name. varchar 256
TABLE 162 GIGE_PORT
Field Definition Format Size
ID* Unique generated database identifier. int
SWITCH_PORT_ID ID for the GigE Port in SWITCH_PORT. int
PORT_NUMBER GigE Port Number(0 for ge0 and 1 for ge1). int
SLOT_NUMBER Slot number on which the GigE Port is present. int
ENABLED Enabled or disabled.
Default value is 0. smallint
SPEED Port speed details.
Default value is 0. bigint
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 161 GENERATED_REPORT (Continued)
Field Definition Format Size