→ Celebrate SysAdmin Day 2024 with Lansweeper Enter our Giveaway here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
AM13337
Engaged Sweeper III
I have a powershell cmdlet that will show me all the users who are enabled and don't have the password never expires option checked and when their passwords will expire.

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”)}} | Sort-Object -Descending expirydate

Is there any way to have a report in lansweeper do this?
1 ACCEPTED SOLUTION
Bruce_B
Lansweeper Alumni
All AD user information that is scanned by Lansweeper can be found in the table tblADUsers. Unfortunately password expiration date and whether the account's password is set up to expire or not is not among this information. Our customers have asked for this information in the past, and this is already on our customer wishlist.

If you're using SQL Server it's theoretically possible to report on this using Openquery, though we can't provide support in setting this up unfortunately.

View solution in original post

1 REPLY 1
Bruce_B
Lansweeper Alumni
All AD user information that is scanned by Lansweeper can be found in the table tblADUsers. Unfortunately password expiration date and whether the account's password is set up to expire or not is not among this information. Our customers have asked for this information in the past, and this is already on our customer wishlist.

If you're using SQL Server it's theoretically possible to report on this using Openquery, though we can't provide support in setting this up unfortunately.