Hello Guys,

Please dont try use master.sys.xp_cmdshell, becouse of security reason it might be blocked.

u can use the DMV dm_exec_connections to get the info:

SELECT TOP 1 local_net_address FROM sys.dm_exec_connections...