Hi Folks.

I need to export a bunch of messages from the journaling mailbox and the New-MailboxExportRequest always successfully completes with only 250 items exported to the PST.

Is there a setting I can adjust to export all the messages that match the query???

I read a few posts online that suggests that this is by design...  Sounds like the worst idea ever.

Thanks.

That seems like an odd limit, can you share the posts that discuss that?

If that's true then the only other option would be to use a 3rd party solution like our DigiScope product http://www.lucid8.com/product/digiscope.asp that can connect to the production journal database or the offline EDB and then export to PST and we have no item limits, only PST size limits, however if you reach the limit a new PST will be spawned, i.e. Journal.PST, Journal1.PST etc.

Here is one article from a third party: -- 

http://maneffa-it.blogspot.ca/2014/09/exchange-2013-new-mailboxexport-request.html

Here are a few similar thread on here but client side instead of server side: (The issue seems similar)

https://social.technet.microsoft.com/Forums/office/en-US/3654650b-40a7-40dd-9dd3-6bd14b8569b6/enduser-item-search-limit-250-increase?forum=exchangesvrgeneral

https://social.technet.microsoft.com/Forums/office/en-US/6ec28ac0-e9b8-4ebf-83dc-24e1ad3e9c5a/search-results-for-online-archive-limited-to-250-results?forum=exchangesvrclients

Hmm yeah it must be something to do with memory/resource management but I agree its a frustrating limitation for sure.  Based upon that limitation the only thing you could do is implement a 3rd party tool like our DigiScope product.

I think you need a third party tool to convert your mailbox to PST. you can try http://www.datacarelab.com/edb-converter.php

It is a good tool and u can also check the preview of the messages, attachments, contacts, calendar, notes

Hi Paul,

Please post the cmdlet that you are running so that we can test it out. Also let us know the other references\online posts where you have observed the 250 limit issue.

The test I ran as below was without any query and it did export over 400+ items.

New-MailboxExportRequest -Mailbox AylaKol -FilePath "\\SERVER01\PSTFileShare\Ayla_Recovered.pst"


Get-MailboxExportRequest | Get-MailboxExportRequestStatistics | fl

EstimatedTransferSize                  : 3.903 MB (4,092,867 bytes)
EstimatedTransferItemCount             : 403
BytesTransferred                       : 5.352 MB (5,611,602 bytes)
BytesTransferredPerMinute              :
ItemsTransferred                       : 402
PercentComplete                        : 100

Filterable properties for the -ContentFilter parameter

https://technet.microsoft.com/en-us/library/ff601762%28v=exchg.150%29.aspx?f=255&MSPPError=-2147217396

As an alternative method check if New-MailboxSearch, helps you to get the results out.

Then use Search-Mailbox to move it to some TempMailbox, which has a configured Outlook profile to extract the data as PST.

Search-Mailbox -Identity "April Stewart" -SearchQuery 'Subject:"Your bank statement"' -TargetMailbox "administrator" -TargetFolder "SearchAndDeleteLog" -LogOnly -LogLevel Full

Use the Search-Mailbox cmdlet to search a mailbox and copy the results to a specified target mailbox, delete messages from the source mailbox, or b

Thanks Satyajit for your response.

I don't have the exact query I used, but Essentially, it's any query where wildcards are used.  Here's an example. 

New-MailboxExportRequest -name "export1" -mailbox journal3 -filepath "\\s0018\pstfiles\export1.pst" -ContentFilter {(all -like "*jellis*")}

I'd love to confirm that I'm not the one going crazy here..  :-)

Thanks again.

-P

To clarify...   After some tests, it seems that the "250 item limit" only affect queries where the content filter includes a wildcard.

Thanks again.

Hi Paul,

I don't seem to be hitting any limits.

What version are you running:

Get-ExchangeServer | ft AdminDisplayVersion

To test prepare a temp mailbox with around 500+ emails. Run the below cmdlets without any changes and share the results.

New-MailboxExportRequest -name "export1" -mailbox tempsmallmailbox -filepath "\\s0018\pstfiles\export1.pst" -ContentFilter {(Received -like "*")}


#Run this to check on status:
Get-MailboxExportRequest -Name "export1"

#Once completed, run this:

Get-MailboxExportRequest -Name "export1" | Get-MailboxExportRequestStatistics | fl *transfer*

Here is my sample run results:

[PS] C:\Scripts>New-MailboxExportRequest -Mailbox SAtyaTEst1 -ContentFilter {(Received -like "*")} -FilePath "\\EXCH-1\C$\Scripts\Export2.pst"

Name                                            Mailbox                                        Status
----                                            -------                                        ------
MailboxExport1                                  contoso.com/Users/Test Users/SatyaTEST1        Queued


[PS] C:\Scripts>Get-MailboxExportRequest | Get-MailboxExportRequestStatistics | fl *transfer*


EstimatedTransferSize      : 4.297 MB (4,505,250 bytes)
EstimatedTransferItemCount : 446
BytesTransferred           : 5.922 MB (6,209,706 bytes)
BytesTransferredPerMinute  :
ItemsTransferred           : 444