Export to .pst multiple mailboxes

[sof3301]

Hi everyone!

I try to export multiple mailboxes with PowerShell.
I can use and export a mailbox https://helpcenter.veeam.com/docs/backu ... office-365 (use Example 7)
But I want to export 100 from 1000, using .csv list. Maybe someone came across such a task and has a ready-made solution?

Thank you!

[Mildur]

You need to:
1) Start the restore Session
2) Import the csv File
3) loop through each mailbox in the file and start the pst export command

The necessary code could be something like that (cannot test it at the moment, I don‘t have access to my vbo server)

Code: Select all

# Starting Restore Session with latest Restore Point

$organization = Get-VBOOrganization -Name "Your Org Name"
Start-VBOExchangeItemRestoreSession -LatestState -Organization $organization

# Starting the PST Export for all users in the csv

$session = Get-VBOExchangeItemRestoreSession
$database = Get-VEXDatabase -Session $session -Name "YourM365TenantName.onmicrosoft.com"
$Mailboxes = Import-Csv C:\temp\mailboxes.csv 

# Loop through each mailbox from your csv file.

ForEach ($mailbox in $Mailboxes) {
       $user = Get-VEXMailbox -Database $database -Name $mailbox.name
       Export-VEXItem -Mailbox $user -To "C:\Export\$($mailbox.name).pst"
}

[lukasholzknecht]

Hi,
I'm trying to export multiple Mailboxes to PST with powershell. The problem is, that only the first Mailbox in the CSV get's exported, on the second Powershell reports that there's no value for $user.

Code: Select all

$organization = get-vboorganization -name *<organizationname>*
$restorepoint = Get-VBORestorePoint -Organization $organization | Select-Object -Last 1
Start-VBOExchangeItemRestoreSession -restorepoint $restorepoint -Organization $organization
$session = Get-VBOExchangeItemRestoreSession
$database = Get-VEXDatabase -Session $session -Name *<organizationname>*
$mailboxes = Import-Csv C:\temp\mailboxusers.csv

ForEach ($mailbox in $Mailboxes) {
       $user = Get-VEXMailbox -Database $database -Name $mailbox.name}
       Export-VEXItem -Mailbox $user -To "D:\Export\Mail\$($mailbox.name).pst"
}

any ideas appreciated.

best regards

[Mildur]

Hello Lukas

I moved your question to this topic.
It look like you are closing the loop before you export any data.
The } after $mailbox.name seems wrong to me.

ForEach ($mailbox in $Mailboxes) {
$user = Get-VEXMailbox -Database $database -Name $mailbox.name}
Export-VEXItem -Mailbox $user -To "D:\Export\Mail\$($mailbox.name).pst"
}

The loop should loop like this:
ForEach ($mailbox in $Mailboxes) {
$user = Get-VEXMailbox -Database $database -Name $mailbox.name
Export-VEXItem -Mailbox $user -To "D:\Export\Mail\$($mailbox.name).pst"
}

Please try my sample script from my answer above.

Best,
Fabian

[lukasholzknecht]

Hi Fabian,

in the end it was a typo in the csv-file, now it works.
Thank you

[alexanderbrix]

Hello,
we are using Veeam Backup & Replication 12 with Exchange 2016 on prem.
We are planning to export all Mailboxes into single PST files to import them into Exchange Online.

Exporting a single Usermailbox with the following code is working well.

Code: Select all

$restorepoint = Get-VBRApplicationRestorePoint -id 17d2c39d-e247-46e9-9507-dfc9c6d45601
Start-VBRExchangeItemRestoreSession -RestorePoint $restorepoint[0]

$session = Get-VBRExchangeItemRestoreSession
$database = Get-VEXDatabase -Session $session -Name "UserMailbox.edb"
$abrixmailbox = Get-VEXMailbox -Database $database -Name "Alexander Brix"
Export-VEXItem -Mailbox $abrixmailbox -To "C:\users\sysadministrator\Desktop\Alexander Brix.pst"

I used the script posted here to export multiple Usermailboxes into PST files but I always keep getting errors. Any help is really appreciated.
Thank you!
Here is the script:

Code: Select all

$restorepoint = Get-VBRApplicationRestorePoint -id 17d2c39d-e247-46e9-9507-dfc9c6d45601
Start-VBRExchangeItemRestoreSession -RestorePoint $restorepoint[0]

$session = Get-VBRExchangeItemRestoreSession
$database = Get-VEXDatabase -Session $session -Name "UserMailbox.edb"
$Mailboxes = Import-Csv C:\users\sysadministrator\Desktop\user.csv

ForEach ($mailbox in $Mailboxes) {
       $user = Get-VEXMailbox -Database $database -Name $mailbox.name
       Export-VEXItem -Mailbox $user -To "C:\users\sysadministrator\Desktop\PSTExport\$($mailbox.name).pst"
       }

Content of the user.csv - two mailboxes just for testing:

Code: Select all

Alexander Brix
Michael Müller

When I execute all commands line by line they are working until the "ForEach" - that's where I get the following error:

Code: Select all

Export-VEXItem : "System.Object[]" kann nicht in den Typ "Veeam.Exchange.PowerShell.Model.Items.VEXMailbox" konvertiert werden, der für den Parameter "Mailbox" erforderlich ist. Die angegebene Methode wird nicht 
unterstützt.
In Zeile:3 Zeichen:32
+        Export-VEXItem -Mailbox $user -To "C:\users\sysadministrator\D ...
+                                ~~~~~
    + CategoryInfo          : InvalidArgument: (:) [Export-VEXItem], ParameterBindingException
    + FullyQualifiedErrorId : CannotConvertArgument,Veeam.Exchange.PowerShell.Cmdlets.Export.ExportVEXItem

If I change the user.csv into:

Code: Select all

Alexander Brix;Michael Müller

there is no error but there will also be no PST created...

Thank you for your help!

Best wishes
Alexander