Aşağıdaki komut ile Exchange üzerinde bulunan tüm database dosyalarına ait bilgileri alabilirsiniz;
Komut çıktısında alacağız bilgiler;
- Server name
- Database name
- The last full backup
- The number of mailboxes
- The database size
- The average mailbox size
- The database whitespace
Komut;
Get-DatabaseStatistics {
$Databases = Get-MailboxDatabase -Status
foreach($Database in $Databases) {
$DBSize = $Database.DatabaseSize
$MBCount = @(Get-MailboxStatistics -Database $Database.Name).Count
$MBAvg = Get-MailboxStatistics -Database $Database.Name |
%{$_.TotalItemSize.value.ToMb()} |
Measure-Object -Average
New-Object PSObject -Property @{
Server = $Database.Server.Name
DatabaseName = $Database.Name
LastFullBackup = $Database.LastFullBackup
MailboxCount = $MBCount
“DatabaseSize (GB)” = $DBSize.ToGB()
“AverageMailboxSize (MB)” = $MBAvg.Average
“WhiteSpace (MB)” = $Database.AvailableNewMailboxSpace.ToMb()
}
}
}

Senior IT Pro Trainer & Consultant focused on MS technologies relating to System Center Products SCCM, SCOM, SCO, SCSM
It’s a plareuse to find someone who can think so clearly