Brocade Communications Systems IP250 TABLE 82 , TABLE 83 , TABLE 81

Brocade Network Advisor IP User Manual 1399
53-1003056-01
Database tables and fields I
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 82 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 83 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. varch ar 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 b ased on
DEFAULT_FAVORITES.NAME
int
TABLE 81 DASHBOARD_WIDGET (Continued)
Field Definition Format Size