Hiya I am trying to filter on mailboxes with FolderAndSubfolders size greater than 300MB and nothigs comes up even thou I am many. This is the script that I am using Get-exoMailbox -ResultSize unlimited |Get-exoMailboxFolderStatistics -FolderScope RecoverableItems | ?{$_.FolderAndSubfolders -lt 500MB} Is there a way to make this filter work? SD

There's no property called "FolderAndSubfolders", make sure you use the full name. Also, as this is a string value, you cannot do direct comparison against a value of 500MB, you have to convert it first. Here's an example that should work: Get-MailboxFolderStatistics vasil -FolderScope recover | ? {[double]((($_.FolderAndSubfolderSize).split("("))[1]).Split(" ")[0] -gt "500MB"}

How to filter on FolderAndSubfolders from Get-exoMailboxFolderStatistics

Accepted answer

Vasil Michev 96,161 Reputation points MVP

2020-10-22T13:28:18.233+00:00
There's no property called "FolderAndSubfolders", make sure you use the full name. Also, as this is a string value, you cannot do direct comparison against a value of 500MB, you have to convert it first.

Here's an example that should work:

Get-MailboxFolderStatistics vasil -FolderScope recover | ? {[double]((($_.FolderAndSubfolderSize).split("("))[1]).Split(" ")[0] -gt "500MB"}
Please sign in to rate this answer.

1 person found this answer helpful.
SenhorDolas 1,191 Reputation points

2020-10-22T13:55:28.767+00:00

Hi @Vasil Michev - Thanks for the learning tip.
If I do just the folder size calculation, I get this:
But If I filter just on name I get this:
Get-EXOMailbox vasil@Vasil Popov Sr .com | Get-exoMailboxFolderStatistics -FolderScope recover | ? {$.name -clike "*Reco*"}| select name, FolderAndSubfolderSize
Name FolderAndSubfolderSize
Recoverable Items 360.5 MB (377,967,208 bytes)
But I put the 2 Where-Object together I get nothing?
Get-EXOMailbox vasil@Vasil Popov Sr .com| Get-exoMailboxFolderStatistics -FolderScope recover | ? ({$.name -clike "Reco"} -and {[double]((($_.FolderAndSubfolderSize).split("("))[1]).Split(" ")[0] -gt "100MB"} )| select name, FolderAndSubfolderSize
SD

Rich Matheisen 45,096 Reputation points

2020-10-22T14:15:54.857+00:00

There's no need to treat the value of FolderAndSubfolderSize as a string. If you intend to compare the value to a constant such as "100MB" then just use $_.FolderAndSubfolderSize.ToMB().

Vasil Michev 96,161 Reputation points MVP

2020-10-22T14:29:19.967+00:00

You have some typos again, $_.Name instead of $.Name, and using the like operator without wildcard. Also your brackets are all over the place. It helps to test the code in parts, you know :)

Get-EXOMailbox vasil | Get-EXOMailboxFolderStatistics -FolderScope recover | ? {($_.name -clike "Reco*") -and [double]((($_.FolderAndSubfolderSize).split("("))[1]).Split(" ")[0] -gt "100MB" }| select name, FolderAndSubfolderSize

@Rich Matheisen ideally, but in ExO it's all strings :(

SenhorDolas 1,191 Reputation points

2020-10-22T14:44:40.423+00:00

Tried that before - didn't work - thanks for replying @Rich Matheisen

SenhorDolas 1,191 Reputation points

2020-10-22T14:45:33.377+00:00

@Vasil Michev

Brilliant and thank you so much....

Having a really bad day and not engaging brain!

Guys Thanks!

That works fine.

Rich Matheisen 45,096 Reputation points

2020-10-22T19:46:19.077+00:00

Doh! Deserialized data. :-(

I wonder, if he's running the script from the EMS shell, if this would work?

$Bqs = [Microsoft.Exchange.Data.ByteQuantifiedSize]::parse($_.FolderAndSubFolderSize)

Eric Yin-MSFT 4,386 Reputation points

2020-10-23T02:30:04.383+00:00

Hi, I'm here to confirm with you if your issue has been resolved.
Be free to mark your reply or other useful reply as answer to highlight it,this will make answer searching in the forum easier and be beneficial to other community members as well.
If you need further help, please provide more detailed information, so that we can give more appropriate suggestions.

If an Answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Sign in to comment

How to filter on FolderAndSubfolders from Get-exoMailboxFolderStatistics

0 additional answers