Brocade Network Advisor SAN User Manual v12.0.0 (53-1002696-01, April 2013)

1284 Brocade Network Advisor SAN User Manual
53-1002696-01
Database tables and fields
H
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
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 293 SFLOW_CHECKPOINT
Field Definition Format Size
TABLE_TO_DROP Staging child tables previously checkpointed
(indicating that their aggregation was completed).
varchar 40
TABLE 294 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
TABLE 292 SENSOR (Continued)
Field Definition Format Size