by butsch
13. December 2016 18:54
Powershell: List/Export Active Directory users UNDER certain OU incl. Home share
Searchbase = distinguishedName
How to find this out:
- Start Active Directory User and Computers Console
- Go to the OU you want to export and Right click > Attribute Editor
- Copy the distinguishedName into the script below behind search base
- Change your Domain controller behind Server
-
Searchbase = distinguishedName
IMPORT all Active Directory attributes under certain OU
Change all READ to your site info as mentioned above |
import-module ActiveDirectory
$ADUserParams=@{
'Server' = 'yourdomaincontroller'
'Searchbase' = 'OU=User,OU=Schweiz,DC=butsch,DC=ch'
'Searchscope'= 'Subtree'
'Filter' = '*'
'Properties' = '*'
}
$SelectParams=@{
'Property' = 'SAMAccountname', 'CN', 'title', 'DisplayName', 'Description', 'EmailAddress', 'mobilephone',@{name='businesscategory';expression={$_.businesscategory -join '; '}}, 'office', 'officephone', 'state', 'streetaddress', 'city', 'employeeID', 'Employeenumber', 'enabled', 'lockedout', 'lastlogondate', 'badpwdcount', 'passwordlastset', 'created','homeDrive','homeDirectory'
}
get-aduser @ADUserParams | select-object @SelectParams | export-csv "c:\edv\users.csv" |
Save Powershell as c:\edv\dump.ps1
Logon on to Domain Controller
Start Powershell
Run .\dump.ps1 from c:\edv folder (Notice the .\ infront of dump.ps1)
You will get a COMMA Seperated list like this |
#TYPE Selected.Microsoft.ActiveDirectory.Management.ADUser
"SAMAccountname","CN","title","DisplayName","Description","EmailAddress","mobilephone","businesscategory","office","officephone","state","streetaddress","city","employeeID","Employeenumber","enabled","lockedout","lastlogondate","badpwdcount","passwordlastset","created","homeDrive","homeDirectory" |
8ad852c2-00a7-4967-8c95-60a9a2c4a7df|34|4.0|27604f05-86ad-47ef-9e05-950bb762570c
Tags:
Scripting