User Manual v12.3.0 Owner's manual

1696 Brocade Network Advisor IP User Manual
53-1003153-01
Database tables and fields
I
MEASURE_ID ID of the measure. int
TARGET_ID Target ID of the PM collector data. For device level
collector it will use deviceId, for port level it will use
interfaceId.
int
COLLECTOR_ID ID of the data_collector. int
MEASURE_INDEX 'Stores the index_map value in case of anexpression. varchar 256
ME_ID ME_ID of the target. int
VALUE 30 mins aggregated data. double
precision
TABLE 405 TIME_SERIES_DATA_1DAY
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
collector the target type is 0, for port level it is 1.
smallint
MEASURE_ID ID of the measure. int
TARGET_ID Target ID of the PM collector data. For device level
collector it will use deviceId, for port level it will use
interfaceId.
int
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 406 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
collector the target type is 0, for port level it is 1.
smallint
MEASURE_ID ID of the measure. int
TARGET_ID Target ID of the PM collector data. For device level
collector it will use deviceId, for port level it will use
interfaceId.
int
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 404 TIME_SERIES_DATA (Continued)
Field Definition Format Size