Count-PhysicalIndexes.ps1

param($Database, $SaveResults)

. $exscripts\ManagedStoreDiagnosticFunctions.ps1

if ($null -eq (Get-Command Get-StoreQuery -ErrorAction SilentlyContinue)) {
    Write-Error "ManagedStoreDiagnosticFunctions not loaded."
    return
}

$results = @()

$mailboxes = Get-StoreQuery -Database $Database -Query "Select MailboxNumber,DisplayName from Mailbox" -Unlimited

$count = 0

$mailboxes | ForEach-Object {
    $count++
    Write-Progress -Activity "Counting indexes" -PercentComplete ($count * 100 / $mailboxes.Count) -CurrentOperation $_.DisplayName
    $indexes = @(Get-StoreQuery -Database $Database -Query "Select * from PseudoIndexControl where MailboxPartitionNumber = $($_.MailboxNumber)" -Unlimited)
    $outputObject = [PSCustomObject]@{
        MailboxNumber = $_.MailboxNumber
        DisplayName = $_.DisplayName
        IndexCount = $indexes.Count
    }

    $results += $outputObject
    $outputObject
}

$results = $results | Sort-Object MailboxNumber

$timeString = [DateTime]::Now.ToString("yyyyMMddHHmmss")
$fileName = "PhysicalIndexCount-$timeString.csv"

if ($SaveResults) {
    $results | Export-Csv "$PSScriptRoot\$fileName" -NoTypeInformation
}