Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1550
  • Last Modified:

Script to resolve hostnames to Ip addresses

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
security_guy
Asked:
security_guy
  • 2
  • 2
1 Solution
 
Shift-3Commented:
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
 
security_guyAuthor Commented:
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
 
Shift-3Commented:
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
 
security_guyAuthor Commented:
Thank you very much!!!!!!!!!!!!!!!!!!!!
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now