Brocade Network Advisor SAN User Manual v12.3.0 User Manual
Page 1756
1704
Brocade Network Advisor SAN User Manual
53-1003154-01
Database tables and fields
H
TABLE 409
TIME_SERIES_DATA_1_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. 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
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
TABLE 410
TIME_SERIES_DATA_1_2HOUR
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