Menu
Reply To Topic Topic: Useful DNN SQL Scripts
:
Posted By Deleted User on 10/10/2013 1:55 PM
Record of User Logins Put this in a Report to see who has been logging in and when. Select AU.Username, U.FirstName, U.LastName, AM.loweredEmail, AM.CreateDate, AM.LastLoginDate from aspnet_Membership as AM with (nolock) join aspnet_Users as AU with (nolock) on AM.UserID = AU.UserID join Users as U with (nolock) on U.UserName = AU.Username where AM.ApplicationID = (select ApplicationID from dbo.aspnet_Applications where ApplicationName = 'DotNetNuke') ORDER BY AM.LastLoginDate DESC
Username: 
Security Code:
CAPTCHA image
Enter the code shown above in the box below.
Subject:
RE: Useful DNN SQL Scripts
Message:
Smilies

Submit

Cancel
Subscribe:
Topic Review