Brocade Network Advisor SAN + IP User Manual v12.1.0 - Manual (Page 2098)

Brocade Network Advisor SAN + IP User Manual 2061
53-1002949-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 156 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 157 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 155 DASHBOARD_WIDGET (Continued)
Field Definition Format Size