Forum Discussion
Get-EXOMailboxFolderStatistics result limit 1000 items
But it looks to me you might probably mean Get-MailboxFolderStatistics/Get-ExOMailboxFolderStatistics instead? Same here though, no -ResultSize parameter. In any case, if the built-in cmdlets are not returning the full set of folders, you'd probably need some EWS or Graph API based solution.
Updated the post.
Difficult scenario to test without a mailbox with over 1000 top level or nested folders.
I'm hoping I missed something obvious but all tests of both Get-MailboxFolderStatistics/Get-ExOMailboxFolderStatistics, now limit at 1000.
Thanks again.
Motly-2000 VasilMichev TonyRedmond
Hi,
Good news, I opened a case last week from O365 support, and it seems they just added the resultsize parameter to the Get-MailboxFolderStatistics. The following command :(Get-MailboxFolderStatistics -Identity $TargetMailbox -resultsize unlimited).Counton our big big mailbox is now returning more than 1000 results.
Thanks for your assistance.
- This worked, Thank you.
I used the below script to count sub folders on my biiiig mailbox.
$Mailbox = Get-Mailbox -Identity "email address removed for privacy reasons"
$Folders = $Mailbox |
Get-MailboxFolderStatistics -ResultSize Unlimited | # Ensure all folders are retrieved
Where-Object { $_.FolderPath -notmatch '^\$' } | # Exclude the root folder
Measure-Object |
Select-Object -ExpandProperty Count
$Result = New-Object -TypeName PSCustomObject -Property @{
Username = $Mailbox.Alias
FolderCount = $Folders
}
$Result |
Select-Object -Property Username, FolderCount Even after specifying Result size parameter its showing only 1000 folders Network23
- That's very interesting. They updated it for Get-MailboxFolderStatistics but not for Get-ExoMailboxFolderStatistics (probably because of pagination). I'll let the people who I was bugging know about the resolution. Sometimes one part of Microsoft doesn't communicate with another...
Motly-2000 I was able to reproduce the issue, since I do have a mailbox with approx 2000 folders. The command
Get-MailboxFolderStatistics -Identity $TargetMailboxIs now returning only the 1000 first items, it is a big issue for our systems since a script to export and archive mails in subfolders of that email relies on this command, since the capped result change without any warning, we do not have time planned to implement a whole Graph API based solution right now, and we are currently stuck on archive request on a nearly full mailbox ...
- I agree with Vasil that you should open a support case. It might be that the developers haven't run the cmdlet against a mailbox with so many folders. In the meantime, you might find that developing a Graph-based answer isn't as complex as you think. See https://office365itpros.com/2022/05/19/mailbox-folder-statistics/ for an example.
I've documented a use case in the article below and shared it with Exchange engineering. It might be the case that someone made an assumption that no one would ever have more than 1,000 folders in a mailbox, but as I describe, this happens with the non-IPM folders in group mailboxes...
How Many Teams Compliance Records Are in Your Tenant?
The Microsoft 365 substrate captures Teams compliance records for chats and channel conversations and stores them in Exchange Online. How many do you have? Although you might not care, sometimes it’s good to know (like a tenant to tenant migration), so we explain how to count Teams compliance records for chats and channel conversations.
https://office365itpros.com/2022/06/02/teams-compliance-records-count/
Best open a support case and report this. Nino_Bilic for visibility.
