Get SQL Server IP Address

begin
Declare @ipLine varchar(200)
Declare @pos int
dECLARE @ip varchar(40) 
set nocount on
set @ip = NULL
Create table #temp (ipLine varchar(200))
Insert #temp exec master..xp_cmdshell 'ipconfig'
select @ipLine = ipLine
from #temp
where upper (ipLine) like '%IP ADDRESS%'
if (isnull (@ipLine,'***') != '***')
begin 
set @pos = CharIndex (':',@ipLine,1);
set @ip = rtrim(ltrim(substring (@ipLine , 
@pos + 1 ,
len (@ipLine) - @pos)))
end 
SELECT distinct(rtrim(ltrim(substring (@ipLine , 
@pos + 1 ,
len (@ipLine) - @pos)))) AS IPAddress FROM #TEMP
drop table #temp
set nocount off
end 
go