Subscribe to Blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 777 other subscribers


  • LinkedIn
  • RSS Feed for Posts
  • Twitter
  • StumbleUpon

Export Active directory data to csv

Here you find the powershell script which were very useful for me.

All scripts are free of charge, use them at your own risk :

With this script you can export the correct data from the active directory to csv

Get-ADUser -Filter * -Properties * | Select-Object -Property mail,givenName,sn,name,title,department,ipphone,homePhone,mobile | Sort-Object -Property Name | export-CSV C:\scripts\Office-365-AD-export.csv