Brocade Network Advisor SAN User Manual v12.3.0 - Manual (Page 1737)

Brocade Network Advisor SAN User Manual 1685
53-1003154-01
Database tables and fields
H
TABLE 374 SNMP_DATA_30MIN
Field Definition Format Size
ID Primary key autogenerated ID int
MIB_OBJECT_ID MIB OID used for collection int
TARGET_TYPE Target or source type can be,
•
device - 0 or
•
interface or ports - 1
num (2,0)
TARGET_ID DB Id of the target which can be device or interface int
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 375 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 376 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