Brocade Network Advisor SAN User Manual v12.3.0 - Manual (Page 1617)

Brocade Network Advisor SAN User Manual 1565
53-1003154-01
Database tables and fields
H
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