User Manual v12.3.0 Owner's manual

Brocade Network Advisor IP User Manual 1691
53-1003153-01
Database tables and fields
I
USER_DEFINED_VALUE2 User defined value used for annotation. varchar 256
USER_DEFINED_VALUE3 User defined value used for annotation. varchar 256
KIND Stores the port kind from the NVP portKind. varchar 32
STATE The state of the port whether it is online or offline varchar 64
PREVIOUS_STATUS This table can hold the same values as STATUS
column. But this will be holding the previous status of
the PORT. These values to be populated by switch
asset collector.
varchar 64
AUTO_DISABLE_CONFIGUR
ED
To represent auto disable configuration state (set by
user).
Default value is 0.
smallint
AUTO_DISABLED To represent auto disabled status (set by switch).
Default value is 0.
smallint
OCCUPIED Default value is 0. smallint
LAST_UPDATE Last update time stored as long value. Elapsed time
from 1970 in milliseconds.
bigint
PORT_BIT_MASK F-Port trunk bit mask value.
Default value is 0.
int
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 395 SWITCH_PORT (Continued)
Field Definition Format Size