Author Posts

January 4, 2017 at 6:59 pm

Hello All,

My objective is to run a script of a bunch of URL's to get the IP address to export to a spreadsheet. I am new to powershell. If I hardcode the powershell below it works fine:

$url="www.yahoo.com"
$Addresses = [System.Net.Dns]::GetHostAddresses("$url")[0].IPAddressToString
write-host $Addresses

However, when I try to call the code from a foreach loop

$testcsv= Get-Content c:\scripts\URLS2.txt

foreach($url in $testcsv)

{

$Addresses = [System.Net.Dns]::GetHostAddresses("$url")[0].IPAddressToString
write-host $Addresses

}

It throws an error as follows:

Exception calling "GetHostAddresses" with "1" argument(s): "No such host is known"
At line:8 char:1
+ $Addresses = [System.Net.Dns]::GetHostAddresses("$url")[0].IPAddressToString
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : NotSpecified: (:) [], MethodInvocationException
+ FullyQualifiedErrorId : SocketException

I'm sure the logic I am doing is wrong, any help would be greatly appreciated!

Happy New Year everyone!

January 4, 2017 at 7:02 pm

And what does that .TXT file look like?

(also, please consider formatting your code – instructions are listed above the posting textbox)

January 4, 2017 at 7:03 pm

As a sample to test the concept the txt file looks like this:

http://www.google.com
http://www.yahoo.com

thanks for quick reply...

January 4, 2017 at 7:04 pm

So, "http://" is not a valid part of a host name. You didn't use that in your first example.

January 4, 2017 at 7:48 pm

Thanks works appreciate help!