1. Set Password never expired
Set Password never expired for Office 365 user
PowerShell command Syntax
- PowerShell
Set-msoluser –UserPrincipalName <UserPrincipalName> -PasswordNeverExpires $True
PowerShell command Example
- PowerShell
Set-MsolUser –UserPrincipalName John@o365info.com -PasswordNeverExpires $True
Disable Password never expired option for a Office 365 user
PowerShell command Syntax
- PowerShell
Set-MsolUser –UserPrincipalName <UserPrincipalName> -PasswordNeverExpires $False
PowerShell command Example
- PowerShell
Set-MsolUser -UserPrincipalName John@o365info.com -PasswordNeverExpires $False
Set Password never expired for ALL Office 365 users (Bulk Mode)
PowerShell command Syntax
- PowerShell
Get-MsolUser | Set-MsolUser –PasswordNeverExpires $True
Re-enable Password expired ( the default) for ALL Office 365 users (Bulk Mode)
PowerShell command Syntax
- PowerShell
Get-MsolUser | Set-MsolUser –PasswordNeverExpires $False
2. Set Password
Set a Predefined Password for Office 365 user
PowerShell command Syntax
- PowerShell
Set-MsolUserPassword –UserPrincipalName <UserPrincipalName> –NewPassword <New Password> -ForceChangePassword $False
PowerShell command Example
- PowerShell
Set-MsolUserPassword -UserPrincipalName John@o365info.com -NewPassword ww#322x -ForceChangePassword $False
Set a Predefined Password for all Office 365 users (Bulk mode)
PowerShell command Syntax
- PowerShell
Get-MsolUser |%{Set-MsolUserPassword -userPrincipalName $_.UserPrincipalName –NewPassword <password> -ForceChangePassword $False}
PowerShell command Example
- PowerShell
Get-MsolUser |%{Set-MsolUserPassword -userPrincipalName $_.UserPrincipalName –NewPassword Abc#45 -ForceChangePassword $False}
Set a Predefined Password for Office 365 users imported from a CSV File
Step 1: Export Office 365 users account
PowerShell command Syntax
- PowerShell
Get-MsolUser | Select UserPrincipalName| Export-CSV
Step 2:
Set a Predefined Password
- PowerShell
Import-CSV |%{Set-MsolUserPassword -userPrincipalName $_.UserPrincipalName –NewPassword <Password> -ForceChangePassword $False}
Example: Step 1: Export Office 365 users account
Predefined Password-CSV
PowerShell command Example
- PowerShell
Get-MsolUser | Select UserPrincipalName|Export-CSV C:\Temp\o365users.csv
PowerShell
Import-CSV C:\Temp\o365users.csv |%{Set-MsolUserPassword -userPrincipalName $_.UserPrincipalName –NewPassword AbcAs123 -ForceChangePassword $False}
Create new Office 365 user and set a unique temporary password by import the information from CSV file
temp password
You can download a sample CSV file – Password.csv
PowerShell command Example
- PowerShell
Import-CSV –Path C:\Temp\users.csv| ForEach-Object { New-MsolUser -UserPrincipalName $_.UserPrincipalName -FirstName $_.FirstName -LastName $_.LastName -DisplayName "$($_.FirstName) $($_.LastName)" –Password $_.Password –UsageLocation “US” }
Provisioning Office 365 user and export information from Active Directory
In case that you need to export Active Directory on-Premise user account based on a specific parameter, you can use the PowerShell cmdlets named – get-aduser (you will need to use PowerShell console from DC or import the Active Directory cmdlets to the existing PowerShell console
For example:
Example 1 – display or export, all of the Active Directory users that are located in a specific OU.
In our specific scenario, the domain name is – o365info.com and the specific OU is – Test
Display information about – all of the Active Directory users that are located in a specific OU
PowerShell command Example
- PowerShell
Get-ADUser -LDAPfilter '(name=*)' -searchBase {OU=test,DC=o365info,dc=local}
Export to a CSV file information about – all of the Active Directory users that are located in a specific OU + choose a specific data fields.
- PowerShell
$usersfromOU = Get-ADUser -LDAPfilter '(name=*)' -searchBase {OU=test,DC=o365info,dc=local}
$usersfromOU | export-csv C:\usersbyOU.csv
Example 2 – display + export information about Active Directory users from a specific department.
The PowerShell command syntax is:
- PowerShell
$Users = Get-AdUser -filter "department -eq '<name>'"
An example to a scenario in which we want to export information only about Active Directory users that belong to the marketing department could be
- PowerShell
$aduserdep = Get-AdUser -filter "department -eq 'marketing'" -Properties City,Title,Department,GivenName,Surname
- PowerShell
$aduserdep | export-csv c:\aduserdep.csv
Set a Temporary Password for a specific user
PowerShell command Syntax
- PowerShell
Set-MsolUserPassword –UserPrincipalName <UserPrincipalName> –NewPassword <New Password>-ForceChangePassword $True
PowerShell command Example
- PowerShell
Set-MsolUserPassword -UserPrincipalName John@o365info.com -NewPassword ww@322x -ForceChangePassword $True
Set a Temporary Password for all Office 365 users (Bulk Mode)
PowerShell command Syntax
- PowerShell
Get-MsolUser | Set-MsolUserPassword –NewPassword <New Password> -ForceChangePassword $False
PowerShell command Example
- PowerShell
Get-MsolUser | Set-MsolUserPassword -NewPassword ww#322x -ForceChangePassword $False
3. Office 365 Password Policy
PowerShell command Syntax
- PowerShell
Set-MsolPasswordPolicy -DomainName <Domain Name> -NotificationDays <Number Of Days> –ValidityPeriod <Number Of Days>
PowerShell command Example
- PowerShell
Set-MsolPasswordPolicy -DomainName o365info.com -NotificationDays 15 -ValidityPeriod 180
4. Display Password settings
Display Password settings for all Office 365 users
PowerShell command Syntax
- PowerShell
Get-MsolUser | Select UserPrincipalName,PasswordNeverExpires
Display information about Office 365 Password Policy
PowerShell command Syntax
- PowerShell
Get-MsolPasswordPolicy –DomainName <Domain Name>
PowerShell command Example
- PowerShell
Get-MsolPasswordPolicy –DomainName o365info.com
