Brocade Network Advisor IP User Manual v12.1.0 - Manual (Page 1591)

Brocade Network Advisor IP User Manual 1537
53-1002947-01
Database tables and fields
I
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 376 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 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
TABLE 375 SELECTED_FLYOVER_PROPERTY (Continued)
Field Definition Format Size