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

Brocade Network Advisor SAN User Manual 1295
53-1002696-01
Database tables and fields
H
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 315 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 316 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 317 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
TABLE 314 SNMP_DATA (Continued)
Field Definition Format Size