?
Solved

Script to resolve hostnames to Ip addresses

Posted on 2009-04-09
4
Medium Priority
?
1,590 Views
Last Modified: 2013-11-09
Hello,
do you have or know how to do a simple script that:

-reads a .txt file with hostnames, one per line
-creates a .txt or CSV file with the IP addresses one per line or hostname and IP addresses in one line, one per line.

Thanks
0
Comment
Question by:security_guy
  • 2
  • 2
4 Comments
 
LVL 38

Expert Comment

by:Shift-3
ID: 24107063
Paste the script below into a text file with a .cmd extension.  Customize the value of the input variable on line 4 with the location of the list of hostnames.  Running the script will resolve the names and write output to a .csv file.


@echo off
setlocal enabledelayedexpansion
 
set input=computerlist.txt
set output=report.csv
 
for /F %%G in ('type "%input%"') do (
 set ip=
 for /F "tokens=2 skip=1" %%H in ('nslookup %%G 2^>NUL^|find "Address:"') do (
  set ip=%%H
 )
 echo %%G,!ip!>>"%output%"
)

Open in new window

0
 

Author Comment

by:security_guy
ID: 24107419
oh,, thank you a lot!!

Anyway i can see that it resolves only some hosts. For example my hostname is not resolving, google, and other web sites are not resolving.
Are not resolving web sites with only 1 address and also those with more than one address.

But it resolved "localhost" :)
0
 
LVL 38

Accepted Solution

by:
Shift-3 earned 2000 total points
ID: 24108657
Revised to handle multiple addresses.


@echo off
setlocal enabledelayedexpansion
 
set input=computerlist.txt
set output=report.csv
 
for /F %%G in ('type "%input%"') do (
 set ip=
 
 for /F "tokens=* skip=2" %%H in ('nslookup %%G 2^>NUL') do (
  set line=%%H
  if "!line:~0,8!"=="Address:" set ip=!line:~10!
  if "!line:~0,10!"=="Addresses:" set ip=!line:~12!
 )
 
 echo %%G,!ip!>>"%output%"
)

Open in new window

0
 

Author Comment

by:security_guy
ID: 24109575
Thank you very much!!!!!!!!!!!!!!!!!!!!
0

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you get a (Blue Screen of Death), your system writes a small file called a minidump. Your first step is to make certain your computer is setup to record memory dumps. Right click My Computer, choose properties. Click on the advanced tab, an…
In a question here at Experts Exchange, a member was looking for "a little app that would allow sound to be turned OFF and ON by simply clicking on an icon in the system tray". This article shows how to achieve that, as well as providing the same OF…
Learn the basics of strings in Python: declaration, operations, indices, and slicing. Strings are declared with quotations; for example: s = "string": Strings are immutable.: Strings may be concatenated or multiplied using the addition and multiplic…
The viewer will learn how to create a basic form using some HTML5 and PHP for later processing. Set up your basic HTML file. Open your form tag and set the method and action attributes.: (CODE) Set up your first few inputs one for the name and …
Suggested Courses

588 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question