School user passwords

Question

I have 400 users aged as minors. I want to set passwords for them to use. I do not want to have the reset password at first login. How can I do this?

Answer 1

Hi Chris,

The best way is to script this by PowerShell:

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

What I would do is export a csv of all of these accounts and use PowerShell to create a for loop to go through and reset the passwords.

If this is helpful please accept answer.

Answer 2

@Chris Bonser

Thank you for posting this in Microsoft Q&A.

To do bulk password reset, you need to create a CSV file. In the CSV you need to create the following columns:

-UserprincipalName: Email of the user whose password you want to reset

-NewPassword: New password you want to set for the user

Now you can use any of the below scripts to achieve your task,

$users = get-msoluser | select userprincipalname,objectid | where {-userprincipalname -like $_.UserPrincipalName }

Set-MsolUserPassword -userPrincipalName $.UserPrincipalName -NewPassword $.Password -ForceChangePassword $False }

Or you can use below script,

Import-Csv "C:\Users.csv" | % { Set-MsolUserPassword -userPrincipalName "$.UserPrincipalName" -NewPassword "$.Password" -ForceChangePassword $False

Let me know if you have any further questions on this.

Please "Accept the answer" if the information helped you. This will help us and others in the community as well.