Show IP addresses of sessions connected to SQL Server

Use the following query to see the IP addresses of the connection to SQL Server and since how long they have been connected.

SELECT session_id, client_net_address, connect_time 
FROM sys.dm_exec_connections;