Brocade Network Advisor Documentation Updates v11.1.x (53-1002363-03, August 2011)

Brocade Network Advisor Documentation Updates 157
53-1002363-02
Database tables and fields
E
VALUE double
precision
TIME_IN_SECONDS int
COLLECTOR_ID int
MIB_INDEX char 256
TABLE 307 SNMP_DATA_2HOUR
Field Definition Format Size
ID int
MIB_OBJECT_ID int
TARGET_TYPE numeric (2,0)
TARGET_ID int
VALUE double
precision
TIME_IN_SECONDS int
COLLECTOR_ID int
MIB_INDEX char 256
TABLE 308 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/Source type can be device:0 or
interface/ports:1
numeric (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 309 SNMP_EXPR_DATA_1DAY
Field Definition Format Size
ID int
EXPRESSION_ID int
TARGET_TYPE smallint
TARGET_ID int
VALUE double
precision
TABLE 306 SNMP_DATA_1DAY (Continued)
Field Definition Format Size