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

Brocade Network Advisor SAN + IP User Manual 2203
53-1002949-01
Database tables and fields
I
TABLE 451 TRUNK_GROUP_INTERFACE
Field Definition Format Size
INTERFACE_ID int
VLAG Specifies whether the lag is a vlag or not smallint
TABLE 452 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 453 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