Get IP Address
Here is a method of getting the IP Address of a system using Stored Procedure
Create Procedure Get_IPAddress
(@sysName varchar(30))
as
Set Nocount On
Create table #t (data varchar(100))
Declare @sql varchar(100)
Set @sql='Ping -n 1 '+@sysname
Insert into #t
Exec Master..xp_cmdShell @sql
If exists (select * from #t where data like '%Unknown%')
Select 'The system '+@sysName+' doesnt exist' as Error
else
Select Substring(data,charindex('[',data,1)+1,charindex(']',data,1)-(charindex('[',data,1)+1))
as IPAddress from #t where data like '%bytes of data%'
drop table #t
Set Nocount Off
Run this procedure as
EXEC Get_IPAddress 'systemName'