Brocade Network Advisor SAN + IP User Manual v12.1.0 - Manual (Page 2203)

2166 Brocade Network Advisor SAN + IP User Manual
53-1002949-01
Database tables and fields
I
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
UNIT_NUMBER provides the unit 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 . 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. int
STATE provides the state 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.
This gives the value whether the FRU is On or Off .
The default value is -1. int
TABLE 377 SFLOW_CHECKPOINT
Field Definition Format Size
TABLE_TO_DROP Staging child tables previously checkpointed
(indicating that their aggregation was completed). varchar 40
TABLE 378 SFLOW_HOUR_SUMMARY
Field Definition Format Size
SLNUM This column is used to store a counter value to
identify the total row count. bigserial
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
value is 0. smallint
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
value is 0. smallint
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
IN_PRIORITY Priority ID of the incoming traffic interface. smallint
OUT_PRIORITY Priority ID of the outgoing traffic interface. smallint
TABLE 376 SENSOR (Continued)
Field Definition Format Size