- A customer can reset his password.
- Magento tracks this password reset requests.
- Where in the DB is this information stored?
customer_entity holds the field
first_failure to keep the record of unsuccessful password attempts.
Please check and let me know if it helps.
Addition: The same table also keeps the
Reset password token and
Reset password token creation time to identify when the customer tried to reset password last time.