Query to find SQL Server IP address and client IP address T-SQL

SELECT SERVERPROPERTY('ComputerNamePhysicalNetBIOS') [Machine Name]

   ,SERVERPROPERTY('InstanceName') AS [Instance Name]

   ,LOCAL_NET_ADDRESS AS [IP Address Of SQL Server],

CLIENT_NET_ADDRESS AS [IP Address Of Client]  

FROM SYS.DM_EXEC_CONNECTIONS  WHERE SESSION_ID = @@SPID