AD Bulk users of description with account name form CSV Import

Question

I want to be able to add/update the description attribute in AD from a CSV import, the CSV will have two columns: sAMAccountName and description, so I want the script to be able to search using the user account and then add the corresponding description. I have no scripting skills and I only have the script below starting point, can anyone help and see where I went wrong.

Import-Csv "C:\tmp\users.csv" | foreach {Set-ADUser - Identity = $_.sAMAccountName –description $_.description}

Thank you in advance.

Answer 1

Strange I don't have any error regarding the filter on my side :(
Anyway you can try it like that :

$CSV = Import-Csv -Path Example_csv.csv -Delimiter ";"
 foreach($line in $CSV) {
     $ADUser = Get-ADUser -identity $line.sAMAccountName
     if($ADUser -ne $null) {
         Set-ADUser $ADUser -Description $line.Description
     }
 }

Answer 2

Hello,

You have an issue in your because the identity parameter will expect something like :

• A distinguished name
• A GUID (objectGUID)
• A security identifier (objectSid)
• A SAM account name (sAMAccountName)

And you are giving this parameter something that does not look like what it is expecting.
Below you will find an example of what you can do to update the description :

$CSV = Import-Csv -Path Example_csv.csv -Delimiter ";"
foreach($line in $CSV) {
    $ADUser = Get-ADUser -Filter "sAMAccountName -like '$($line.sAMAccountName)'"
    if($ADUser -ne $null) {
        Set-ADUser $ADUser -Description $line.Description
    }
}

Regards,