Brocade Communications Systems IP250 user manual SNMPDATA30MIN, Snmpexprdata, SNMPEXPRDATA1DAY

		Database tables and fields		I
TABLE 366 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,		num	(2,0)
	•	device - 0 or
	•	interface or ports - 1
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 367 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		smallint
	for,
	• device level collector is 0,
	•	for port level collector is 1.
TARGET_ID	Target ID of the SNMP collector data. for device level		int
	collector it will use deviceId, for port level it will use
	interfaceId.
VALUE	Value of the OID retrieved from the corresponding		double
	target.
TIME_IN_SECONDS	Time when value of the OID was retrieved from the		int
	corresponding target.
COLLECTOR_ID	Correspoding collector table ID.		int

TABLE 368 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,		smallint
	•	device - 0 or
	•	interface or ports - 1
TARGET_ID	DB Id of the target which can be device or interface.		int
VALUE	Aggregated value inserted during the aging process.		double
			precision

Brocade Network Advisor IP User Manual	1531
53-1003056-01