Folks are making this harder than it needs to be …
One line of Windows CMD will get you 85% of the way there & you can use Word to finish the job.
Create your list of servers as a text file, one name per line, something like:
www.sdmb.com
www.google.com
www.straightdope.com
www.badDNSname.wer
www.irs.gov
Save that file someplace named “ServerList.txt”, open a CMD window & CD to the folder where the file is. Enter these 2 commands:
C:\...>(for /f %e in (ServerList.txt) do echo Server: %e ## & tracert -h 1 %e) | findstr "^Server ^Tracing ^Unable" > ServerAndIPAddressList.txt
C:\...>ServerAndIPAddressList.txt
Viola! Notepad opens with a file that looks like this:
Server: www.sdmb.com ##
Tracing route to www.sdmb.com [69.25.27.173]
Server: www.google.com ##
Tracing route to www.google.akadns.net [64.233.167.104]
Server: www.straightdope.com ##
Tracing route to straightdope.com [69.20.125.245]
Server: www.badDNSname.qwe ##
Unable to resolve target system name www.badDNSname.qwe.
Server: www.irs.gov ##
Tracing route to a321.g.akamai.net [66.77.99.136]
So now you have the servername, the real name if the name you used was an alias (which is usually the case), and either the IP address or an error message. That’s plenty good enough for people to read, but if you need something more strongly formatted to feed into another program, you can then open that ServerAndIPAddressList.txt file in Word, and do the following 5 Replace Alls (without the quotes)
Find: "Server: " -> Replace: ""
" ##^p" -> ","
"Tracing route to " -> ""
" [" -> ","
"]" -> ""
The result of that looks like this:
www.sdmb.com,www.sdmb.com,69.25.27.173
www.google.com,www.google.akadns.net,64.233.167.104
www.straightdope.com,straightdope.com,69.20.125.245
www.badDNSname.qwe,Unable to resolve target system name www.badDNSname.qwe.
www.irs.gov,a321.g.akamai.net,69.44.123.142
If you save that result from Word as a txt file named “AllNames.txt”, you can then separate the good & bad DNS names with these 2 CMD commands:
C:\...>find /v "Unable to" <AllNames.txt >GoodNames.txt
C:\...>find "Unable to" <AllNames.txt >BadNames.txt
GoodNames.txt is now ready to feed into a database or spreadsheet or ???, and BadNames.txt can be checked by the people to figure out where the bad names came from & how to fix them.
That wasn’t so hard.