userauthenticationlockoutstats

2 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
UserName VARCHAR 15 null
lt_wcc2_sessions.UserName Implied ConstraintR
v_tickets.UserName Implied ConstraintR
v_time.UserName Implied ConstraintR
v_xr_sap_reportproperties.Username Implied ConstraintR

UserName provided during login
UserID INT UNSIGNED 10 √ null
LastIPAddress VARCHAR 50 √ null

Last IP Address reported for authentication
FailedLoginCount INT UNSIGNED 10 √ null

Number of Failed Logins, it doesn’t count logins during lockdown.
LastFailDate DATETIME 19 null

UTC Time
LockOutExpirationDate DATETIME 19 √ null

UTC Time
CreatedBy VARCHAR 100 null

UserName of user that created Record.
CreateDate DATETIME 19 null
UpdatedBy VARCHAR 100 null

UserName of last user that modified Record.
UpdateDate DATETIME 19 null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc UserName
LOCKOUTEXPIRATIONDATE Performance Asc LockOutExpirationDate
USERID Performance Asc UserID

Relationships

Close relationships within degrees of separation