Brocade Network Advisor 12.1.X Documentation Updates (53-1003016-05, January 2014)

1430 Brocade Network Advisor SAN User Manual
53-1002948-01
Database tables and fields
H
TABLE 287 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
LEVEL3_ENABLED Enable / disable the third threshold check. This value
is applicable only for Top N, Top Flow widgets. Default
is 0.
smallint
LEVEL3_VALUE Limit value for the third percentage band. Default is
0.
double
precision
LEVEL3_COLOR Limit value for the third percentage band. int
LEVEL4_ENABLED Enable / disable the fourth threshold check. This
value is applicable only for Top N, Top Flow widgets.
Default is 0.
smallint
LEVEL4_VALUE Limit value for the fourth percentage band. In case of
Top N, Top Flow widgets only three percentage bands
are available. This value is not applicable. Default is
0.
double
precision
LEVEL4_COLOR RGB color for the fourth percentage band.In case of
Top N, Top Flow widgets we will use this column to
store the color value for other percentage band.
int