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

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,

Free Windows Admin Tool Kit Click here and download it now
March 20th, 2015 5:42am

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

Other recent topics Other recent topics