Hi, I am using cmdlet Get-EXOMailbox -resultSize unlimited . But this return a lot of data and it take a lot of time. I would like to use some skip or nextLink but it is not working. I tried this: Get-EXOMailbox | select-object -Skip 10 -First 10 according this source: https://morgantechspace.com/2015/06/powershell-get-mailbox-resultsize.html But i have an error Get-EXOMailbox: The pipeline has been stopped. Exist for this cmdlet some batch? Or any other options how to obtain all exoMailboxes with pagination? Thanks for answer.

For how long does that query run? There are limits within a session that will terminate the query after a time (I think it's one hour, by default). But I think you're probably better off partitioning your search. One way to do that is to use the -RecipientTypeDetails to get only mailboxes of a certain type in each query. Another way would be to use the -Filter parameter.

Get-EXOMailbox -> How to obtain all mailboxes with pagination

Accepted answer

Rich Matheisen 45,106 Reputation points

2024-04-30T15:37:46.2533333+00:00

For how long does that query run? There are limits within a session that will terminate the query after a time (I think it's one hour, by default).

But I think you're probably better off partitioning your search. One way to do that is to use the -RecipientTypeDetails to get only mailboxes of a certain type in each query. Another way would be to use the -Filter parameter.
Please sign in to rate this answer.
Trubianska, Juliana 46 Reputation points

2024-05-02T06:42:26.1066667+00:00

We are using Azure Functions, which stop executing the script after 1 hour. I need to interrupt the script before this happens and somehow resume the next run from the point where the last run finished. For this, I need to store the last executed point. As you mentioned, using -RecipientTypeDetails or -filter can split the data into smaller pieces, providing a starting point. However, I was hoping for something less complicated. For example, in Microsoft Graph, there is a nextLink for pagination, which makes it easy to store and start from that point. It would be beneficial if Microsoft Graph contained endpoints for ExoMailbox, ExoRecipient, and ExoMailboxPermission.

Trubianska, Juliana 46 Reputation points

2024-05-02T06:45:51.78+00:00

Thanks for answer.

Rich Matheisen 45,106 Reputation points

2024-05-02T15:36:22.5133333+00:00

I'm not at all familiar with Azure and what limitations it imposes on the execution of PowerShell scripts (or just in general to anything!).

If you're using PowerShell 7 you can use a ForEach-Object -Parallel {<scriptblock>} or Start-Job (if using PowerShell 5, or 7) together with partitioning your search to achieve a level of parallel processing.
Sign in to comment

Share via

Get-EXOMailbox -> How to obtain all mailboxes with pagination

0 additional answers