Brocade Network Advisor SAN + IP User Manual v12.1.0 User Manual

Page 2184

Advertising
background image

Brocade Network Advisor SAN + IP User Manual

2147

53-1002949-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

Advertising