Is it possible to make mass changes for users in Azure AD?

Question

Is it possible to make mass changes for users in Azure AD?

5even 56

I just want to update the global addresses for at least 40 users from the same location. Its possible to change the address for every single user, when I click on it, but it could be easier, when its possible to do mass changes with one strike.

can someone help out?

best regards

5even

JH 26 Reputation points

2021-12-22T01:06:18.093+00:00
Yes, it is possible with a powershell command if you have a common attribute or group for all of those users. For example, I have a hypothetical existing Office365 group called "Ohio Users" consisting of users located in Ohio. All of those users are employees of a company called "Supplied Logistics". In powershell, I will enter the following command to connect to AzureAD:

Connect-AzureAD

Then get the users of "Ohio Users" using Get-AzureADGroupMember and change the "Company" attribute for all of those users using Set-AzureADUser.

foreach ($person in $(Get-AzureADGroupMember -ObjectId "OBJECTID_OF_OHIO_USERS_GROUP")){ Set-AzureADUser -ObjectId $person.ObjectId -Company "Supplied Logistics"}

Of course, this only works if all of your targeted users have a shared attribute, group, etc. This may be useful if you have a group of users that have the "City" attribute set but not the "State". In that case, to find the group of users you would replace

Get-AzureADGroupMember -ObjectId "OBJECTID_OF_OHIO_USERS_GROUP"

With something like

Get-AzureADUser -Filter "startswith(City,'Cleveland')"

1 answer

Your answer

JH 26 Reputation points

2021-12-22T01:06:18.093+00:00

Yes, it is possible with a powershell command if you have a common attribute or group for all of those users. For example, I have a hypothetical existing Office365 group called "Ohio Users" consisting of users located in Ohio. All of those users are employees of a company called "Supplied Logistics". In powershell, I will enter the following command to connect to AzureAD:

Connect-AzureAD

Then get the users of "Ohio Users" using Get-AzureADGroupMember and change the "Company" attribute for all of those users using Set-AzureADUser.

foreach ($person in $(Get-AzureADGroupMember -ObjectId "OBJECTID_OF_OHIO_USERS_GROUP")){ Set-AzureADUser -ObjectId $person.ObjectId -Company "Supplied Logistics"}

Of course, this only works if all of your targeted users have a shared attribute, group, etc. This may be useful if you have a group of users that have the "City" attribute set but not the "State". In that case, to find the group of users you would replace

Get-AzureADGroupMember -ObjectId "OBJECTID_OF_OHIO_USERS_GROUP"

With something like

Get-AzureADUser -Filter "startswith(City,'Cleveland')"

Answer 1

T. Kujala 8,766

Hi @5even-5983,

You have the following bulk management tasks available in the Azure AD portal.

Bulk create
Bulk invite
Bulk delete
Download users

https://techcommunity.microsoft.com/t5/azure-active-directory-identity/new-capability-simplifies-bulk-management-for-users-and-groups/ba-p/894002

You can also use the PowerShell commands to edit multiple objects.

For example.

PS C:\> Get-AzureADUser -SearchString "Test" | Set-AzureADUser -StreedAddress Street

https://learn.microsoft.com/en-us/powershell/module/azuread/set-azureaduser?view=azureadps-2.0

5even 56 Reputation points

2020-07-03T13:47:11.553+00:00

I just did "Download users" and I can copy paste the global address for each person. Now I want the changes to be added in Azure AD. How can I do that?
Because Bulk create, invite and delete doesn't seem like the correct choice for me.

bg

5even
T. Kujala 8,766 Reputation points

2020-07-03T17:16:29.083+00:00

Could you tell what attribute you actually mean?

Then I can help you better.
5even 56 Reputation points

2020-07-06T08:00:54.28+00:00

ye as mentioned in the beginning the address attributes.

sorry for my late reply

Share via

Is it possible to make mass changes for users in Azure AD?

1 answer

Your answer