Brocade Network Advisor SAN User Manual v12.3.0 User Manual

Page 1600

Advertising
background image

1548

Brocade Network Advisor SAN User Manual

53-1003154-01

Database tables and fields

H

installation_type

Indicates the widgets is SAN Only (0) / IP Only
(1) / SAN_IP (2)'

int

shared_provider

Can the provider be shared? 0 - Not Shared 1
- Shared.

int

TABLE 85

DASHBOARD_WIDGET_PREFERENCE

Field

Definition

Format

Size

ID

Auto incremented widget preference ID.

int

WIDGET_ID

Foreign Key to DASHBOARD_WIDGET(ID).

int

USER_ID

Foreign Key to USER_ (ID).

int

DASHBOARD_ID

Foreign Key to DASHBOARD(ID).

int

VISIBLE

Indicates whether the widget is visible for the user in
the dashboard. 0 - Not Visible, 1 - Visible.

smallint

STATE

State of the widget. Possible values are 0 - Normal, 1
- Maximized, 2 - Collapsed.

int

WIDTH

Width of the widget.

int

HEIGHT

Height of the widget.

int

ROW_INDEX

Row position of the widget. -1 for an out-of-box widget
defined but not shown.

int

COLUMN_INDEX

Column position of the widget. -1 for an out-of-box
widget defined but not shown.

int

CANVAS_ID

Foreign Key to DASHBOARD_CANVAS.ID

int

TABLE 86

DEFAULT_FAVORITES

Field

Definition

Format

Size

ID

Name of the favorite.

int

NAME

The topnumber of ports (5,10,15,20).

varchar

64

TOP_N

Types of ports (FC/FCIP/GE) and -End Monitors.

varchar

40

SELECTION_FILTER

The time interval in which the graph is shown.

varchar

40

FROM_TIME

Always null. The default favorite is not customized.

varchar

40

CUSTOM_LAST_VALUE

Always null. The default favorite is not customized.

int

CUSTOM_TIME_UNIT

Always null. The default favorite is not customized.

varchar

40

CUSTOM_FROM

Always null. The default favorite is not customized.

timestamp

CUSTOM_TO

The default five minutes granularity.

timestamp

GRANULARITY

Always null.

varchar

40

THRESHOLD

The measure Tx MBps or Rx MBps based on
DEFAULT_FAVORITES.NAME

int

TABLE 84

DASHBOARD_WIDGET (Continued)

Field

Definition

Format

Size

Advertising