Description
Displays a list of users per application.
Columns
| Name |
Type |
Required? |
Defaults To |
Description |
| ApplicationId |
uniqueidentifier |
Yes |
|
Application ID
|
| UserId |
uniqueidentifier |
Yes |
|
User ID
|
| UserName |
nvarchar |
Yes |
|
User name
|
| LoweredUserName |
nvarchar |
Yes |
|
User name (lowercase)
|
| 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_Users].[ApplicationId], [dbo].[aspnet_Users].[UserId], [dbo].[aspnet_Users].[UserName], [dbo].[aspnet_Users].[LoweredUserName], [dbo].[aspnet_Users].[MobileAlias], [dbo].[aspnet_Users].[IsAnonymous], [dbo].[aspnet_Users].[LastActivityDate]
FROM [dbo].[aspnet_Users]
ASP.NET 2.0 Provider Database