Running this as a Data Explorer query will give a list of all users with shared registration_ip_addresses. It will exclude users created through the API, or SSO, where the registration_ip_address is NULL.
WITH users_per_ip AS (
SELECT
count(1) AS user_count,
u.registration_ip_address AS ip
FROM users u
GROUP BY ip
)
SELECT
u.id AS user_id,
upi.ip AS ip_address
FROM users_per_ip upi
JOIN users u
ON u.registration_ip_address = upi.ip
WHERE upi.user_count > 1
ORDER BY upi.ip, u.username