Exchange Info Export to CSV via PowerShell

Posted on 2016-08-10
Medium Priority
Last Modified: 2016-09-01
Is there a way to export all user DisplayName,PrimarySMTPAddress,UserPrincipalName AND just their SIP addresses out of the EmailAddresses attribute either from AD or Exchange PowerShell? I would ultimately like to verify that the SIP matches the UPN and Primary SMTP Address. Thanks.
Question by:Christian Hans
LVL 29

Expert Comment

by:MAS (MVE)
ID: 41751619
Please try this
Get-Mailbox -ResultSize Unlimited | Select-Object DisplayName,PrimarySMTPAddress,UserPrincipalName,SipAddress | Export-Csv C:\temp\sip.csv

Open in new window


Author Comment

by:Christian Hans
ID: 41752725
Thanks, this wouldn't work, there's no SipAddress attribute per say when using the Get-Mailbox command... The only attribute containing a SIP would be the "EmailAddresses" > SIP:

The Get-User command doesn't return anything related to the SIP unfortunately either...

I guess I can try to find a command that I maybe able to run in AD that queries the "msRTCSIP-PrimaryUserAddress" attribute... That seems to contain the sip: content.
LVL 19

Accepted Solution

Todd Nelson earned 2000 total points
ID: 41753352
You might be able to get what you want with CSVDE.  Try something like this...

csvde.exe -r objectClass=user -l DisplayName,userPrincipalName,proxyAddresses,Mail -f user-objects.csv

Open in new window


Featured Post

Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Native ability to set a user account password via AD GPO was removed because the passwords can be easily decrypted by any authenticated user in the domain. Microsoft recommends LAPS as a replacement and I have written an article that does something …
If you need to implement application level security in an Access database application or other VBA code, I strongly encourage you to take advantage of Active Directory groups.
There are cases when e.g. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. This proves useful when for example administrator want…
Whether it be Exchange Server Crash Issues, Dirty Shutdown Errors or Failed to mount error, Stellar Phoenix Mailbox Exchange Recovery has always got your back. With the help of its easy to understand user interface and 3 simple steps recovery proced…

627 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question