Brocade Network Advisor 12.1.X Documentation Updates (53-1003016-05, January 2014)

Brocade Network Advisor SAN User Manual 1449
53-1002948-01
Database tables and fields
H
TARGET_TYPE Target type of the SNMP collector data. The target
type for,
• device level collector is 0
• port level collector it is 1.
num (2,0)
TARGET_ID Target id of the SNMP collector data. for device level
collector it will use deviceId, and for port level it will
use interfaceId.
int
VALUE Value of the OID retrieved from the corresponding
target.
double
TIME_IN_SECONDS Time, in seconds, at which the record was inserted. int
COLLECTOR_ID Correspoding collector table ID. int
MIB_INDEX Index value for a MIB varaible. For scalar value it will
be empty.
varchar 256
TABLE 342 SNMP_DATA_1DAY
Field Definition Format Size
ID Primary key autogenerated ID. int
MIB_OBJECT_ID The DB ID of MIB_OBJECT. int
TARGET_TYP 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 Aggregated value inserted during the aging process. double
precision
TIME_IN_SECONDS Time, in seconds, at which the record was inserted. 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 343 SNMP_DATA_2HOUR
Field Definition Format Size
ID The DB ID of MIB_OBJECT. int
MIB_OBJECT_ID The DB ID of MIB_OBJECT. 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 Aggregated value inserted during the aging process. double
precision
TIME_IN_SECONDS Time, in seconds, at which the record was inserted. 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 341 SNMP_DATA (Continued)
Field Definition Format Size