Export Computer and User List from AD using PowerShell

1)     Go to Administrative Tools and open Active Directory Module for Windows PowerShell

2)     Open

3)     Use this command

Export computers from AD

Get-ADComputer -Filter * -Property * | Select-Object Name,OperatingSystem,OperatingSystemServicePack,OperatingSystemVersion | Export-CSV AllWindows.csv -NoTypeInformation -Encoding UTF8

Source:

https://social.technet.microsoft.com/Forums/sharepoint/en-US/fbdd4027-e132-4c6b-ad6f-468944c2ce12/how-to-export-all-computer-list-with-operating-system-from-ad-and-all-attributes-like-disable-or?forum=winserverDS

Export Users From AD

Get-ADUser -Filter * -Properties * | select SamAccountName, DisplayName, EmailAddress, Title | Export-CSV  "C:\users.csv"

Source

·          https://technet.microsoft.com/en-us/library/ee617241.aspx

·          https://social.technet.microsoft.com/Forums/windowsserver/en-US/f7ae07a0-f2cd-42a8-b5b3-97b582ca8cad/export-users-to-csv?forum=winserverDS

·          https://community.spiceworks.com/how_to/86794-powershell-how-to-export-displayname-email-address-and-title-from-ad-to-csv-file

Share on Google Plus

About Tom DeMeulenaere

Highly accomplished information technology professional with extensive knowledge in System Center Configuration Manager, Windows Server, SharePoint, and Office 365.