How to Know IPconfig/All from SQL query

Question

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

spaghettidba SSC Guru Points: 105732 More actions · Answer 1

What information do you exactly need from ipconfig? Server IP address or what?

-- Gianluca Sartori

forsqlserver SSCoach Points: 18902 More actions · Answer 2

All this:

Host Name . . . . . . . . . . . . : ajayg

Primary Dns Suffix . . . . . . . : intranet.nic.in

Node Type . . . . . . . . . . . . : Unknown

IP Routing Enabled. . . . . . . . : No

WINS Proxy Enabled. . . . . . . . : No

DNS Suffix Search List. . . . . . : intranet.nic.in

nic.in

Ethernet adapter Local Area Connection:

Connection-specific DNS Suffix . :

Description . . . . . . . . . . . : Realtek RTL8169/8110 Family Gigabit Ether

net NIC

Physical Address. . . . . . . . . : 00-1F-D0-5B-6C-3D

DHCP Enabled. . . . . . . . . . . : No

IP Address. . . . . . . . . . . . : 10.1.9.247

Subnet Mask . . . . . . . . . . . : 255.255.255.128

Default Gateway . . . . . . . . . : 10.1.9.129

DNS Servers . . . . . . . . . . . : 10.1.8.10

10.1.8.11

Thanks

spaghettidba SSC Guru Points: 105732 More actions · Answer 3

You could use xp_cmdshell to get this info, but be careful what you do with it, it could lead to possibile security issues.

If you want to use xp_cmdshell you will have to turn it on from surface area configuration.

Example

EXEC xp_cmdshell 'ipconfig /all'

-- Gianluca Sartori

forsqlserver SSCoach Points: 18902 More actions · Answer 4

SSCoach

Points: 18902

May 8, 2009 at 5:12 am

I have not enough words to thanks you.

Thanks