PowerShell script to make bulk changes to user attributes in a GAL

%3CLINGO-SUB%20id%3D%22lingo-sub-1339071%22%20slang%3D%22en-US%22%3EPowerShell%20script%20to%20make%20bulk%20changes%20to%20user%20attributes%20in%20a%20GAL%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1339071%22%20slang%3D%22en-US%22%3E%3CP%3EGreetings%2C%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWe%20have%202%20GAL%E2%80%99s%20and%20I%20need%20a%20script%20to%20populate%20the%20Organization%20field%20with%20Student.%20It%20is%20simpler%20too%20time%20consuming%20to%20do%20this%20manually%20via%20edit%20function.%20Until%20recently%20you%20could%20select%20multiple%20students%20and%20make%20the%20change%20but%20now%20its%20one%20by%20one.%20So%20I%20need%20a%20PowerShell%20script%20to%20help%20automate%20this.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20You%26nbsp%3B%3C%2FP%3E%3CP%3ESarbjit%20Singh%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1339071%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMicrosoft%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1339118%22%20slang%3D%22en-US%22%3ERe%3A%20PowerShell%20script%20to%20make%20bulk%20changes%20to%20user%20attributes%20in%20a%20GAL%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1339118%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F7962%22%20target%3D%22_blank%22%3E%40Sarbjit%20Singh%20Gill%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%2C%20couple%20of%20questions%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20can%20you%20just%20confirm%20which%20field%20you%20are%20referring%20to%3F%20%26nbsp%3BPerhaps%20a%20screenshot%20if%20you%20could%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAlso%2C%20are%20you%20making%20this%20change%20directly%20from%20the%20Office%20365%20Admin%20Center%2C%20or%20are%20you%20synchronising%20your%20on-premises%20Active%20Directory%20to%20O365%20with%20Azure%20AD%20Connect%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1340986%22%20slang%3D%22en-US%22%3ERe%3A%20PowerShell%20script%20to%20make%20bulk%20changes%20to%20user%20attributes%20in%20a%20GAL%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1340986%22%20slang%3D%22en-US%22%3E%3CP%3EYou%20should%20still%20be%20able%20to%20use%20the%20Exchange%20Admin%20Center%20to%20make%20bulk%20changes%2C%20so%20just%20do%20it%20from%20there.%20Or%20use%20Set-User%2FSet-Mailbox%20as%20necessary.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1341041%22%20slang%3D%22en-US%22%3ERe%3A%20PowerShell%20script%20to%20make%20bulk%20changes%20to%20user%20attributes%20in%20a%20GAL%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1341041%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F616707%22%20target%3D%22_blank%22%3E%40PeterRising%3C%2FA%3E%26nbsp%3BThe%20field%20is%20%22company%20%2F%20organization%22.%26nbsp%3B%3C%2FP%3E%3CP%3EThere%20is%20no%20sync%20with%20on-prem%20AD.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20figured%20I%20could%20down%20load%20all%20the%20attributes%20to%20a%20.csv%20file%20using%20a%20PowerShell%20command.%20Amend%20the%20csv%20for%20the%20attributes%20on%20company%20%2F%20organist%20ion%20and%20push%20it%20back%20up%20using%20PowerShell.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERegards%3C%2FP%3E%3CP%3ESS%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1341049%22%20slang%3D%22en-US%22%3ERe%3A%20PowerShell%20script%20to%20make%20bulk%20changes%20to%20user%20attributes%20in%20a%20GAL%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1341049%22%20slang%3D%22en-US%22%3E%3CP%3EThank%20You%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F58%22%20target%3D%22_blank%22%3E%40Vasil%20Michev%3C%2FA%3E%3C%2FP%3E%3CP%3EYes%20i%20can%20see%20i%20can%20make%20bulk%20changes.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20would%20work.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESS%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1341054%22%20slang%3D%22en-US%22%3ERe%3A%20PowerShell%20script%20to%20make%20bulk%20changes%20to%20user%20attributes%20in%20a%20GAL%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1341054%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F7962%22%20target%3D%22_blank%22%3E%40Sarbjit%20Singh%20Gill%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESo%20it%20looks%20like%20the%20issue%20you%20had%20is%20now%20resolved%2C%20as%20you%20can%20make%20%26nbsp%3Bbulk%20changes%20in%20the%20admin%20center%20again%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Contributor

Greetings, 

 

We have 2 GAL’s and I need a script to populate the Organization field with Student. It is simpler too time consuming to do this manually via edit function. Until recently you could select multiple students and make the change but now its one by one. So I need a PowerShell script to help automate this. 

 

 

Thank You 

Sarbjit Singh 

5 Replies
Highlighted

@Sarbjit Singh Gill 

 

Hi, couple of questions;

 

Please can you just confirm which field you are referring to?  Perhaps a screenshot if you could?

 

Also, are you making this change directly from the Office 365 Admin Center, or are you synchronising your on-premises Active Directory to O365 with Azure AD Connect?

Highlighted

You should still be able to use the Exchange Admin Center to make bulk changes, so just do it from there. Or use Set-User/Set-Mailbox as necessary.

Highlighted

@PeterRising The field is "company / organization". 

There is no sync with on-prem AD. 

 

I figured I could down load all the attributes to a .csv file using a PowerShell command. Amend the csv for the attributes on company / organist ion and push it back up using PowerShell.  

 

Regards

SS

Highlighted

Thank You @Vasil Michev

Yes i can see i can make bulk changes.  

This would work. 

 

SS

Highlighted

@Sarbjit Singh Gill 

 

So it looks like the issue you had is now resolved, as you can make  bulk changes in the admin center again?