We presently have about 19K user records in our DB.  We have several people lock themselves out every week (we have many elderly users).  Is there a way that I can get a list of the users that are locked out at any given time?  Is there functionality in the DNN admin interface to do this?  If not what tables do I need to query other than the users table to get this information?

I'd like to create a daily report that will show me a list of all the locked out users so that we can be more pro-active in helping them out ...

Thanks!

Thanks Sebastian,

I was able to get the data using this SQL:

SELECT u.UserID, FirstName, LastName, u.Email, LastLoginDate, LastLockoutDate, CreateDate, LastPasswordChangedDate
FROM aspnet_membership am
INNER JOIN users u on u.email  = am.email
WHERE islockedout = 'true'
ORDER BY lastlogindate desc