Powershell Update Active Directory Users Based on Delimited File

Question

If I have two rows in a CSV file like below (but 200 entries or so).

$Username        $Phone
Example.A        911
Example.B        123

How would I get PowerShell to take each row and enter it into a command?

I know how to do it if the phonenumber (Using a for each loop) is the same for everyone, but if everyone has a different phonenumber, how would I go about it then? Can I use a for each loop fetching two rows instead of 1 row from the csv file?

Foreach $Username, $Phonenumber in $CSV
Set-ADuser -identity $Username -PhoneNumber $Phonenumber

Above is how I would like it to be, but that doesn't work.

morgb · Accepted Answer · 2016-07-06 15:14:40Z

1

To do what you're attempting, you just need a couple of slight modifications as follows:

$CSV = Import-Csv -Delimiter "," -Path "\\your\file\path" 
foreach ($user in $CSV) {
    Set-ADuser -identity $user.Username -PhoneNumber $user.Phonenumber
}

answered Jul 6, 2016 at 15:14

morgb

2,3322 gold badges14 silver badges14 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Jakodns Over a year ago

Thanks, exactly what I was looking for.

Collectives™ on Stack Overflow

Powershell Update Active Directory Users Based on Delimited File

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related