User's Manual

1498 Brocade Network Advisor IP User Manual
53-1003056-01
Database tables and fields
I
ME_ID ME_ID of the target. int
INDEX_MAP Stores the index_map value in case of an expression. varchar 8192
TABLE 277 PM_COLLECTOR_TIME_SERIES_MAPPING
Field Definition Format Size
COLLECTOR_ID DB ID of the pm_data_collector. int
TARGET_NAME Time series data master table name. It could be
either TIME_SERIES_DATA_1 or
TIME_SERIES_DATA_2.
varchar 63
TABLE 278 PM_DASHBOARD_WIDGET
Field Definition Format Size
DASHBOARD_WIDGET_ID Primary key column. int
TIME_SCOPE Time in unit of seconds, for which the data has to be
fetched from DB going back from now applicable for
top N, distribution, and top Flow, time series.
int
REFRESHING_INTERVAL The widget refreshing interval in seconds, in 11.3 we
will fix it at 600 (10 mins) and not expose it to user.
int
MONITOR_TYPE The widget refreshing interval in seconds, in 11.3 we
will fix it at 600 (10 mins) and not expose it to user.
int
MEASURE_TYPE TYPE of the user selection measure. int
CREATE_USER_ID ID of the user who created the widget definition. int
CREATE_TIME Widget definition created server time. timestamp
MODIFY_USER_ID ID of the user who last modifed the widget definition. int
MODIFY_TIME Widget definition last modified server time. timestamp
TOP_OR_BOTTOM_N The Top N setting for the Top N, Bottom N and Top
XXX monitor TYPE, for other monitor TYPE, this field
set to default value. Default is 0.
int
LEVEL1_ENABLED Enable / disable the threshold check for first
percentage band. This value is applicable only for Top
N, Top Flow widgets. Default is 0.
smallint
LEVEL1_VALUE Limit value for the first percentage band. Default is 0. double
precision
LEVEL1_COLOR RGB color for the first percentage band. int
LEVEL2_ENABLED Enable / disable the second threshold check. This
value is applicable only for Top N, Top Flow widgets.
Default is 0.
smallint
LEVEL2_VALUE Limit value for the second percentage band. Default
is 0.
double
precision
LEVEL2_COLOR RGB color for the second percentage band. int
TABLE 276 PM_COLLECTOR_TARGET_SETTING (Continued)
Field Definition Format Size