set-dnsserverforwarder -using list of IP addresses

[lawson2312]

I have to make a mass change to a bunch of dns forwarders IP addresses.  My issue is I’m importing a CSV of the server and IP addresses.  When I run my code I get:

PowerShell

[crayon-60081decd97bf768655588 inline="true" ]Set-DnsServerForwarder : Cannot process argument transformation on parameter 'IPAddress'. Cannot convert value "172.27.231.254, 172.27.254.68, 172.27.227.49, 172.28.5.47" to type "System.Net.IPAddress[]". Error: "Cannot convert value "172.27.231.254, 172.27.254.68, 172.27.227.49, 172.28.5.47" to type "System.Net.IPAddress". Error: "An invalid IP address was specified.""

1 2 3 4

[crayon-60081decd97bf768655588 inline="true" ]Set-DnsServerForwarder : Cannot process argument transformation on parameter 'IPAddress'. Cannot convert value "172.27.231.254, 172.27.254.68, 172.27.227.49, 172.28.5.47" to type "System.Net.IPAddress[]". Error: "Cannot convert value "172.27.231.254, 172.27.254.68, 172.27.227.49, 172.28.5.47" to type "System.Net.IPAddress". Error: "An invalid IP address was specified.""

[/crayon]

CODE:

PowerShell

[crayon-60081decd97c3789618201 inline="true" ] $newForwarders = import-csv -path C:\Temp\ADQueries\VA_DNSForwarders_new.csv $newforwarders | ForEach-Object { $IP = [IPAddress]$_.NewIP.Trim() write-host $_.name "and" $_.newip Get-DnsServerForwarder -ComputerName $_.name | select-object name,ipaddress Set-DnsServerForwarder -ComputerName $_.name -IPAddress $IP Get-DnsServerForwarder -ComputerName $_.name | select-object name,ipaddress }

1 2 3 4 5 6 7 8 9 10 11

[crayon-60081decd97c3789618201 inline="true" ] $newForwarders = import-csv -path C:\Temp\ADQueries\VA_DNSForwarders_new.csv   $newforwarders | ForEach-Object { $IP = [IPAddress]$_.NewIP.Trim() write-host $_.name "and" $_.newip Get-DnsServerForwarder -ComputerName $_.name | select-object name,ipaddress   Set-DnsServerForwarder -ComputerName $_.name -IPAddress $IP Get-DnsServerForwarder -ComputerName $_.name | select-object name,ipaddress }

[/crayon]

I added this as you can see above to convert the value but of course I have a string of multiple IP values. Any ideas how I resolve this? As now I’m getting:

PowerShell

[crayon-60081decd97c6610166095 inline="true" ]Cannot convert value "172.27.254.68,172.27.227.49,172.28.5.47" to type "System.Net.IPAddress". Error: "An invalid IP address was specified."

1 2	[crayon-60081decd97c6610166095 inline="true" ]Cannot convert value "172.27.254.68,172.27.227.49,172.28.5.47" to type "System.Net.IPAddress". Error: "An invalid IP address was specified."

[/crayon]

List of data in csv:

PowerShell

[crayon-60081decd97c9866389166 inline="true" ]IPAddress,NewIP,Name "172.27.254.68, 172.26.1.59, 172.26.134.11","172.27.254.68,172.27.227.49,172.28.5.47",IAD0DC.domain.com "172.26.1.59, 172.26.134.11, 172.29.74.44","172.27.227.49, 172.28.5.47",CLE7DC.domain.com

1 2 3

[crayon-60081decd97c9866389166 inline="true" ]IPAddress,NewIP,Name "172.27.254.68, 172.26.1.59, 172.26.134.11","172.27.254.68,172.27.227.49,172.28.5.47",IAD0DC.domain.com "172.26.1.59, 172.26.134.11, 172.29.74.44","172.27.227.49, 172.28.5.47",CLE7DC.domain.com

[/crayon]

• This topic was modified 1 month, 2 weeks ago by lawson2312.
• This topic was modified 1 month, 2 weeks ago by lawson2312.

[Rob Simmers Participant Topics: 17 Replies: 1951 Points: 3,987Rank: Community Hero]

Duplicate post: https://powershell.org/forums/topic/set-dnsserverforwarder-using-list-of-ip-addresses-for-changes/

[Author]

Posts