Brocade Network Advisor SAN User Manual v12.3.0 - Manual (Page 1755)

Brocade Network Advisor SAN User Manual 1703
53-1003154-01
Database tables and fields
H
\ TABLE 407 TIME_SERIES_DATA_30MIN
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 408 TIME_SERIES_DATA_1
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. For
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). 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
SUM_VALUE Named after SUM_VALUE to be consistent with
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