help on powershell script

Question

Hi,

We need to change around 2000 member servers dynamic DNS A records to static. I have it in csv or text format.
Can anyone share how to script to change them?

Thank you.

Answer 1

This PowerShell should sort it.

foreach ($server in (Get-Content c:\Computers.txt)) {

$OldObj = Get-DnsServerResourceRecord -Name $server -ZoneName "mydomain.local.com" -RRType "A"
$NewObj = $OldObj.Clone()
$NewObj.TimeToLive = [System.TimeSpan]::FromHours(0)
Set-DnsServerResourceRecord -NewInputObject $NewObj -OldInputObject $OldObj -ZoneName "mydomain.local.com" -PassThru

}

--please don't forget to Accept as answer if the reply is helpful--

Answer 2

Do I need to run the script on a domain controller?

I think that's how I did my testing but it was quite a while ago.

--please don't forget to Accept as answer if the reply is helpful--

Answer 3

Thanks for your quick response and help.

I did check Get-Content c:\tmp\Computers.txt and got the computers names
changed the computer name in txt file to bios name with no mydomain.local.com

still same errors and let me know what else I can try? Do I need to run the script on a domain controller?

Thank you again!

Answer 4

Sounds like the record for that $server did not exist.

--please don't forget to Accept as answer if the reply is helpful--

Answer 5

Sorry for the reply and did not get a chance

Here is error I got when I ran the script. (I did replace mydomain.local.com with my zone name)

Get-DnsServerResourceRecord : Failed to get the zone information for mydomain.local.com on server server1.
At line:2 char:12

• $OldObj = Get-DnsServerResourceRecord -Name $server -ZoneName "mydomain ...
• ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
• CategoryInfo : NotSpecified: (mydomain.local.com:root/Microsoft/...rResourceRecord) [Get-DnsServerResourceRec
  ord], CimException
• FullyQualifiedErrorId : WIN32 1722,Get-DnsServerResourceRecord

You cannot call a method on a null-valued expression.
At line:3 char:2

• $NewObj = $OldObj.Clone()
• ~~~~~~~~~~~~~~~~~~~~~~~~~
• CategoryInfo : InvalidOperation: (:) [], RuntimeException
• FullyQualifiedErrorId : InvokeMethodOnNull

The property 'TimeToLive' cannot be found on this object. Verify that the property exists and can be set.
At line:4 char:2

• $NewObj.TimeToLive = [System.TimeSpan]::FromHours(0)
• ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
• CategoryInfo : InvalidOperation: (:) [], RuntimeException
• FullyQualifiedErrorId : PropertyNotFound

Set-DnsServerResourceRecord : Cannot validate argument on parameter 'NewInputObject'. The argument is null or empty.
Provide an argument that is not null or empty, and then try the command again.
At line:5 char:46

• Set-DnsServerResourceRecord -NewInputObject $NewObj -OldInputObject ...
• ~~~~~~~
• CategoryInfo : InvalidData: (:) [Set-DnsServerResourceRecord], ParameterBindingValidationException
• FullyQualifiedErrorId : ParameterArgumentValidationError,Set-DnsServerResourceRecord