HP Brocade 8/12c Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 106

E Database tables and fields TABLE 170 SWITCH_PORT (Continued) Field Definition Format Size LOGICAL_PORT_NUMBER F-Port trunk logical port number. Default value is -1. smallint DEFAULT_AREA_ID Default Area id of F-Port trunk port. Default value is -1. smallint LOGICAL_PORT_WWN Logical port WWN of F-Port trunk group. char 23 PREVIOUS_TYPE This fields copies the old state of the port type. The varchar 16 field could be used to track the state change information for the switch port type. SwitchAssetCollector sets this field during the collection time. SMIA requested this information but could be used by any module which needs to track the type state change. LATENCY_DETECT_SUPPOR Whether the port supports latency detection. 1 TED means true and 0 means false smallint PREVIOUS_STATE Fields copies the old state of the port . The field could varchar 64 be used to track the state change information for the switch port . SwitchAssetCollector sets this field during the collection time. SMIA requested this information but could be used by any module which needs to track the state change. EPORT_DISABLED Represents the eportDisabled field from switch.html. Values populated by SwitchAssetcollector during the collection time. Possible values includes 0 and 1. Default value is -1. smallint SPEED_NEGOTIATED This column indicates if the port speed is negotiated or not. If port speed is negotiated then value is 1 else it will be 0. Default value is -1. smallint TABLE 172 N2F_PORT_MAP Field Definition Format Size ID* VIRTUAL_SWITCH_ID N_PORT F_PORT Virtual switch ID of AG for N to F_port mapping, foreign key to VIRTUAL_SWITCH table. Port number of port type N_Port which is being mapped, One N_Port can be mapped to multiple F_ports. Port number of port type F_Port which is being mapped. int int smallint smallint TABLE 174 FPORT_TRUNK_GROUP Field Definition Format Size ID* VIRTUAL_SWITCH_ID int Virtual switch ID where this F_Port Trunk Group is int defined. 98 Brocade Network Advisor Documentation Updates 53-1002363-02