Brocade Network Advisor SAN User Manual v12.0.0 (53-1002696-01, April 2013)

1318 Brocade Network Advisor SAN User Manual
53-1002696-01
Database tables and fields
H
TABLE 356 TIME_SERIES_DATA_2_30MIN
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 the 30 minutes aggregated data. double
precision
MIN_VALUE Minimum value in raw performance statistics table
while aggregating 30 minutes of data.
double
precision
MAX_VALUE Maximum value in raw performance statistics table
while aggregating 30 minutes of data.
double
precision
TABLE 357 TOOL_APP
Field Definition Format Size
TOOL_MENU_TEXT* Text to be displayed for the Tool Menu. varchar 256
TOOL_ID A Tool in the TOOL_PATH table where the tools are
defined.
int
PARAMETERS Default path for launching the tool. varchar 256
KEY_STROKE Short cut key stroke to the application. varchar 30
TABLE 358 TOOL_PATH
Field Definition Format Size
ID* Unique generated database identifier. int
TOOL_NAME Name of the tool. varchar 256
PATH Path of the tool where installed or available. varchar 1057
WORKING_FOLDER Working folder for that application. varchar 512