Brocade Network Advisor SAN User Manual v12.0.0 (53-1002696-01, April 2013)

Brocade Network Advisor SAN User Manual 1283
53-1002696-01
Database tables and fields
H
SECURITY_ASSOC_LIFE Association lifetime in seconds. double
precision
SECURITY_ASSOC_LIFE_
IN_MB
Security association lifetime in megabytes. double
precision
TABLE 291 SELECTED_FLYOVER_PROPERTY
Field Definition Format Size
PROPERTY_ID* Refers to Flyover_Property ID from
AVAILABLE_FLYOVER_PROPERTY table.
int
USER_NAME* The name of the user who selected the property to be
shown on flyover.
varchar 128
POSITION_ The user preferred position of the selected flyover
property.
int
TABLE 292 SENSOR
Field Definition Format Size
ID Unique generated database identifier. int
CORE_SWITCH_ID int
SENSOR_ID Identifies the sensor device , requested by SMIA and
values filled in by Switch Asset Collector. Maps to
Device Id in the html page.
The default value is -1.
int
CURRENT_READING Identifies the current temperature reading sensor,
requested by SMIA and values filled in by Switch
Asset Collector, Maps to value field in the html page.
The default value is -1.
bigint
TYPE The default value is -1. int
SUB_TYPE The default value is -1. int
DESCRIPTION Provides the description of the temperature sensor,
requested by SMIA and values filled in by Switch
Asset Collector
varchar 128
STATUS provides the status of the sensor, requested by SMIA
and values filled in by Switch Asset Collector,Values
could be 0 or 1. 0 means faulty and 1 is ok.The
default value is -1.
int
OPERATIONAL_STATUS provides the operational status of the sensor,
requested by SMIA and values filled in by Switch
Asset Collector will be available only from FOS 6.4
switches and above. The default value is -1.
int
PART_NUMBER provides the part number of the sensor, requested by
SMIA and values filled in by Switch Asset Collector
will be available only from FOS 6.4 switches and
above
varchar 64
TABLE 290 SECURITY_POLICY (Continued)
Field Definition Format Size