SQL check client IP

select

conns.client_net_address, conns.auth_scheme, sess.* from sys.dm_exec_sessions sess

LEFT OUTER JOIN sys.dm_exec_connections conns on sess.session_id = conns.session_id

exec sp_who2