User Manual v12.3.0 Owner's manual

Brocade Network Advisor IP User Manual 1559
53-1003153-01
Database tables and fields
I
VIRTUAL_FCOE_PORT_ID The value of virtual_fcoe_port_id in the
Device_Port_Gige_Port_Link table is applicable only
for NOS devices. For FOS devices, the
virtual_fcoe_port_id value, will be null, as currently in
the Management application that mapping data is not
collected. Hence the default value is null.
int
LAG_ID LAG interface ID which associates port channel with
end device. This will be null if device port is associated
with physical gige port.
int
TABLE 106 DEVICE_PORT_MAC_ADDRESS_MAP
Field Definition Format Size
DEVICE_PORT_ID The primary key of the device port int
MAC_ADDRESS Mac address of the device varchar 64
TABLE 107 DISK_USAGE
Field Definition Format Size
ID Primary key of the table. Autogenerated. int
TIME_THRESHOLD_CROSSED Holds the timestamp at which the disk space
was analyzed and found to have crossed the
threshold (both low to high and vice versa).
timestamp
MEMORY_UTILIZATION Holds the disk usage as a percentage. Value
varies from 0 to 100.
double
precision
THRESHOLD_TYPE Denotes whether disk space usage crosses
above or below threshold limit. 1 if it is goes
above threshold, 0 if it goes below threshold (in
previous instance it was above threshold).
smallint
FREE_SPACE Holds the free disk space at the particular time
in bytes.
bigint
TOTAL_SPACE Holds the total disk space at the particular time
in bytes.
bigint
TABLE 108 ENCRYPTION_ENGINE
Field Definition Format Size
ID Unique generated database identifier. int
SWITCH_ID Foreign key reference to both the VIRTUAL_SWITCH
table and the CRYPTO_SWITCH table (both switch
tables use the same primary key values). Identifies the
switch that contains this encryption engine.
int
SLOT_NUMBER For chassis switches, the slot or blade that contains
the encryption engine. Always 0 for pizza-box switches
with a single embedded encryption engine.
smallint
TABLE 105 DEVICE_PORT_GIGE_PORT_LINK (Continued)
Field Definition Format Size