Solved

Script to resolve hostnames to Ip addresses

Posted on 2009-04-09
4
1,480 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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 500 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

Optimize your web performance

What's in the eBook?
- Full list of reasons for poor performance
- Ultimate measures to speed things up
- Primary web monitoring types
- KPIs you should be monitoring in order to increase your ROI

Question has a verified solution.

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

In this tutorial I will focus on how to use WhizBase as a tool for sending ICQ messages to ICQ. Here I will use a new technology in WhizBase, published in WhizBase 5.1 version. In this tutorial I will use 3 files, pager.wbsp for the processing, e…
Recently I have been answering a lot of questions like this in IT forums that I frequent. The question posed is usually something along the lines of "We have software X installed and need to uninstall it for reason Y" or some other variant of the sa…
The viewer will learn how to create and use a small PHP class to apply a watermark to an image. This video shows the viewer the setup for the PHP watermark as well as important coding language. Continue to Part 2 to learn the core code used in creat…
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 …

617 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