Brocade Communications Systems IP250 user manual TIMESERIESDATA11DAY, Sumvalue

		Database tables and fields		I
TABLE 400	TIME_SERIES_DATA_1
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
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 401	TIME_SERIES_DATA_1_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. 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 One day aggregated data.	double
			precision

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