Hi - trying to understand how I can add a field from User attributes (employeeID) to this but can’t seem to figure out the correct syntax. Here’s what I have:
Import-Module ActiveDirectory
Get-ADUser -filter {Enabled -eq $True -and PasswordNeverExpires -eq $False} –Properties SamAccountName,mail,DistinguishedName,pwdLastSet,msDS-UserPasswordExpiryTimeComputed,CanonicalName |
Select SamAccountName,mail,DistinguishedName,
@{L="OU";E={($_.CanonicalName -split '/')[0..((($_.CanonicalName -split '/').count) - 2)] -join '/'}},
@{L="Password Last Set"; E={[datetime]::FromFileTime($_."pwdLastSet")}},
@{L="Password Expiry Date";E={[datetime]::FromFileTime($_."msDS-UserPasswordExpiryTimeComputed")}} |
Export-CSV "C:\temp\PasswordExpirationReportv3.csv" -NoTypeInformation -Encoding UTF8