HP Brocade 8/12c Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 88

E Database tables and fields TABLE 147 USER_ Field ID * NAME DESCRIPTION PASSWORD EMAIL NOTIFICATION_ENABLED FULL_NAME PHONE_NUMBER INVALID_LOGIN_COUNT LOCKED_OUT_DATETIME STATUS SOURCE_OF_CREATION Definition Format int User name. varchar User description. varchar User password. varchar User e-mail ID. varchar Flag for e-mail notification. Default value is 0. smallint User''s Full Name. varchar User''s Phone number. varchar 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 The date time stamp when a user got locked out because of exceeding max number of invalid login attempts. timestamp User''s account status: 0=Disabled 1=Enabled Default value is 1. smallint 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 148 USER_RESOURCE_MAP Field Definition Format USER_NAME* RESOURCE_GROUP_ID* User name. varchar Resource group name, which is mapped for the user. int TABLE 149 RESOURCE_GROUP Field Definition ID* NAME DESCRIPTION Resource group name. Resource group description. Format int varchar varchar Size 128 512 512 1024 512 32 Size 128 Size 128 512 80 Brocade Network Advisor Documentation Updates 53-1002363-02