Brocade Communications Systems IP250 user manual Database tables and fields TIMESERIESDATA22HOUR

		Database tables and fields		I
TABLE 406	TIME_SERIES_DATA_2_2HOUR (Continued)
Field		Definition	Format	Size
VALUE		Stores the 2 hours aggregated data.	double
			precision
MIN_VALUE		Minimum value in 30 min table while aggregating 2	double
		hours of data.	precision
MAX_VALUE		Maximum value in 30 min table while aggregating 2	double
		hours of data.	precision
TABLE 407	TIME_SERIES_DATA_2_30MIN
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. For	smallint
		IP_DEVICE(0), IP_PORT(1), IP_TRUNK(2),
		FOS_DEVICE(3), FC_PORT(4), GE_PORT(5),
		TE_PORT(6), HBA_PORT(7), CNA_PORT(8),
		VIRTUAL_FCOE_PORT(9), FCIP_TUNNEL(10),
		EE_MONITOR(11), IP_DEVICE_GROUP(12),
		IP_PORT_GROUP(13), VIRTUAL_GROUP(14),
		TRILL_TRUNK(15), ALL_SAN_PRODUCTS(16).
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 the 30 minutes aggregated data.	double
			precision
MIN_VALUE		Minimum value in raw performance statistics table	double
		while aggregating 30 minutes of data.	precision
MAX_VALUE		Maximum value in raw performance statistics table	double
		while aggregating 30 minutes of data.	precision
TABLE 408	TIME_SERIES_DATA_3
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.

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