Productivv

IT | CLOUD | RELIABLE

Recent Posts

Recent Comments

Archives

Categories

Meta

Powershell: Export users from AD to Excel

Export all users from AD from a specific OU (recursive) to Excel

$OU = 'OU=USERS,DC=PRODUCTIVV,DC=LOCAL'
Get-ADUser -Filter * -SearchBase $OU -SearchScope Subtree | Select-object DistinguishedName,Name,UserPrincipalName | export-csv -path c:\temp\userexport.csv

Only enabled users

$OU = 'OU=USERS,DC=PRODUCTIVV,DC=LOCAL'
Get-ADUser -Filter * -SearchBase $OU -SearchScope Subtree | Select-object DistinguishedName,Name,UserPrincipalName,Enabled | Where {$_.Enabled -like "False"} | export-csv -path c:\temp\userexport.csv
Published by Arne on | Permalink