exporting Exchange User Details (get command)

Hi,

Which 'get' command I can use to export all Exchange AD user details like; Name,DisplayName,OrganizationalUnit,RecipientType,Title,Department,Office,Company,City,Manager

which should be exported to a CSV file (to use it with another HR application)

worth to mention: I need the report in CSV format itself for some reason.

[I have tried get-mailbox and get-mailboxstatistics   but doesnt give all required fields.

Then I tried get-user  but it gives only one column with some unique ID ]

I have used the following get-user cmnd;

Get-User -resultsize unlimited |FT Name,DisplayName,OrganizationalUnit,RecipientType,WindowsEmailAddress,Title,Department,Office,Company,city | Export-csv D:\userdetails.csv

Please suggest



  • Edited by ANTONYMA 18 hours 38 minutes ago
March 17th, 2015 12:03pm

Hello

tip: Get-ADUser -Identity administrator -Properties * |fl

http://blogs.technet.com/b/dkegg/archive/2014/05/09/msexchrecipienttypedetails.aspx

Free Windows Admin Tool Kit Click here and download it now
March 17th, 2015 6:29pm

Hi,

Which 'get' command I can use to export all Exchange AD user details like; Name,DisplayName,OrganizationalUnit,RecipientType,Title,Department,Office,Company,City,Manager

which should be exported to a CSV file (to use it with another HR application)

worth to mention: I need the report in CSV format itself for some reason.

[I have tried get-mailbox and get-mailboxstatistics   but doesnt give all required fields.

Then I tried get-user  but it gives only one column with some unique ID ]

I have used the following get-user cmnd;

Get-User -resultsize unlimited |FT Name,DisplayName,OrganizationalUnit,RecipientType,WindowsEmailAddress,Title,Department,Office,Company,city | Export-csv D:\userdetails.csv

Please suggest



Don't use FT before Export-CSV.  That screws up the output and you probably aren't getting the information.  Try Get-User -ResultSize Unlimited | select name, displayname, OrganizationUnit, Re........ | Export-CSV -path <path for csv>.csv -NoType
March 17th, 2015 8:56pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics