InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comFri, 24 May 2013 18:12:00 GMT20http://www.sqlservercentral.com/Forums/Topic1152292-1318-1.aspxHi How i can get all remote servers IP add and host name ? you have any updated script?Thu, 16 Feb 2012 13:46:01 GMTlogicinside22http://www.sqlservercentral.com/Forums/Topic1152292-1318-1.aspx[quote]Select client_net_address,local_net_addressfrom sys.dm_exec_connectionswhere session_id=@@SPId;[/quote]- This worksYours does not on our cluster evironment (NULL)[quote] create table #temp (ipLine varchar(200)) insert #temp exec master..xp_cmdshell 'ipconfig'[/quote]Fri, 30 Sep 2011 13:09:25 GMTvlad-548036http://www.sqlservercentral.com/Forums/Topic1152292-1318-1.aspxAwesome!Thanks!Wed, 03 Aug 2011 22:36:18 GMTsunshine-587009http://www.sqlservercentral.com/Forums/Topic1152292-1318-1.aspxIf you're running SQL Server 2005 or above you can use this (some shops disable xp_cmdshell):[code]Select client_net_address,local_net_addressfrom sys.dm_exec_connectionswhere session_id=@@SPId;[/code]Limitation: You only get IP addresses if you're connective 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 using this technique.Tue, 02 Aug 2011 10:51:32 GMTPeter E. Kiersteadhttp://www.sqlservercentral.com/Forums/Topic1152292-1318-1.aspxHi all!I suggest a little add on to this 'IP-script' as follows:OR upper (ipLine) like '%IPv4 ADDRESS%'Cheers,Bertil FTue, 02 Aug 2011 00:20:40 GMTBertil Forsberghttp://www.sqlservercentral.com/Forums/Topic1152292-1318-1.aspxComments posted to this topic are about the item [B]<A HREF="/scripts/IP+Addresses/75193/">Get SQL Server IP Address</A>[/B]Mon, 01 Aug 2011 23:22:12 GMTsunshine-587009