Gets Exchange mailbox statistics for a list of users specified in a text file. Writes the statistics to an output .csv file.

GetExchangeMailboxStatisticsForUserList.ps1

# Load the Exchange management cmdlets.
Add-PSSnapin Microsoft.Exchange.Management.PowerShell.Admin
Add-PSSnapin Microsoft.Exchange.Management.Powershell.Support

# Import all the modules located in:
#   %windir%\System32\WindowsPowerShell\v1.0\Modules
ImportSystemModules

$usersFromFile = Get-Content "users.txt"

$userstats = @()
ForEach ($u in $usersFromFile)
{
    Write-Host "Processing $u..."
    $foundUserStats = Get-MailboxStatistics $u | `
        Select DisplayName, TotalItemSize, ItemCount, ServerName, StorageGroupName, Database
        
    $userstats = $userstats + $foundUserStats
}

$userstats | Export-Csv -Path "userstats.csv" -notype