Brocade Network Advisor 12.1.X Documentation Updates (53-1003016-05, January 2014)

Table Of Contents
Brocade Network Advisor SAN User Manual 1413
53-1002948-01
Database tables and fields
H
MISSING Denotes whether ISL trunk group is missing or not. 0
denotes present and 1 states that ISL trunk is
missing
smallint
MISSING_TIME States the missing time of the this ISL trunk group. If
the trunk is not missing then it will be null
timestamp
MEMBER_TRACKING_STAT
US
Member added/removed status of this trunk. This is
represented as bitmap value. Each bit is set based
on membership state change. Currently only 2 bits
from LSB are used.
Bit 1 - Member added
Bit 2 - Member removed
For example if the trunk group has membership
change (some members are added and some
existing members are removed) then the value would
be 3.
int
TABLE 236 ISL_TRUNK_MEMBER
Field Definition Format Size
GROUP_ID* Foreign key reference to the trunk group table for this
member.
int
PORT_NUMBER* Member port number for this trunk.. smallint
TRUSTED Denotes whether ISL trunk member is trusted or not.
0 denotes untrusted and 1 is for trusted.
smallint
MISSING Denotes whether ISL trunk member is missing or not.
0 denotes present and 1 states that ISL trunk
member is missing.
smallint
MISSING_TIME We could change this as "States the missing time of
the this ISL trunk member. If the member is not
missing then it will be null.
timestamp
TABLE 237 KEY_VAULT
Field Definition Format Size
ID Unique generated database identifier. int
IP_ADDRESS The IP Address (IPv4, IPv6, or hostname) of the key
vault
varchar( 512
PORT_NUMBER The TCP port number for the key vault int
PUBLIC_CERTIFICATE
The key vault''s public key certificate. Switches use
this to establish a secure connection to the key vault
varchar( 4096
CERTIFICATE_LABEL A text name to identify the certificate varchar( 256
POSITION_
Specifies whether this key vault is the primary key vault
or the backup key vault. 0 = primary, 1 = backup.
smallint
VENDOR_NAME
Indicates the name of the key vault vendor. For non
KMIP key vaults, this column will contain value as Not
Applicable.
varchar 256
TABLE 235 ISL_TRUNK_GROUP (Continued)
Field Definition Format Size