You can get local ip address using sql using following script.
Execute below script , it will return ip address of client system.
DECLARE @IP_Address varchar(255)
SELECT @IP_Address = client_net_address FROM sys.dm_exec_connections
WHERE Session_id = @@SPID
print(@IP_Address)