Hello All,

I'm new to scripting and have enjoyed all I've done with it so far. The issue at hand is, we would like to add a description to all our servers. I can get a .csv or .txt file with the computer name and description. Is it possible to pull a computer name from AD, match that 'computer name' with one in my .csv file and import the corresponding 'description' into AD ?

I look forward to suggestions on how to get started with this. Thank you.

RD

Hi there,

something like this should match your needs:

Import-Module ActiveDirectory
$computers = Import-Csv -Path C:\temp\export\CompDescriptions.csv
foreach ($comp in $computers) 
{
      Set-ADComputer ($comp.Name) -Description ($comp.Description)
}

CSV with "Name" and "Description"

Thank you David,

I believe with a bit of tweaking I can make this work. Excellent.

David,

I can get this to work as long as my .csv file has only 1 entry. If more than 1 entry it will run the script with no errors but does not populate the description field in AD

This .csv works

Name,Description

Server1,Description of Server1

This .csv will not work

Name,Description

Server1,Description of Server1

Server2,Description of Server2

Can you help with this? 

David's script should work no matter how many entries you have in your input CSV, as it uses a loop.

Are you sure you're not just seeing a replication delay?

Mike

I tried waiting 15 mins but still no description field is populated. When I try it with only 1 line in the csv, I can see the field populated immediately. So not sure on this.

Thanks, Rod

I'd add a trace inside the loop for testing purposes:

Import-Csv .\computerDesc.csv | ForEach {

    Write-Host "Setting $($_.Name) description to $($_.Description)" -ForegroundColor Green
    Set-ADComputer $_.Name -Description $_.Description

}

Not sure how fast the replication happens in your environment - You can do a quick check using below code

Import-Csv .\computerDesc.csv | ForEach {

    Write-Host "Setting $($_.Name) description to $($_.Description)" -ForegroundColor Green
    Set-ADComputer $_.Name -Description $_.Description -Server "DC.Domain.com"

}

Possibly I have problems with my csv file?

Name,Description

Server1,description server1

Server2,description server2

Do you mind posting your entire script that worked for you?

Do you mind posting your entire script that worked for you?

I ran exactly what I posted above. My input was as such:

Name,Description
TESTCOMP1,Description for 1
TESTCOMP2,Description for 2