0

Is there a way to export all the contacts for each mailboxes in Exchange 2010 to a format easy to import to MS SQL? (i.e. CSV)

So far I got this working but a PST format is absolutely pointless:

foreach ($i in (Get-Mailbox)) { New-MailboxExportRequest -Mailbox $i -FilePath “\\computer\c$\pst\$($i.Alias).pst” -IncludeFolders “#Contacts#” -ExcludeDumpster}

The objective is to automate the task so we can run it each week or so.

JulioQc
  • 310
  • 1
  • 4
  • 20

1 Answers1

2

You can use EWS (Exchange web services) to access and then export Mailbox content there are a bunch of examples for exporting contacts eg

https://github.com/wadimk/PowerShell-Scripting/blob/master/PowerShell%20Script%20Project/EWS-Export-Contacts.ps1

https://gallery.technet.microsoft.com/office/Export-Contacts-from-OWA-9f8cc0f2

http://gsexdev.blogspot.com.au/2014/02/exporting-contacts-to-csv-file-using.html

Glen Scales
  • 20,495
  • 1
  • 20
  • 23