The following command exports user attributes to a CSV file:
Exported user attributes are:
- sAMAccountName
- displayName
- distinguishedName
- employeeID
- accountExpires
- whenCreated
- whenChanged
- pwdLastSet
- Password Never Expire
- Account disabled
- lastLogonTimestamp
- lastLogon
Get-ADUser -Filter * -SearchBase "DC=fr,DC=contoso,DC=com" -Properties displayName,distinguishedName,sAMAccountName,employeeID,accountExpires, whenCreated,whenChanged,pwdLastSet,userAccountControl,lastLogonTimestamp,lastLogon -Server FR-DC1| Select-Object -Property sAMAccountName,displayName, distinguishedName,employeeID, @{N='accountExpires';E={[DATETIME]::fromFileTime($_.accountExpires)}}, whenCreated,whenChanged, @{n='pwdLastSet';e={[DateTime]::FromFileTime($_.pwdLastSet)}}, @{n="Password Never Expire";e={if(($_.userAccountControl[0] -band 65536) -ne 0) {"True"} else {"False"}}}, @{n="Account disabled";e={if(($_.userAccountControl[0] -band 2) -ne 0) {"True"} else {"False"}}}, @{n='lastLogonTimestamp';e={[DateTime]::FromFileTime($_.lastLogonTimestamp)}}, @{n='lastLogon';e={[DateTime]::FromFileTime($_.lastLogon)}} | export-csv c:\temp\user_fr.csv -encoding "unicode"
Recent Comments