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 Tuesday, March 17, 2015 12:45 PM

Hi,

I have a test in my environment using Exchange 2013, you can use the following cmdlet.

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

Change "FT" to Select

Hope this can be helpful to you.

Best regards,