Brocade Network Advisor IP User Manual 1519
53-1003056-01
Database tables and fields I
TABLE 34 2 SELECTED_FLYOVER_PROPERTY
Field Definition Format Size
PROPERTY_ID* Refers to Flyover_Property ID from
AVAILABLE_ FLYOVER_P ROPERT Y 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 34 3 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
SERIAL_NUMBER provides the serial number of the sensor, requested
by SMIA and values fill ed in by Switch As set Collector
will be available only from FOS 6.4 switches and
above
varchar 64
VERSION provides the version 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 32