🎉 Our Office 365 Reporting Tool is now available in Azure Marketplace 🚀
This website uses cookies to improve your experience. We'll assume you're ok with this. Know more.
Azure AD

How to Check Password Expiry Date in Microsoft 365

Has your Microsoft 365 account ever been locked out due to an expired password? This can be a frustrating experience, particularly when you are in the midst of handling high priority projects. No need to worry! We've crafted an easy guide on how to get the password expiry report and swiftly change passwords before expiry to avoid account lockouts.

Using Microsoft 365 admin center

Microsoft 365 Permission Required
Global Admin or Security Admin.
To find last password change date in Office 365:
  • Sign in to the Microsoft Entra admin center.
  • Go to the 'All Users' tab under Identity»Users.
  • Select the desired user and click on the 'Properties' tab.
  • In this tab, you can see the 'Last password change date time' of the user.
Using Microsoft 365 admin center

Microsoft 365 Permission Required
Global Admin or Security Admin.
To find domain password expiration policy:
  • Login to the Microsoft 365 admin center.
  • Navigate to 'Org settings' under 'Settings' in the left navigation pane.
  • Click 'Password expiration policy' under Security & privacy tab.
  • If your organization has a specific password policy, you can find the number of days configured in the policy.
  • Thus, there is no direct method available to find password expiry date for Microsoft 365 users. You need to manually calculate it using user’s last password change date and domain’ password policy.

Using PowerShell Script

Microsoft 365 Permission Required
Global Admin or Security Admin.
  • To simplify the difficulties in the native solution, we’ve crafted the unified script to check password expiration in PowerShell and export other Microsoft 365 password-related reports.
  • Download and run the following script in the Administrator PowerShell.
Using PowerShell Script
PasswordExpiryReport.ps1

Efficiently track password expiry date and policies with precise insights!

AdminDroid’s Microsoft 365 password reports offer a diverse range of details related to user passwords. This empowers you to obtain password expiration date of Microsoft 365 users, ensuring robust security and compliance in your organization.

Account Lockout Transparency

AdminDroid Microsoft 365 reporter provides transparency into account lockout events, empowering admins to respond swiftly to any unusual activities.

Unusual Password Resets Detection

Safeguard your organization user accounts by tracking Microsoft 365 self-service password resets and prevent the unauthorized usage of the user account.

Optimized Security Information

Elevate your Microsoft 365 security with AdminDroid's advanced security reporting, gaining insights to shield against potential threats.

User-Friendly Password Dashboard Oversight

Gain extensive insights into organization-wide password status breakdowns with AdminDroid's Microsoft 365 password dashboard. Take swift actions to improve password security measures.

Expired Password Sign-In Alerts

Receive prompt notifications when Microsoft 365 users sign-in with expired passwords and safeguard your organization against any potential threats.

Consistent Password Expiry Review

Implement periodic review and update the list of admins with never expire passwords to align with organization security policies.

In conclusion, AdminDroid simplifies the challenges of getting password expiration dates and other valuable Microsoft 365 password reports. With quick access to advanced password and security related reports, admins can stay proactive in fortifying security in their Microsoft 365 environment.

Explore a full range of reporting options

Important Tips

Ensure strong password security with Microsoft 365 smart lockouts to prevent brute force attacks and credential stuffing.

Admins should consider adding alternate email addresses to users. This helps to send password reset messages to those emails when the user's password expires.

Set up Entra ID password policies in Microsoft 365 for robust security. Prevent users from selecting weak or easily guessable passwords.

Common Errors and Resolution Steps

The following are possible errors and troubleshooting hints while getting Microsoft 365 users’ password expiration date:

Error Your password has expired. type your updated password and try again. You need to update your password because this is the first time you are signing in, or because your password has expired.

This error occurs when your account password expired due to password expiration policy of your organization.

Fix Set the new password to login to your Microsoft 365 account.

Error Update-MgUser : Insufficient privileges to complete the operation.

This error occurs when the user connects Graph PowerShell module without required permissions.

Fix Connect the Microsoft Graph module with global admin or security admin privileges.
Connect-MgGraph -Scopes "User.ReadWrite.All","Group.ReadWrite.All"

Error Get-MgBetaUser : The term 'Get-MgBetaUser' is not recognized as the name of a cmdlet, function, script file, or operable program. Check the spelling of the name, or if a path was included, verify that the path is correct and try again.

This error occurs when you run cmdlets without installing respective packages in PowerShell.

Fix Install the Micrsoft Graph beta package by using the below PowerShell cmdlet.
Install-Module Microsoft.Graph.Beta

Error You can’t reset your own password because the password reset isn’t properly set up for your organization.

This error occurs when users try to reset their password, when the self-service password reset is disabled in your organization.

Fix You must contact your administrator to reset your password and to check your organization’s setup.

Error Get-MgDomain : Resource 'onmicrosoft.com' does not exist or one of its queried reference-property objects are not present.

This error occurs when you enter an incorrect domain ID or incomplete domain ID like ‘onmicrosoft.com’.

Fix Enter complete domain name like ‘msft.onmicrosoft.com’ without any discrepancy.
Get-MgDomain -DomainID "<Domain name>" | select -Property Id, PasswordValidityPeriodInDays

