User login report showing failed and successful attempts

sharepoint2010
codeplex

#1
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

#2
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).

#3
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.