How do I search for IP addresses?


XenForo moderator
Staff member
There is no way of searching for a user based on IP address.

You could check in the xf_ip table.

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('')
GROUP BY user.user_id
Replace with the IP you want to search for.