office 365 bulk password reset

[Mark182]

Not sure if I am missing something simple and sure I have done it before but I need to reset over 100 students E-mail passwords and I have the CSV with all their usernames but cannot seem to figure out the bulk password reset....

[FN-GM]

Use this spreadsheet. You input the data and the formula will spit out a list of commands. Copy all the commands and paste them into Powershell.

Password Reset Spreadsheet.xlsx

[Mark182]

Thanks

[EduTech]

:-) all you need to do is the following much easier

 

$x = Import-CSV -Path C:\Temp\Users.csv

$x | % {Set-MsolUserPassword -UserPrincipalName $_.UserPrincipalName -NewPassword "Password1" -ForceChangePassword $false}

 

*The column that has the UserPrincipalNames for each of the users in my case above had a header value of UserPrincipalName