Brocade Network Advisor SAN User Manual v11.1x (53-1002167-01, May 2011)

1072 Brocade Network Advisor SAN User Manual
53-1002167-01
Database tables and fields
E
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
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.
varchar 16
LATENCY_DETECT_SUPPOR
TED
Whether the port supports latency detection. 1
means true and 0 means false
smallint
PREVIOUS_STATE Fields copies the old state of the port . The field could
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.
varchar 64
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 240 N2F_PORT_MAP
Field Definition Format Size
ID* int
VIRTUAL_SWITCH_ID Virtual switch ID of AG for N to F_port mapping,
foreign key to VIRTUAL_SWITCH table.
int
N_PORT Port number of port type N_Port which is being
mapped, One N_Port can be mapped to multiple
F_ports.
smallint
F_PORT Port number of port type F_Port which is being
mapped.
smallint
TABLE 242 FPORT_TRUNK_GROUP
Field Definition Format Size
ID* int
VIRTUAL_SWITCH_ID Virtual switch ID where this F_Port Trunk Group is
defined.
int
TABLE 238 SWITCH_PORT (Continued)
Field Definition Format Size