Get Client and Server IP running MSSQL

SELECT
    client_net_address ClientIP,local_net_address ServerIP
FROM
    sys.dm_exec_connections
WHERE
    session_id = @@SPID;