Solved

Exchange Info Export to CSV via PowerShell

Posted on 2016-08-10
3
34 Views
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.
0
Comment
Question by:Christian Hans
3 Comments
 
LVL 24

Expert Comment

by:-MAS
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


Thanks
1
 

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.
0
 
LVL 14

Accepted Solution

by:
Todd Nelson earned 500 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

0

Featured Post

Want to promote your upcoming event?

Are you going to an event? Are you going to be exhibiting at a tradeshow? Talking at a conference? Using a promotional banner in your email signature ensures that your organization’s most important contacts stay in the know and can potentially spread the word about the event.

Join & Write a Comment

Utilizing an array to gracefully append to a list of EmailAddresses
Learn to move / copy / export exchange contacts to iPhone without using any software. Also see the issues in configuration of exchange with iPhone to migrate contacts.
In this video we show how to create a mailbox database in Exchange 2013. We show this process by using the Exchange Admin Center. Log into Exchange Admin Center.: First we need to log into the Exchange Admin Center. Navigate to the Servers >> Data…
This tutorial will walk an individual through the process of transferring the five major, necessary Active Directory Roles, commonly referred to as the FSMO roles from a Windows Server 2008 domain controller to a Windows Server 2012 domain controlle…

707 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now