Does anyone have an idea or script to notify a user that their account has been locked out due to reaching the max logon attempts? Yes, there’s a setting where I personally can get an email (Account Lockout Notify User), but nothing for the user themselves (telling them that they’ve been locked out, there’s a 15 minute lockout period, contact helpdesk if needed…etc.).
If someone knows the database side of Agile better than I do, I’m sure the script will have something to do with my other Agile question on this site, the “Auto-Inactivate Users” post. That post uses SQL to find last log-in date and I have that sending a notification. My thought is that something similar can be used for account lockout, but I’m unsure about the server side of things.
Let me know if you have any suggestions.
To answer my own question for anyone in the future, you would need to tap into the ACCOUNT_LOCKOUT_NOTIFY table. Not sure if this would be a quick scheduled event, like a PX, that looks for anyone locked out. I’m at a new company now where this is no longer an issue.
Available columns within this database table include: ID, SEND_USER_ID, NOTIFY_USER_ID, USER_ID, TEMPLATE_ID, and RESET_PASSWORD