Search for an IP (query)

[Jake Bunce]

There is currently no utility in the software to search for an IP address, but you can use a query.

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.

Use this if you want to specify a range of IPs:

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 BETWEEN INET_ATON('xxx.xxx.xxx.1') AND INET_ATON('xxx.xxx.xxx.255')
GROUP BY user.user_id

You have to specify the beginning and end of the range.

You will get results like this:

 

[Dean]

Thank you Jake, much appreciated.

 

[Floris]

Thank you Jake