Brocade Communications Systems IP250 user manual Database tables and fields TIMESERIESDATA3

I Database tables and fields

TABLE 408 TIME_SERIES_DATA_3 (Continued)

Field	Definition	Format	Size
COLLECTOR_ID	DB ID of the pm_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	Stores the raw data received from the device.	double
		precision
SUM_VALUE	Named after SUM_VALUE to be consistent with	double
	column names in aggregated data tables.Stores the	precision
	delta changes for counter values between two
	samples, only used for counter values, 0 for all other
	types of measures.

TABLE 409 TIME_SERIES_DATA_3_1DAY

Field	Definition	Format	Size
TIME_IN_SECONDS	Time when value of the measure retrieved from the	int
	corresponding target.
TARGET_TYPE	Target type of the PM collector data.	smallint
MEASURE_ID	ID of the measure (MIB/Expression).	int
TARGET_ID	Target ID of the PM collector data. For device level	int
	collector it will use deviceId/virtualSwitchId, for port
	level it will use interfaceId/switchPortId/
	fcipTunnelId/devicePortId.
COLLECTOR_ID	DB ID of the pm_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	Stores One day aggregated data.	double
		precision
MIN_VALUE	Minimum value in 2 hour table while aggregating 1	double
	day data.	precision
MAX_VALUE	Maximum value in 2 hour table while aggregating 1	double
	day data.	precision
SUM_VALUE	Named after SUM_VALUE to be consistent with	double
	column names in aggregated data tables.Stores the	precision
	delta changes for counter values between two
	samples, only used for counter values, 0 for all other
	types of measures.

TABLE 410 TIME_SERIES_DATA_3_2HOUR

Field	Definition	Format	Size
TIME_IN_SECONDS	Time when value of the measure retrieved from the	int
	corresponding target.
TARGET_TYPE	Target type of the PM collector data.	smallint
MEASURE_ID	ID of the measure (MIB/Expression).	int

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