Frequently Asked Questions

Monitor Password Expiration Date to Prevent Account Lockouts in Microsoft 365

Does Microsoft 365 password expire?

Does Microsoft 365 password expire? +

By default, passwords are set to never expire in all Microsoft 365 organizations. However, it is advisable to change passwords regularly to bypass account compromises.

If password expiration policy is configured with certain number of days, users' passwords will expire based on their individual last password change dates.

You can set the password expiration policy by following the steps below.

  • Login to the Microsoft 365 admin center.
  • Go to Settings»Org Settings tab.
  • Click on 'Password expiration policy' under the Security & privacy tab.
  • On the Password expiration policy page, uncheck the default checkbox to set password expiration policy in your organization.
  • Set the desired number of days (between 14 to 730) and click Save. This determines the password expiration duration.

Also, admins must note that Microsoft Entra ID has default password policies to ensure strong and complex passwords, when users reset their passwords. Admins cannot modify these default policies. However, they can ban custom passwords in Microsoft 365 to restrict users from using common passwords like company name, branch name, department name, etc.

AdminDroid's 'Password Policy' report makes it easy for admins to track the validity days configured using the password expiration policy.

  • This report provides password policies of multiple domains in your tenant with additional insights, including the number of policy-applied users, policy bypassed users, etc.
  • By utilizing the Download button, admins can effortlessly export the report in their preferred format to their local system.
password-policy-report

How to change the expired password in Microsoft 365?

How to change the expired password in Microsoft 365? +

An expired password may lead to an account lockout in Microsoft 365, and you cannot access your account.

Users can reset expired passwords and regain access to their account using the steps below:

  • Sign in to office.com using your work or school account.
  • Navigate to Settings»Password.
  • Enter your old password.
  • Create a new password and confirm it
  • Click Submit to complete the password change.

Note: Users can reset their own passwords using the above method only if your organization has enabled SSPR (Self Service Password Reset) for all users.

Admins can enable self-service password reset (SSPR) for users by following the steps below.

  • Sign in to Microsoft Entra admin center with a global admin account.
  • Navigate to 'Password Reset' under Protection.
  • Enable SSPR for 'Selected groups or All users' based on your requirements.
  • You can enable self-service password reset only for one Azure AD group in the Microsoft Entra admin portal.
password-reset

Also, it is essential to monitor the user’s password changes to ensure only the required user’s password is modified, preventing any unusual password changes and detect password spray attacks in your organization.

With AdminDroid's 'User Password Changes' report, you can keep an eye on user password changes when their passwords expire in your organization.

  • This report provides valuable details like password changed users and result status. It help the admins to ensure only necessary password changes occur within the organization.
user-password-changes

With AdminDroid Advanced Alerting, you can configure a threshold limit for password change activities and receive real-time notifications whenever unusual user password modifications occur in the organization.

How to set password expiration notification in Microsoft 365?

How to set password expiration notification in Microsoft 365? +

Setting up password expiration notifications in Microsoft 365 can prompt users to update their passwords before facing account lockouts.

Microsoft no longer supports password expiration notifications. Finding a workaround using the native solution is complicated and requires technical expertise. Also, it involves manual application addition, API permission assignment, certificate creation, client secret management, and script execution.

AdminDroid’s Quick schedule feature let admins to generate a weekly schedule, enabling them to effectively send password expiry notification to Microsoft 365 users.

  • Also, you can utilize AdminDroid's 'Soon To Password Expire Users' report that helps to find the list of all Microsoft 365 users whose passwords are about to expire soon.
  • It helps admins to prioritize these users for timely password expiry notifications.
soon-to-expire-password-report

This report includes user’s details such as UPN, Office 365 password expiration date, password expiration duration, last password change date, user sign-in status, license status, etc.

How to set never expire passwords in Office 365 for single user?

How to set never expire passwords in Office 365 for single user? +

Password expiration policy would be useful to improve the security of Microsoft 365 users’ accounts. However, organizations may need some crucial accounts with set passwords to never expire status.

You can set password to never expire in Microsoft 365 for single user using the below Graph PowerShell cmdlet:

Connect-MgGraph -Scopes "User.ReadWrite.All", "Group.ReadWrite.All"

Update-MgUser -UserId <user ID> -PasswordPolicies DisablePasswordExpiration

Also, it is equally important to monitor accounts with passwords set to never expire, ensuring the security of these crucial accounts.

You can get all the users with password set to never expire using the below PowerShell cmdlet:

Get-MgUser -All -Property UserPrincipalName, PasswordPolicies | Select-Object UserprincipalName,@{N="PasswordNeverExpires"; E={$_.PasswordPolicies -contains "DisablePasswordExpiration"}}

However, Graph PowerShell methods require a technical understanding to get in-depth details of the users’ password expiry statuses and users with never expire passwords.

With AdminDroid’s 'Passwords Never Expire Users' report, you can effectively verify that only the approved and privileged users are configured with never expired passwords.

  • This report provides extensive details like last password changed date, admin roles, user added time and helps you to ensure only required users are configured with password never expires.
