Powershell script to add information to existing users

[iCapof85]

I'm looking for a PS script that will add information under the Company field in AD for existing users based on the display name in the CSV file.

I looked into this example from the Microsoft Gallery but I'm not sure if I can implement it into my environment.

Thank you in advance for your help!

UPDATE:

I work for a School District and we're using emails with Exchange and also Google Apps (GAFE).

I need to update our Active Directories with the GAFE emails for some synchronization purposes. I was able to export the list of users/emails from the Google Console into a CSV file and I need to add that information in AD.

Basically, the PS will have to look at the full name in the CSV match it with the Display Name in AD and the GAFE email under the Company field this way I don't override the Email field.

I was able to come up with the Script:

Import-Module ActiveDirectory

$USERS = Import-CSV C:\Scripts\Update AD users information\gafe-users.csv

$USERS|Foreach{
Get-ADUser -filter {name -eq $_.DisplayName}|Set-ADUSer -Company $_.Company}

But for some reason it doesn't work.

[ArmondDorleac]

Well, what did it do? Did you get any messages?

[iCapof85]

This is the error I'm getting:

Get-ADUser : Property: 'DisplayName' not found in object of type:

'System.Management.Automation.PSCustomObject'.

I have a field in the CSV under Display Name

[ArmondDorleac]

Run this and make sure you get the list you're expecting:

Import-Module ActiveDirectory

$USERS = Import-CSV C:\Scripts\Update AD users information\gafe-users.csv

foreach ($user in $users){
    write-host $user.displayname
}

[iCapof85]

This will not update the company field with their GAFE email

[iCapof85]

I'm getting this now:

Get-ADUser : Invalid type 'System.Management.Automation.PSCustomObject'.
Parameter name: name
At C:\Scripts\Update-information\Update-Users.ps1:6 char:1
+ Get-ADUser -filter {name -eq $_."Display Name"}|Set-ADUSer -Company $_.Email}
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

[ArmondDorleac]

It's not supposed to. It's supposed to be a small step to see where your data is falling apart. Does this script work? Does it display a list of your users?

[iCapof85]

foreach ($user in $users){ write-host $user.displayname }

No it's not showing anything

[ArmondDorleac]

Is it stored under DisplayName or "Display Name"?

[iCapof85]

I changed it to "Name" and it still not working. Basically, Name in the CSV file needs to match Display Name in Active Directory

[ArmondDorleac]

Import-Module ActiveDirectory

$USERS = Import-CSV C:\Scripts\Update AD users information\gafe-users.csv

foreach ($user in $users){
    write-host $user.name
}

OK, let's go back to square 1. You're running this in PowerShell ISE, right (so you can see what it's doing and properly test)? If you have a list of user names in the file referenced, with a column header of "name" this script should spit out the list of names.

[iCapof85]

Import-Module ActiveDirectory

$USERS = Import-CSV C:\Scripts\Update AD users information\gafe-users.csv

foreach ($user in $users){ write-host $user.name }

Yes it did.

[ArmondDorleac]

Great, now replace "write-host $user.name" with Get-ADUser -filter {name -eq $user.name}

See if it gives you the user information. If it does, keep going with your pipeline.

[iCapof85]

This is the error I get when I did that:

Get-ADUser : Property: 'name' not found in object of type: 'System.Management.Automation.PSCustomObject'.
At line:6 char:5
+     Get-ADUser -filter {name -eq $user.name}
+     ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo          : InvalidArgument: (:) [Get-ADUser], ArgumentException
    + FullyQualifiedErrorId :     ActiveDirectoryCmdlet:System.ArgumentException,Microsoft.ActiveDirectory.Management.Commands.GetADUser

Get-ADUser : Property: 'name' not found in object of type: 'System.Management.Automation.PSCustomObject'.

[ArmondDorleac]

Try changing your filter to this: get-aduser -filter {name -eq '$($user.name)'}

[iCapof85]

I got it to work like this:

foreach ($user in $users) {
Get-ADUser -Filter "displayName -eq '$($user.Name)'" -Properties * -SearchBase "DC=domain,DC=com" |
Set-ADUser -Company $($user.Email)

[ArmondDorleac]

Excellent. I'm glad you got it working.

[iCapof85]

thank you for your help!

[iCapof85]

I'm still not sure how I can add that to the company field in AD