Brocade Network Advisor IP User Manual v12.1.0 User Manual
Page 1573
Brocade Network Advisor IP User Manual
1519
53-1002947-01
Database tables and fields
I
TABLE 321
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