password-never-expires-report

PRO TIP: You can directly email any of the reports in the required format from the report page itself, by clicking the mail icon (✉).

How to check user password expiry date in Microsoft 365?

How to check user password expiry date in Microsoft 365? +

Password expiry date in Microsoft 365 is not directly accessible since it depends on the number of days configured in the domain password policy. Also, the countdown to password expiration starts from the last time a user changed their password. Each user may have a different expiration date based on their individual password change history.

Therefore, to check the password expiration date in Office 365, manual calculation is required by comparing the days in the password expiration policy with the individual user's last password change date.

You can get password validity period of your organization’s password policy using the below PowerShell cmdlet.

Get-MgDomain -DomainID "<Domain name>" | select -Property Id, PasswordValidityPeriodInDays

You can find last password changed date in Office 365 using the Graph PowerShell cmdlet below.

Get-MgUser -All -Property DisplayName,lastPasswordChangeDateTime | select DisplayName,lastPasswordChangeDateTime

Additionally, you can check the leaked credential report in Microsoft Entra ID to validate the current security measures of user account passwords. It also helps you to identify and address any potential vulnerabilities or compromised credentials promptly.

Using the 'Users with Password Expiry' report, you can effortlessly find the accurate password expiration date of Microsoft 365 users without any manual calculation.

This report includes other necessary details such as the user’s last password changed date, password expiry status, etc.

users-with-password-expiry

PRO TIP: You can sort the report data in ascending or descending order by simply clicking the column heading. Here, you can click on 'Password Expiry Date' to arrange the data in ascending order to identify the users with earliest password expiration date.

+

Kickstart Your Journey With
AdminDroid

Your Microsoft 365 Companion with Enormous Reporting Capabilities

Download Now
User Help Manuals Compliance Docs
x
Delivering Reports on Time
Want a desired Microsoft 365 reports every Monday morning? Ensure automated report distribution and timely delivery with AdminDroid's Scheduling to your email anytime you need.
Delivering Reports on Time
Schedule tailored reports to execute automatically at the time you set and deliver straight to the emails you choose. In addition, you can customize report columns and add inteligent filtering to the activities just from the previous day to suit your Microsoft 365 report requirements.
Set It, Schedule It, See Results- Your Reports, Your Way, On Your Time!
Time Saving
Automation
Customization
Intelligent Filtering
Give Just the Right Access to the Right People
Grant fine-tuned access to any Microsoft 365 user with AdminDroid’s Granular Delegation and meet your organization’s security and compliance requirements.
Give Just the Right Access to the Right People
Create custom roles loaded with just the right permissions and give access to admins or normal users within AdminDroid. The result? A streamlined Microsoft 365 management experience that aligns your organization's security protocols and saves your invaluable time and effort.
Align, Define, Simplify: AdminDroid's Granular Delegation
Smart Organizational Control
Effortless M365 Management
Simplified Access
Advanced Alerts at a Glance
Receive quick notifications for malicious Microsoft 365 activities. Engage with the AdminDroid’s real-time alert policies crafted to streamline your security investigations.
Advanced Alerts at a Glance
Stay informed of critical activities like suspicious emails and high-risk logins, bulk file sharing, etc. Through creating and validating ideal alert policies, AdminDroid provides a comprehensive approach to real-time monitoring and management of potential threats within your organization.
AdminDroid Keeps You Always Vigilant, Never Vulnerable!
Proactive Protection
Real-time Monitoring
Security Intelligence
Threat Detection
Merge the Required Data to One Place
Combine multiple required columns into one comprehensive report and prioritize the information that matters most to you with AdminDroid’s Advanced Column Customization.
Merge the Required Data to One Place
This column merging capability offers a flexible way to add different columns from various reports and collate all the essential data in one place. Want to revisit the customized report? Save it as a 'View’, and your unique report is ready whenever you need it.
Merge with Ease and Save as Views!
Custom Reporting
Unique View
Desired Columns
Easy Data Interpretation
Insightful Charts and Exclusive Dashboards
Get a quick and easy overview of your tenant's activity, identify potential problems, and take action to protect your data with AdminDroid’s Charts and Dashboards.
Insightful Charts and Exclusive Dashboards
With AdminDroid charts and dashboards, visualize your Microsoft 365 tenant in ways you've never thought possible. It's not just about viewing; it's about understanding, controlling, and transforming your Microsoft 365 environment.
Explore Your Microsoft 365 Tenant in a Whole New Way!
Executive overviews
Interactive insights
Decision-making
Data Visualization
Efficient Report Exporting for Microsoft 365
Downloading your reports in the right file format shouldn’t be a hassle with AdminDroid’s Report Export. Experience seamless report exporting in various formats that cater to your needs.
Efficient Report Exporting for Microsoft 365
Navigate through diverse options and export Microsoft 365 reports flawlessly in your desired file format. Tailor your reports precisely as you need them and save them directly to your computer.
Take Control, Customize and Deliver- Your Office 365 Data, Exported in Your Way!
Easy Export
Seamless Downloading
Data Control
Manage Microsoft 365

Get AdminDroid Office 365 Reporter Now!