Description
Displays a list of ASP.NET membership users associated with the unique identifier for the user.
Columns
| Name |
Type |
Required? |
Defaults To |
Description |
| UserId |
uniqueidentifier |
Yes |
|
User ID
|
| PasswordFormat |
int |
Yes |
|
Password format (0=Plaintext, 1=Hashed, 2=Encrypted)
|
| MobilePIN |
nvarchar |
No |
|
User's mobile PIN (currently not used)
|
| Email |
nvarchar |
No |
|
User's e-mail address
|
| LoweredEmail |
nvarchar |
No |
|
User's e-mail address (lowercase)
|
| PasswordQuestion |
nvarchar |
No |
|
Password question
|
| PasswordAnswer |
nvarchar |
No |
|
Answer to password question
|
| IsApproved |
bit |
Yes |
|
1=Approved, 0=Not approved
|
| IsLockedOut |
bit |
Yes |
|
1=Locked out, 0=Not locked out
|
| CreateDate |
datetime |
Yes |
|
Date and time this account was created
|
| LastLoginDate |
datetime |
Yes |
|
Date and time of this user's last login
|
| LastPasswordChangedDate |
datetime |
Yes |
|
Date and time this user's password was last changed
|
| LastLockoutDate |
datetime |
Yes |
|
Date and time this user was last locked out
|
| FailedPasswordAttemptCount |
int |
Yes |
|
Number of consecutive failed login attempts
|
| FailedPasswordAttemptWindowStart |
datetime |
Yes |
|
Date and time of first failed login if FailedPasswordAttemptCount is nonzero
|
| FailedPasswordAnswerAttemptCount |
int |
Yes |
|
Number of consecutive failed password answer attempts
|
| FailedPasswordAnswerAttemptWindowStart |
datetime |
Yes |
|
Date and time of first failed password answer if FailedPasswordAnswerAttemptCount is nonzero
|
| Comment |
ntext |
No |
|
Additional text
|
| ApplicationId |
uniqueidentifier |
Yes |
|
Application ID
|
| UserName |
nvarchar |
Yes |
|
User name
|
| MobileAlias |
nvarchar |
No |
|
User's mobile alias (currently not used)
|
| IsAnonymous |
bit |
Yes |
|
1=Anonymous user, 0=Not an anonymous user
|
| LastActivityDate |
datetime |
Yes |
|
Date and time of last activity by this user
|
Tables Referenced
Definition
SELECT [dbo].[aspnet_Membership].[UserId],
[dbo].[aspnet_Membership].[PasswordFormat],
[dbo].[aspnet_Membership].[MobilePIN],
[dbo].[aspnet_Membership].[Email],
[dbo].[aspnet_Membership].[LoweredEmail],
[dbo].[aspnet_Membership].[PasswordQuestion],
[dbo].[aspnet_Membership].[PasswordAnswer],
[dbo].[aspnet_Membership].[IsApproved],
[dbo].[aspnet_Membership].[IsLockedOut],
[dbo].[aspnet_Membership].[CreateDate],
[dbo].[aspnet_Membership].[LastLoginDate],
[dbo].[aspnet_Membership].[LastPasswordChangedDate],
[dbo].[aspnet_Membership].[LastLockoutDate],
[dbo].[aspnet_Membership].[FailedPasswordAttemptCount],
[dbo].[aspnet_Membership].[FailedPasswordAttemptWindowStart],
[dbo].[aspnet_Membership].[FailedPasswordAnswerAttemptCount],
[dbo].[aspnet_Membership].[FailedPasswordAnswerAttemptWindowStart],
[dbo].[aspnet_Membership].[Comment],
[dbo].[aspnet_Users].[ApplicationId],
[dbo].[aspnet_Users].[UserName],
[dbo].[aspnet_Users].[MobileAlias],
[dbo].[aspnet_Users].[IsAnonymous],
[dbo].[aspnet_Users].[LastActivityDate]
FROM [dbo].[aspnet_Membership] INNER JOIN [dbo].[aspnet_Users]
ON [dbo].[aspnet_Membership].[UserId] = [dbo].[aspnet_Users].[UserId]
ASP.NET 2.0 Provider Database