it needs just single line of code

SELECT CONVERT(char(15), CONNECTIONPROPERTY('client_net_address'))

Below query returns IP address and the workstation name of the client machine (not the server).

SELECT CONNECTIONPROPERTY('client_net_address') AS IpAddress,
       HOST_NAME() AS ClientMachineName

Reference: https://learn.microsoft.com/en-us/sql/t-sql/functions/host-name-transact-sql?view=sql-server-ver15

Example

The following example creates a table that uses HOST_NAME() in a DEFAULT definition to record the workstation name of computers that insert rows into orders table.

CREATE TABLE Orders_demo  
(
  OrderID     INT        PRIMARY KEY,  
  OrderDate   DATETIME   NOT NULL,
  Workstation NCHAR(30)  NOT NULL     DEFAULT HOST_NAME()
);

I couldn't get the exact numeric IP address, instead I got a NULL value because of the limitation of the above statements. The limit is that you only get IP addresses if you're connected via TCP/IP. If you're local and using Shared Memory then those attributes don't exist. If you turn off Shared Memory (or any protocols except for TCP/IP) via Server Configuration Manager you will always get IP address for any connection.

You are best stuck with

SELECT SERVERPROPERTY(N'MachineName');

... which can act in place of numeric IP address.

try this

DECLARE @IP_Address varchar(255);
SELECT @IP_Address = client_net_address
FROM sys.dm_exec_connections
WHERE Session_id = @@SPID;

select @IP_Address;

In Windows Server 2019, utilize the following query to retrieve the clients IP Address information:

SELECT session_id, client_net_address
    FROM sys.dm_exec_connections

The result:

To get more details:

SELECT   
    Clients.session_id AS SessionId , Clients.net_transport AS NetTransport,
    Clients.auth_scheme As AuthScheme, Clients.encrypt_option AS EncryptOption, 
    Servers.host_name AS HostName, Servers.nt_domain AS Domain,
    Servers.program_name As ProgramName, Servers.login_name AS LoginName,
    Servers.nt_user_name AS NtUserName,  Servers.original_login_name AS OriginalLoginName,
    Servers.client_interface_name AS ClientInterfaceName, Servers.status AS ServerStatus,
    Clients.connect_time AS ClientConnectTime, Servers.login_time   
FROM sys.dm_exec_connections AS Clients  
JOIN sys.dm_exec_sessions AS Servers
    ON Clients.session_id = Servers.session_id

The result:

I found something which might work for you

CREATE FUNCTION [dbo].[GetCurrentIP] ()
RETURNS varchar(255)
AS
BEGIN
    DECLARE @IP_Address varchar(255);

    SELECT @IP_Address = client_net_address
    FROM sys.dm_exec_connections
    WHERE Session_id = @@SPID;

    Return @IP_Address;
END

From How to get Client IP Address in SQL Server

Also have a look at this article about Get client IP address

You can try out this solution . It even works on shared hosting:

select CONNECTIONPROPERTY('client_net_address') AS client_net_address

Ultimately join the two system tables:

SELECT  hostname,
        net_library,
        net_address,
        client_net_address
FROM    sys.sysprocesses AS S
INNER JOIN    sys.dm_exec_connections AS decc ON S.spid = decc.session_id
WHERE   spid = @@SPID

Output:

hostname | net_library | net_address | client_net_address    
PIERRE   | TCP/IP      | 0090F5E5DEFF| 10.38.168.5