Forum Discussion

SarbjitSinghGill's avatar
SarbjitSinghGill
Copper Contributor
Apr 26, 2020

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

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

  • 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.

  • SarbjitSinghGill 

     

    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?

    • SarbjitSinghGill's avatar
      SarbjitSinghGill
      Copper Contributor

      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

Resources