Powershell: Fill AD computer description with location data

Question

Hi,

I want to fill the description field for computers in a specific AD OU with information from the 'location' tab.

For now, this is what I have:

$computers = Get-ADComputer -Filter * -SearchBase "OU=Blabla,DC=BLABLA" -Properties name | select name
foreach ($computer in $computers)
{$ADlocation = (Get-ADComputer -Filter * -SearchBase "OU=Blabla,DC=BLABLA" -Properties location | select -ExpandProperty location)
Set-ADComputer -Identity $computer –Description “$ADLocation”
}

At this point, the script runs but nothing happens in AD. I don't get any errors.
Is this the right way to define the variable for the location property? What else is wrong here? Hope someone can help me out.

Answer 1

Hello,

If the programatically way fails, you can try to run manually to see if any error appears during the input of data.

For example run:

Get-ADComputer <hostname> -Properties location | select -ExpandProperty location

then

Set-ADComputer <hostname> –Description “<manual input of location>”

--If the reply is helpful, please Upvote and Accept as answer--

Answer 2

Try this:

Get-ADComputer -Filter * -SearchBase "OU=Blabla,DC=BLABLA" -Properties name,location,description |
    ForEach-Object  {
            Set-ADComputer -Identity $_.distinguishedName -Description $_.location
    }