Brocade Network Advisor SAN + IP User Manual v12.1.0 - Manual (Page 2214)

Brocade Network Advisor SAN + IP User Manual 2177
53-1002949-01
Database tables and fields
I
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 399 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 400 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 401 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 398 SNMP_DATA (Continued)
Field Definition Format Size