• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

How do I search for IP addresses?

Jake Bunce

XenForo moderator
Staff member
Here is a query you can run on your database to retrieve a list of all users that have used a particular IP address:

SELECT user.username, INET_NTOA(ip.ip)
FROM xf_ip AS ip
LEFT JOIN xf_user AS user ON (user.user_id = ip.user_id)
WHERE ip.ip = INET_ATON('xxx.xxx.xxx.xxx')
GROUP BY user.user_id
Replace xxx.xxx.xxx.xxx with the IP you want to search for.