Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

is there a way to grab an IP addres

Status
Not open for further replies.

tek2002

Programmer
Joined
Aug 21, 2001
Messages
67
Location
US
is there a way to grab an IP address from sql server 2000
system tables or something...this is assuming that its stored in one of the sys tables.

if anyone knows, please let me know.

thanks
 
Unfortunately IP addresses are not held in any of the system tables.

If you are running SMS then you could pick them up from the SMS database tables.

Failing this then your into NT country. And from there it's accessing the WINS (if you run WINS) database through some VB code or something like that. If your not running WINS then the IP addresses are held somewhere else but I’m sorry I can't recall where.

Rick.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top