Last Login Logging?

Jul 27, 2011 at 2:00 PM

Hello,

Does the FBA allow for me to see when a user last logged into the system?  If not, is there another way that I can do this?  

Thank you in advance!  Your application is awesome!

 

Kind Regards,

Jerry

Coordinator
Jul 27, 2011 at 9:14 PM

The FBA Pack doesn't currently show the last time a user logged in (but feel free to add this feature request to the issue tracker).

Currently though you can query the membership database to find out this information.  There's a column in the aspnet_membership table named LastLoginDate that should give you the information you need.

The following query should give the last login date for a specific user:

SELECT *
FROM aspnet_membership JOIN aspnet_users ON aspnet_membership.userid = aspnet_users.userid
WHERE aspnet_users.username = 'theusername'

Or just leave the WHERE clause off to get it for all users.

Hopefully the query works, but I don't currently have access to an environment to test it.

Aug 1, 2011 at 4:37 PM

You are awesome as usual!  The command works like a charm.  Thank you!

Upon your suggestion, I'll be adding this to the Issue Tracker for possible inclusion in the next release.

 

Keep up the great work!