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

1296 Brocade Network Advisor SAN User Manual
53-1002696-01
Database tables and fields
H
VALUE Value collected by the engine double
precision
TIME_IN_SECONDS Time at which collection occured in seconds int
COLLECTOR_ID DB Id of the collector object used for collection int
MIB_INDEX MIB index used for collection if applicable char 256
TABLE 318 SNMP_EXPR_DATA
Field Definition Format Size
ID Primary key column. serial
EXPRESSION_ID MIB object ID. int
TARGET_TYPE Target type of the SNMP collector data. Th target type
for,
• device level collector is 0,
• for port level collector is 1.
smallint
TARGET_ID Target ID of the SNMP collector data. for device level
collector it will use deviceId, for port level it will use
interfaceId.
int
VALUE Value of the OID retrieved from the corresponding
target.
double
TIME_IN_SECONDS Time when value of the OID was retrieved from the
corresponding target.
int
COLLECTOR_ID Correspoding collector table ID. int
TABLE 319 SNMP_EXPR_DATA_1DAY
Field Definition Format Size
ID Primary key autogenerated ID. int
EXPRESSION_ID DB ID of the expression object used for collection. int
TARGET_TYPE Target or source type can be,
• device - 0 or
• interface or ports - 1
smallint
TARGET_ID DB Id of the target which can be device or interface. int
VALUE Aggregated value inserted during the aging process. double
precision
TIME_IN_SECONDS Time, in seconds, at which the record was inserted in
seconds.
int
COLLECTOR_ID DB ID of the collector object used for collection. int
TABLE 320 SNMP_EXPR_DATA_2HOUR
Field Definition Format Size
ID Unique generated database identifier. int
EXPRESSION_ID int
TABLE 317 SNMP_DATA_30MIN (Continued)
Field Definition Format Size