Brocade Network Advisor 12.1.X Documentation Updates (53-1003016-05, January 2014)

1474 Brocade Network Advisor SAN User Manual
53-1002948-01
Database tables and fields
H
TABLE 391 TRUNK_GROUP_MEMBER
Field Definition Format Size
TRUNK_GROUP_MEMBER_I
D
Primary key for this table. int
INTERFACE_ID Foreign key which refers INTERACE table. int
TRUNK_INTERFACE_ID Foreign key which refers TRUNK_GROUP_INTERACE
table.
int
TABLE 392 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
applciation 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