user login report showing failed and successful attempts

Sep 30, 2014 at 10:28 PM
Is there a way to get a report showing failed and successful login attempts?

We have a client that is asking for this as part of their initiative to become HIPAA compliant.

Thanks
Coordinator
Oct 1, 2014 at 1:18 AM
You can query the aspnetdb directly for some of this information:
aspnet_membership table:
lastlogindate (last successful login per user)
lastlockoutdate (last time they were locked out due to excessive bad passwords)

Additionally, the windows event viewer logs failed login attempts (it may also log successful attempts - not sure off the top of my head).
Nov 15, 2014 at 7:59 PM
Thank you.

We've posted a job on Elance to find somebody to help us build this report. The job is located at https://www.elance.com/job/64656049/proposals in case anybody is interested.