How to create a report of when passwords have expired using Quest’s AD cmdlets
To create a report of when user account’s passwords have expired with Quest’s AD cmdlets, use the following command. By sorting by ParentContainer, the output should be grouped by Organizational Units.
Get-QADUser -SizeLimit 5000 | Select LogonName, ParentContainer, LastLogon, PasswordLastSet, PasswordExpires | Sort ParentContainer, PasswordExpires | Export-CSV report.csv