SQL, Get Remote Client IP Address

SELECT *  FROM sys.sysprocesses
spid, dbid, hostname, net_address(Mac), loginname

SELECT  * FROM sys.dm_exec_connections
session_id(spid), client_net_address(IP)

SELECT    
      sys.sysprocesses.hostname,
      sys.sysprocesses.net_address,
      sys.sysprocesses.spid,
      sys.sysprocesses.loginame,
      sys.dm_exec_connections.client_net_address,
      sys.dm_exec_connections.client_tcp_port
FROM         sys.sysprocesses INNER JOIN                      
      sys.dm_exec_connections ON sys.sysprocesses.spid = sys.dm_exec_connections.session_id
WHERE     (sys.sysprocesses.spid = 93)

 

Result.
HOSTNAME   E76A9F1FADEG 93  wareway    xxx.xxx.xxx.xxx  2405