Exchange Info Export to CSV via PowerShell

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.
Christian HansAsked:
Who is Participating?
 
Todd NelsonConnect With a Mentor Systems EngineerCommented:
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

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

Open in new window


Thanks
1
 
Christian HansAuthor Commented:
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.
0
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.

All Courses

From novice to tech pro — start learning today.