SQL code to find IP Addresses of Potential Broker Accounts

Hello,

We recently got some SQL code to find IP addresses. We are using this to check accounts that are created that we feel might be a broker purchase. The code will look at every time they accesses the web so you can get each one. The web session table holds this data for 14 days so you won't see anything beyond that. We've already found the code helpful. I use https://nordvpn.com/ip-lookup/ to look up where the IP is located to compare to the mailing address. This isn't fool proof as a VPN could circumnavigate that but it's something.

SELECT DISTINCT s.*
FROM t_web_session_Session AS s
WHERE s.IP <> '::1' AND s.IP <> ''
AND s.customer_no IN (
XXXXX
)
ORDER BY StartDateTime;

The XXXXX is where you put the account number and you can comma separate it if you'd like.

- Chris