AD Computer mail and description attributes bulk update using csv file

Question

AD Computer mail and description attributes bulk update using csv file

thanks in advance

Chetan

Answer 1

Hello @Chetan Gawali

I believe you are looking for this:

# Import the CSV file containing the computer name, email, and description columns
$computers = Import-Csv -Path "C:\path\to\computers.csv"

# Loop through each computer in the CSV file
foreach ($computer in $computers) {

  # Get the AD computer object by the computer name
  $adComputer = Get-ADComputer -Identity $computer.Name
  
  # Update the email and description attributes
  Set-ADComputer -Identity $adComputer -EmailAddress $computer.Email -Description $computer.Description
  
  # Output the updated computer name, email, and description
  Write-Host "Updated $($adComputer.Name) with email $($computer.Email) and description $($computer.Description)"
  
}

Ensure the CSV have: Name, Email, and Description columns

I hope this help you.

Regards

Answer 2

The AD Computer object type doesn't have an "emailaddress" property. You can set the "description" and put an email object into the description property. Or you can set the computers "ManagedBy" property to an individual user or, perhaps, to a distribution list.