How to access log entries from the database via SQL?

I’d like to be able to analyze the number of lockouts per week via a SQL query of the database, or through some similar processing. First, I’ve attempted to see where the data is stored. From an earlier support thread, I learned the log entries were stored in the wp_options table. After some sleuthing, it appears to be stored under option_name = 'limit_login_logged'.

However, this seems to be incomplete. Currently, my Lockout Log contains about 5700 lines, but the wp_options.limit_login_logged field only seems to contain about 250 lines. Is there a separate log file somewhere where the Lockout Log entries are stored?

• This topic was modified 4 years, 2 months ago by martin4nbi.