Brocade Communications Systems IP250 user manual Sflowcheckpoint, Sflowhoursummary

I Database tables and fields

TABLE 343 SENSOR (Continued)

Field	Definition	Format	Size
CREATION_TIME	provides the record creation time, standard columns	timestamp
	for Management application and values filled in by
	Switch Asset Collector
LAST_UPDATE_TIME	provides the record last updated time, standard	timestamp
	columns for Management application and values
	filled in by Switch Asset Collector
FRU_TYPE	provides the type of the sensor, requested by SMIA	int
	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.
UNIT_NUMBER	provides the unit number of the sensor, requested by	int
	SMIA and values filled in by Switch Asset Collector
	will be available only from FOS 6.4 switches and
	above . This the gives the index of the unit. For SLOT
	FRU, this will be slot number. For FAN fru, this will be
	fan number. The default value is -1.
STATE	provides the state of the sensor, requested by SMIA	int
	and values filled in by Switch Asset Collector will be
	available only from FOS 6.4 switches and above.
	This gives the value whether the FRU is On or Off .
	The default value is -1.

TABLE 344 SFLOW_CHECKPOINT

Field	Definition	Format	Size
TABLE_TO_DROP	Staging child tables previously checkpointed	varchar	40
	(indicating that their aggregation was completed).

TABLE 345 SFLOW_HOUR_SUMMARY

Field	Definition	Format	Size
SLNUM	This column is used to store a counter value to	bigserial
	identify the total row count.
TIME_IN_SECONDS	Data collection time in seconds.	int
DEVICE_ID	ID of the product which sends the sflow traffic.	int
IN_UNIT	Unit number of the incoming traffic interface. Default	smallint
	value is 0.
IN_SLOT	Slot number of the incoming traffic interface.	smallint
IN_PORT	Port number of the incoming traffic interface.	smallint
OUT_UNIT	Unit number of the outgoing traffic interface. Default	smallint
	value is 0.
OUT_SLOT	Slot number of the outgoing traffic interface.	smallint
OUT_PORT	Port number of the outgoing traffic interface.	smallint
IN_VLAN	Vlan ID of the incoming traffic interface.	smallint
OUT_VLAN	Vlan ID of the outgoing traffic interface.	smallint

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