Get-SearchFolderProperties.ps1

[CmdletBinding()]
param (
    [Parameter()]
    [string]
    $Mailbox
)

$mb = Get-Mailbox $Mailbox
. $exscripts\ManagedStoreDiagnosticFunctions.ps1
$mbTableResult = Get-StoreQuery -Database "$($mb.Database.ToString())" -Query "SELECT MailboxNumber FROM Mailbox WHERE MailboxGuid = '$($mb.ExchangeGuid.ToString())'"
Write-Host "Found mailbox $($mb.DisplayName) with mailbox number $($mbTableResult.MailboxNumber)."
$mailboxNumber = $mbTableResult.MailboxNumber
$searchFolders = Get-StoreQuery -Database "$($mb.Database.ToString())" -Query "SELECT * FROM Folder WHERE MailboxNumber = $mailboxNumber" | Where-Object { $_.SearchState -ne "NULL" }
$searchFolders | ForEach-Object {
    $criteria = $_.QueryCriteria
    $parsedCriteria = Get-StoreQuery -Database "$($mb.Database.ToString())" -Query "SELECT * FROM ParseRestriction($criteria, $mailboxNumber)"
    [PSCustomObject]@{
        DisplayName            = $_.DisplayName
        FolderId               = $_.FolderId
        SearchState            = $_.SearchState
        SetSearchCriteriaFlags = $_.SetSearchCriteriaFlags
        QueryCriteria          = $parsedCriteria.Value
    }
}