Brocade Communications Systems IP250 Selectedflyoverproperty, Sensorid, Currentreading

	Database tables and fields		I
TABLE 342 SELECTED_FLYOVER_PROPERTY
Field	Definition	Format	Size
PROPERTY_ID*	Refers to Flyover_Property ID from	int
	AVAILABLE_FLYOVER_PROPERTY table.
USER_NAME*	The name of the user who selected the property to be	varchar	128
	shown on flyover.
POSITION_	The user preferred position of the selected flyover	int
	property.
TABLE 343 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	int
	values filled in by Switch Asset Collector. Maps to
	Device Id in the html page.
	The default value is -1.
CURRENT_READING	Identifies the current temperature reading sensor,	bigint
	requested by SMIA and values filled in by Switch
	Asset Collector, Maps to value field in the html page.
	The default value is -1.
TYPE	The default value is -1.	int
SUB_TYPE	The default value is -1.	int
DESCRIPTION	Provides the description of the temperature sensor,	varchar	128
	requested by SMIA and values filled in by Switch
	Asset Collector
STATUS	provides the status of the sensor, requested by SMIA	int
	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.
OPERATIONAL_STATUS	provides the operational status of the sensor,	int
	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.
PART_NUMBER	provides the part number of the sensor, requested by	varchar	64
	SMIA and values filled in by Switch Asset Collector
	will be available only from FOS 6.4 switches and
	above
SERIAL_NUMBER	provides the serial number of the sensor, requested	varchar	64
	by SMIA and values filled in by Switch Asset Collector
	will be available only from FOS 6.4 switches and
	above
VERSION	provides the version of the sensor, requested by	varchar	32
	SMIA and values filled in by Switch Asset Collector
	will be available only from FOS 6.4 switches and
	above

Brocade Network Advisor IP User Manual	1519
53-1003056-01