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