Brocade Network Advisor Documentation Updates v11.1.x (53-1002363-03, August 2011)

Brocade Network Advisor Documentation Updates 85
53-1002363-02
Database tables and fields
E
Stats
TABLE 155 FAVORITES
Field Definition Format Size
ID* int
NAME Name of the favorite. varchar 64
USER_ The application user credentials. varchar 128
TOP_N The top number of ports(5,10,15,20). varchar 40
SELECTION_FILTER Types of ports (FC/FCIP/GE) and -End Monitors. varchar 40
FROM_TIME The time interval in which the graph is shown. Time
interval can be predefined or custom. If FROM_TIME
is Custom, the user can choose the number of
minutes/hours/days or specify the time interval.
varchar 40
CUSTOM_LAST_VALUE The number of minutes/hours/days. It becomes null
in two cases.
1. When the value of FROM_TIME is not Custom.
2. When FROM_TIME is Custom, and user chooses
the time interval (CUSTOM_FROM and CUSTOM_TO)
int
CUSTOM_TIME_UNIT The unit type (Minutes, Hours, Days) of the
CUSTOM_LAST_VALUE.
varchar 40
CUSTOM_FROM The starting time. timestamp
CUSTOM_TO The ending time. timestamp
GRANULARITY The granularity. varchar 40
THRESHOLD The reference line. int
MAIN_MEASURE The measure of FC/FCIP/GE. varchar 40
ADDITIONAL_MEASURE The additional measures. int
TABLE 156 USER_
Field Definition Format Size
ID * int
NAME User name. varchar 128
DESCRIPTION User description. varchar 512
PASSWORD User password. varchar 512
EMAIL User e-mail ID. varchar 1024
NOTIFICATION_ENABLED Flag for e-mail notification.
Default value is 0.
smallint
FULL_NAME User''s Full Name. varchar 512
PHONE_NUMBER User''s Phone number. varchar 32
INVALID_LOGIN_COUNT This is a counter filed to identify the number of invalid
login attempts.
Note: After successful login this filed will be set to
NULL.
Default value is 0.
smallint