Windows – import list of pcs using import-Csv and change attribute using powershell script

active-directorycsvpowershellscriptingwindows

Im trying to write a powershell script to change attribute called "comment" in a list of pcs using csv and import-Csv.

Here is my script

$computers=Import-Csv -Path "C:\sds.csv" 
foreach ($item in $computers){ 
Set-ADComputer -identity $computers.DistinguishedName -add @{comment="bara"}
}

and hear is my csv file located under "C:\sds.csv"

But it jumps in to this ..

Tried googling and changing here and there, yet does not work! I have very little understanding of power-shell script, yet wish to learn. Can someone guide me please what im messing up ?

Best Answer

In your for, you must work on the current item and not from the computers collection. So you must change in your command computers by item :

Set-ADComputer -identity $item.DistinguishedName -add @{comment="bara"}

Related Solutions

Powershell script to create folders from CSV list of users

This should do the trick:-

# Read in List of Users
$ListofUsers=Get-Content "UserList.csv"
foreach ($User in $ListofUsers)
{
SetFolderPermission.ps1 -Path E:\TestFolder\$User
}

Powershell – Using PowerShell to create user accounts from a CSV

This answer assumes that you have a CSV with two columns that have the headings: username and password.

It doesn't take make other attributes, such as firstname, lastname, manager, department, etc. They can all be added and are outlined in the get-help new-aduser -full command.

This is the bare minimum that needs to be done to automate account creation. In production, you'll probably want to force password change on first logon as well as setting many other attributes.

Import-Module ActiveDirectory

Import-CSV c:\users\marra\desktop\userlist.csv | ForEach-Object {
    $name = $_.username                                               
    $pw = $_.password 
    $ss = ConvertTo-SecureString -string $pw -asPlainText -force        

    New-ADUser $name -SamAccountName $name -AccountPassword $ss -Path "OU=MyUserOU,DC=mydomain,dc=com" -Enabled $TRUE        
    }

Best Answer

Related Solutions

Powershell script to create folders from CSV list of users

Powershell – Using PowerShell to create user accounts from a CSV

Related Topic