Brocade Communications Systems IP250 user manual Database tables and fields TIMESERIESDATA1DAY

I Database tables and fields

TABLE 397 TIME_SERIES_DATA_1DAY (Continued)

Field	Definition	Format	Size
COLLECTOR_ID	ID of the data_collector.	int
MEASURE_INDEX	Stores the index_map value in case of an expression.	varchar	256
ME_ID	ME_ID of the target.	int
VALUE	30 mins aggregated data.	double
		precision

TABLE 398 TIME_SERIES_DATA_2HOUR

Field	Definition	Format	Size
TIME_IN_SECONDS	Time when the record is inserted.	int
TARGET_TYPE	Target type of the PM collector data. For device level	smallint
	collector the target type is 0, for port level it is 1.
MEASURE_ID	ID of the measure.	int
TARGET_ID	Target ID of the PM collector data. For device level	int
	collector it will use deviceId, for port level it will use
	interfaceId.
COLLECTOR_ID	ID of the data_collector.	int
MEASURE_INDEX	Stores the index_map value in case of an expression.	varchar	256
ME_ID	ME_ID of the target.	int
VALUE	30 mins aggregated data.	double
		precision

TABLE\399 TIME_SERIES_DATA_30MIN

Field	Definition	Format	Size
TIME_IN_SECONDS	Time when the record is inserted.	int
TARGET_TYPE	Target type of the PM collector data. For device level	smallint
	collector the target type is 0, for port level it is 1.
MEASURE_ID	ID of the measure.	int
TARGET_ID	Target ID of the PM collector data. For device level	int
	collector it will use deviceId, for port level it will use
	interfaceId.
COLLECTOR_ID	ID of the data_collector.	int
MEASURE_INDEX	Stores the index_map value in case of an expression.	varchar	256
ME_ID	ME_ID of the target.	int
VALUE	30 mins aggregated data.	double
		precision

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