Menu

Thank you for visiting my website!

A Multifaceted I.T. Specialist, offering 17+ years of Information Technology Management experience with 17+ years of significant experience in handling information technology, agile methodology software and hardware administration, system management, quality assurance, network connectivity, and troubleshooting while
proficient in most aspects of network management (routers and firewalls), network security controls and learning outcomes including; mobile device fundamentals, networking fundamentals, hardware fundamentals, security fundamentals, operating system fundamentals, virtualization and cloud computing fundamentals,
hardware and network troubleshooting, software troubleshooting, and operational procedure basics.

SEE ME ON LINKEDIN!

POWERSHELL – This Powershell script will Export *All* AD Users to an Excel Spreadsheet

This is a PowerShell script that will export All AD Users to a CSV along with their first and last name, their email address, and department. This must be run under an admin account. 

Get-ADUser -Filter * -Properties * | Select-Object givenName, sn, mail, department | export-csv -path c:\temp\userexport.csv

*The file path can always be changed to any location of your choosing

If you want to Export All AD users by name and last logon date: 

Get-ADUser -Filter * -Properties * | Select-Object name, LastLogonDate | export-csv -path c:\temp\userexport.csv

You can choose what attributes you want to be exported as well. To find those attributes go into AD, select a user, right-click to go to the Attribute Editor. 

So if you want to add an Attribute type it after Select-Object name, 
Get-ADUser -Filter * -Properties * | Select-Object name, lastlogondate, department | export-csv -path c:\temp\userexport.csv
 

PREVIOUS STORY

NEXT STORY