Find Sessions Connected by IP

Try this:

SELECT session_id, client_net_address
    FROM sys.dm_exec_connections