User Manual v12.3.0 Owner's manual

1710 Brocade Network Advisor IP User Manual
53-1003153-01
Database tables and fields
I
TABLE 434 USER_
Field Definition Format Size
ID * Unique generated database identifier. 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
LOCKED_OUT_DATETIME The date time stamp when a user got locked out
because of exceeding max number of invalid login
attempts.
timestamp
STATUS User’s account status:
• 0=Disabled
• 1=Enabled
Default value is 1.
smallint
SOURCE_OF_CREATION To identify the source for creating the user account.
• 0= User created through Management
application Client
• 1= User created when authenticated through
external server.
NOTE: At present there is no direct use of this field
however this can be referred in future to build
certain reports.
Default value is 0.
smallint
IP_PRODUCT_LOGIN_NAME User CLI credential login user name. varchar 256
IP_PRODUCT_LOGIN_PASS
WORD
User CLI credential login password. varchar 768
IP_PRODUCT_ENABLE_USE
R_NAME
User CLI credential enable user name. varchar 256
IP_PRODUCT_ENABLE_PAS
SWORD
User CLI credential enable password. varchar 768
TABLE 435 USER_AOR_MAP
Field Definition Format Size
USER_NAME varchar 128
AOR_ID AOR ID where user has membership. smallint