In this guide, I’ll show you how to get the password expiration date for Active Directory User Accounts.
This is very easy to do.
I will provide a few examples that go over how to get this information for a single user and how to get the expiration date for all AD users.
Check it out.
Method 1: Using Net User command to Display User Expiration Date
This first method uses the net user command that is built into windows. This command is used to add, remove and make changes to user and computer accounts.
To determine when the password will expire for a single account open the command prompt and type the following command:
Net user USERNAME /domain
In the below screenshot is an example for the user mfoster.
In addition to displaying the password expires date it also provides other useful information such as password last set, when the password can be changed, if the account is active and so on.
That is it for method 1.
Method 2: Using PowerShell To List All Users Password Expiration Date
To query user information with PowerShell you will need to have the AD module installed. If you have the RSAT tools loaded then you are good to go.
To find the date the password was last set, run this command.
get-aduser -filter * -properties passwordlastset, passwordneverexpires |ft Name, passwordlastset, Passwordneverexpires
In the screenshot below you can see it returns all users, password last set date and if the password never expires.
To display the expiration date rather than the password last set date, use this command.
Get-ADUser -filter {Enabled -eq $True -and PasswordNeverExpires -eq $False} –Properties "DisplayName", "msDS-UserPasswordExpiryTimeComputed" |
Select-Object -Property "Displayname",@{Name="ExpiryDate";Expression={[datetime]::FromFileTime($_."msDS-UserPasswordExpiryTimeComputed")}}
Above command https://blogs.technet.microsoft.com/poshchap/2014/02/21/one-liner-get-a-list-of-ad-users-password-expiry-dates/and source:
To export any of the PowerShell results to a CSV just add | export-csv FILEPATH to the end.
I told you this was going to be easy. The PowerShell commands you can literally copy and past and they should work in your environment. The Net User command just requires you to enter in an AD user account to query.
Method 3: Using the Active Directory Pro Toolkit
The AD Pro Toolkit includes several Active Directory Tools for reporting and exporting user accounts.
The toolkit has the following benefits:
- Select users from a group
- Select users from an OU
- Easily add or remove user attributes
- Export to a CSV file
- Sort and search the results
In this example, I’ll use the export tool to list all user’s password last set date, and include some other attributes like lastlogon, whenChanged, and when created.
The attribute selector makes it very easy to add and remove user attributes to the report.
After running the tool I get a list of users and additional data from Active Directory if it exists.
Next, you can filter on any column or use the export button to export to a CSV file.
You can try the AD User Export Tool in your domain by downloading a free trial.
Related Posts:
So I have a separate OU users in a different user that I want to see when there password expires.
Were would I make the change for this with in a domain tree?
How do I get the expiration date for few users that I have in a csv format using method 2? I know the command mentioned in here will give me the list of all the users in my org.
The second method is more accurate if you have Fine-grained Password Policies enabled in the domain.
Net Use only shows the result from the Default Domain Policy.
Good Tip. Thanks for the comment.
Found your “Method two” very useful, thanks for publishing!
Awesome ❗ ❗
Nice tips! 🙂
How to get especially service account password expire date.
EXCELLENT = Do you know how to filter by a date ?
say passwordlastset > today-2
Add
Sort-Object -property ExpiryDate
$dayb4yesterday = (get-date).AddDays(-2)
get-aduser -filter {passwordlastset -gt $dayb4yesterday}
Is there a field like Enabled that we can use to filter out this where this isn’t set for the user that shows up “12/31/1600 7:00:00 PM”.
Yes use the below code to return just the enabled users
get-aduser -filter {Enabled -eq $TRUE} -properties passwordlastset, passwordneverexpires |ft Name, passwordlastset, Passwordneverexpires
Grazie!
Hi, how do I query if the password change was successful through powershell?
thanks for this site by the way, it helped guide me quite alot! 🙂
Something useful from Method 1:
$m=’Password expires’;($MyExp = net user $env:USERNAME /domain | %{if($_ -match $m){get-date ($_ -replace $m,”).trim()}});rv m;
Great! It was really helpfull!!
Nice set of commands/scripts, very helpful!
Thank Jim
Timely help! Many thanks.
If there are multiple OU’s and you want to find the expiring passwords for a specific OU, how would you do that? I’m guessing with ‘-searhbase’, but not sure how. – Thanks
how about specifying the user name in your step 2 query?
Here is an example for a specific user
get-aduser -Identity Alonso.Hall -properties passwordlastset, passwordneverexpires |ft Name, passwordlastset, Passwordneverexpires
Nice trick but how about to get user properties from different domain?
Use the -server to specify the domain server instance
Get-ADUser -Filter “Name -eq ‘ChewDavid'” -SearchBase “DC=AppNC” -Properties “mail” -Server lds.Fabrikam.com
Method #1 is great. Thanks!!
Hi
I need Only OU level
You can target an OU by using the -searchbase and the DN of the OU.
Get-ADUser -Filter * -SearchBase "OU=Finance,OU=UserAccounts,DC=FABRIKAM,DC=COM"Hey robert should I put this command in the line with getaduser after the filter parameters?
Hi Lucas,
I’m not sure what you are asking.
He was just trying to ask you if the command was all on one line. 🙂
I seem to be having an issue using the -searchbase in the Method-2 above. I keep getting a message ” A parameter cannot be found that matches parameter name ‘SearchBase’. ” Is this possibly a location issue where I am not putting it in the correct location within the Method-2 command?
In method 2, is there a way to get the expiring users in the next seven days?
I am looking for a way to do this as well. I am trying to compile a list of users and when their passwords will expire.
Can you do this without using Get-ADUser?
I am using the following commandlet to get the list of last password set and then using a variable to get the value and add -365 to it, however this variable is not getting populated.
I can see the commandlet work and output values but the variable I am using $PWdLastSet.passwordlastset is not getting any value, am I doing something wrong ?
$PWdLastSet = get-aduser -filter * -properties passwordlastset, passwordneverexpires -SearchBase “OU=Service Accounts,OU=SG1,OU=AT,DC=wt,DC=ad,DC=cit,DC=cc” |ft Name, passwordlastset, Passwordneverexpires
$expiredDate = $PWdLastSet.passwordlastset.addDays(-365)
Can you specify a specific user?
Yes. just use -identity USERNAME. Here is an example
get-aduser -identity robert.allen -properties passwordlastset, passwordneverexpires | select Name, passwordlastset, Passwordneverexpires
Get-ADUser Ryan
Thanks for sharing this, its helpful.
Is it possible to trim the expiration date..? Just want the date, without time. if so, can you please help with that..?
Thanks for sharing this stuff. I have one question
The expiry time it shows, in which time zone is it, central time ? or the time zone set on the server ?
It’s pulling the time value from the user account on the server.
Thanks for sharing 🙂
Do you know how can i extend the password expiration date by 6 months for all users on AD ?
You would need to update the group policy that has your password policy. See this article -> https://activedirectorypro.com/how-to-configure-a-domain-password-policy/
I’m still having trouble getting it to sort by date. It’ll sort alphabetically when I do a sort-object, but expiry just puts them in a random order each time, even though the command runs. Any suggestions?
How do you get it to export? It keeps asking for inputobject in method 2 after adding Export-Csv -Path
Is there a way to display the date in chronological order? I’m getting the expiration date report but not in order by date. Thank you in advance.
Yes. Use the sort-object cmdlet.
get-aduser -filter * -properties passwordlastset, passwordneverexpires | sort-object passwordlastset
Hi!
How Can I get the Logon Name if I only have the display name?
Thank you in advance.
You can find the logon name in Active Directory Users and Computers.
Nice, trying to filter on “ExpiryDate” but can’t get that work.
usecase: I want to generate a file of users which have a password experation 5, 4, 3, 2 or 1 day from now.
It’s a nice script, but we have so many users that I like to do the following:
-Filter to only show users with password expriring within 7 days from today (we have fine-grained password policies)
-Output as JSON (on console)
For me, that is quite hard to do, for you guys not I guess, can you show me how ?
How is it possible to check expiracy for group of users. So instead of either all or just 1 user – i would like to check like user1, user 2 and user 3 – instead of have check one at a time
İt worked for me Thank you for your work
Hi Robert,
I want to reset passwordlast set date for a list of users. Any idea how I can achieve this?
Thanks!
I don’t think that is possible.