Hi all,
Here I go again (WhiteSnake 1984 :) )..copy/paste the below code in a ps1 file and you will get the white space, server name, database name, last full backup, user counts..etc
$Databases = Get-MailboxDatabase -Status
foreach($Database in $Databases) {
$DBSize = $Database.DatabaseSize
$MBCount = (Get-Mailbox -Database $Database.Name).Count
$MBAvg = $DBSize.ToBytes() / $MBCount
New-Object PSObject -Property @{
Server = $Database.Server.Name
DatabaseName = $Database.Name
LastFullBackup = $Database.LastFullBackup
MailboxCount = $MBCount
"DatabaseSize (GB)" = "{0:n2}" -f ($DBSize.ToBytes() / 1GB)
"AverageMailboxSize (MB)" = "{0:n2}" -f ($MBAvg / 1MB)
"WhiteSpace (MB)" = "{0:n2}" -f ($Database.AvailableNewMailboxSpace.ToBytes() / 1MB)
} }
The output should be something like that:
Enjoy!
-Dario
No comments:
Post a Comment
Note: Only a member of this blog may post a comment.