Password about to expire

[AM13337]

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?

[Bruce_B · Accepted solution]

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.