Category: Tech Notes
Powershell export to pivot table
Export from powershell to generate a pivot table in excel. https://blogs.technet.microsoft.com/heyscriptingguy/2015/11/25/introducing-the-powershell-excel-module-2/
Powershell get password statistics
Get password stats and export to csv Import-Module activedirectoryGet-ADUser -filter * -properties PasswordExpired, PasswordLastSet, PasswordNeverExpires | ft Name, PasswordExpired, PasswordLastSet, PasswordNeverExpires | Export-csv -path c:\tmp\users.csv