Forum Discussion

Motly-2000's avatar
Motly-2000
Copper Contributor
May 16, 2022

Get-EXOMailboxFolderStatistics result limit 1000 items

EHLO community,   I have a PowerShell scripted process to extract mailbox statistics for a group of large mailbox users 80-90GB. Many of these users demand to keep their primary mailbox full of all...
exchange online
hybrid
office 365
Network23's avatar
Network23
Copper Contributor
May 30, 2022

Motly-2000 I was able to reproduce the issue, since I do have a mailbox with approx 2000 folders. The command

 

Get-MailboxFolderStatistics -Identity $TargetMailbox

 

Is 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 ...

TonyRedmond's avatar
TonyRedmond
MVP
May 31, 2022
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.
  • TonyRedmond's avatar
    TonyRedmond
    MVP
    Jun 02, 2022

    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/

Resources