Brocade Network Advisor SAN User Manual v11.1x (53-1002167-01, May 2011)

1054 Brocade Network Advisor SAN User Manual
53-1002167-01
Database tables and fields
E
TABLE 215 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
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
TABLE 216 USER_RESOURCE_MAP
Field Definition Format Size
USER_NAME* User name. varchar 128
RESOURCE_GROUP_ID* Resource group name, which is mapped for the user. int
TABLE 217 RESOURCE_GROUP
Field Definition Format Size
ID* int
NAME Resource group name. varchar 128
DESCRIPTION Resource group description. varchar 512