Brocade Network Advisor Documentation Updates v11.1.x (53-1002363-03, August 2011)

Brocade Network Advisor Documentation Updates 159
53-1002363-02
Database tables and fields
E
TABLE 313 SENSOR
Field Definition Format Size
ID 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 filled in by Switch Asset 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
CREATION_TIME provides the record creation time, standard columns
for Management applciation and values filled in by
Switch Asset Collector
timestamp
LAST_UPDATE_TIME provides the record last updated time, standard
columns for Management applciation and values
filled in by Switch Asset Collector
timestamp
FRU_TYPE provides the type 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
values represents FAN,PS, SLOT etc. The default
value is -1.
int