Solved

Exchange Info Export to CSV via PowerShell

Posted on 2016-08-10
3
49 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 25

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

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article, I am going to show you how to simulate a multi-site Lab environment on a single Hyper-V host. I use this method successfully in my own lab to simulate three fully routed global AD Sites on a Windows 10 Hyper-V host.
This article shows how to deploy dynamic backgrounds to computers depending on the aspect ratio of display
To show how to generate a certificate request 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 >> Certificates…
This tutorial will walk an individual through the process of configuring their Windows Server 2012 domain controller to synchronize its time with a trusted, external resource. Use Google, Bing, or other preferred search engine to locate trusted NTP …

777 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