Main navigation

Use Powershell to export Reports from Active Directory

Powershell today is one of the most powerfull tool for IT Pro,System Admins for lot of tasks. One of tasks that has help me a lot is a quick reports that can export from my enviroment in CSV Files and use it to easy found what i want ot give it to my Manager for any kind of Review.

Today i will focus in Export any info from Active Directory like Computers , Users, Contacts and any attributes of them like Name, Operating System , emailaddresses and save it in Csv for further use.

So let's start

If you use Powershell Version prior to 3 you must install manual the Module of Active Directory. From version 3 and after the module autload when run the cmdlets

Import-Module ActiveDirectory

I will use the following scenarions to export Reports from Active Directory in Csv file or only print in Screen . I have in Bold the commands that you must change.

We need to find how many contacts has in Active Directory with Name,Address and X500 Address.

These commands are very usefull when you want something quick and up to date. Also for IT Pro and System Admins that are in new job without has any documentation from Previous IT can help a lot to take am image of Active Directory enviroment.

Now it's your turn to share what you know and how can export your Reports that you need from Active Diretory quick and up to date. Share it in our Commented System and discuss it with other IT Pro.

Askme4Tech is my Blog to the IT Community. From this site i share tips, news and in depth tutorials for IT Professionals working with Microsoft products.

My goal is to create a share Knowledge base for IT Professionals and Power Users that works with Microsoft Products and to provide valuable help in daily technical problems and keep up to date with news from IT industry.