Title: Extract IP from _wfLockedOut using SQL
Last modified: August 30, 2016

---

# Extract IP from _wfLockedOut using SQL

 *  [TerminalAddict](https://wordpress.org/support/users/terminaladdict/)
 * (@terminaladdict)
 * [10 years, 5 months ago](https://wordpress.org/support/topic/extract-ip-from-_wflockedout-using-sql/)
 * I notice you store IPs in a binary field.
    how can I use SQL to get a list of
   locked out users?
 * [https://wordpress.org/plugins/wordfence/](https://wordpress.org/plugins/wordfence/)

Viewing 1 replies (of 1 total)

 *  Plugin Author [WFMattR](https://wordpress.org/support/users/wfmattr/)
 * (@wfmattr)
 * [10 years, 5 months ago](https://wordpress.org/support/topic/extract-ip-from-_wflockedout-using-sql/#post-6855981)
 * The IPs are packed and unpacked by functions defined in wordfence/lib/wfUtils.
   php: wfUtils::inet_pton() and wfUtils::inet_ntop()
 * You can use these two functions in your own code to do the same, but they’re 
   not officially part of a public API, so they may change in the future, along 
   with the data format of the database.
 * -Matt R

Viewing 1 replies (of 1 total)

The topic ‘Extract IP from _wfLockedOut using SQL’ is closed to new replies.

 * ![](https://ps.w.org/wordfence/assets/icon.svg?rev=2070865)
 * [Wordfence Security - Firewall, Malware Scan, and Login Security](https://wordpress.org/plugins/wordfence/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/wordfence/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/wordfence/)
 * [Active Topics](https://wordpress.org/support/plugin/wordfence/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/wordfence/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/wordfence/reviews/)

 * 1 reply
 * 2 participants
 * Last reply from: [WFMattR](https://wordpress.org/support/users/wfmattr/)
 * Last activity: [10 years, 5 months ago](https://wordpress.org/support/topic/extract-ip-from-_wflockedout-using-sql/#post-6855981)
 * Status: not resolved