1556 Brocade Network Advisor IP User Manual
53-1003056-01
Database tables and fields
I
TABLE 412 TIME_SERIES_DATA_4
Field Definition Format Size
TIME_IN_SECONDS Time when value of the measure retrieved from the
corresponding target.
int
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
collector it will use deviceId/virtualSwitchId, for port
level it will use interfaceId/switchPortId/
fcipTunnelId/devicePortId.
int
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 wi th
column names in aggregated data tables.Stores the
delta changes for counter values between two
samples, only used for counter values, 0 for all other
types of measures.
double
precision
TABLE 413 TIME_SERIES_DATA_4_1DAY
Field Definition Format Size
TIME_IN_SECONDS Time when value of the measure retrieved from the
corresponding target.
int
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
collector it will use deviceId/virtualSwitchId, for port
level it will use interfaceId/switchPortId/
fcipTunnelId/devicePortId.
int
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
day data.
double
precision
MAX_VALUE Maximum value in 2 hour table while aggregating 1
day data.
double
precision
SUM_VALUE Named after SUM_VALUE to be consistent wi th
column names in aggregated data tables.Stores the
delta changes for counter values between two
samples, only used for counter values, 0 for all other
types of measures.
double
precision