Today I was reading Steve Goodman’s Blog and he wrote a very cool
PowerShell script to tell you the size of your Offline Address Book. I decided
to use this script as inspiration to write a PowerShell that could tell you the
size in MB of all your Exchange 2010 Databases. Here is the code for the
PowerShell script or you can just download from here.
PowerShell script to tell you the size of your Offline Address Book. I decided
to use this script as inspiration to write a PowerShell that could tell you the
size in MB of all your Exchange 2010 Databases. Here is the code for the
PowerShell script or you can just download from here.
$MYDatabases = Get-MailBoxDatabase
foreach ($DB in $MYDatabases)
{
foreach ($DB in $MYDatabases)
{
[string]$DBPathString = $db.EDBFILEpath
# Build Database
File Path
$MyDriveString =$DBPathString.substring(0,1);
# Build Database
File Path
$MyDriveString =$DBPathString.substring(0,1);
$MySubString=$DBPathString.substring(0,2);
$UNCPath = “\\$($db.Server)\”
+ $MyDriveString + “$” ;
$UNCDBPath =
$DBPathString.Replace($MySubString,$UNCPath);
#Get File Info
$DBFiles = get-childitem -path $UNCDBPath;
$UNCPath = “\\$($db.Server)\”
+ $MyDriveString + “$” ;
$UNCDBPath =
$DBPathString.Replace($MySubString,$UNCPath);
#Get File Info
$DBFiles = get-childitem -path $UNCDBPath;
[long]$MBSize = ($DBFiles | Measure-Object -Property Length -Sum).Sum;
[long]$MBSize = $MBSize/1048576;
[string]$DBFILESIZE = $MBSize;
[string]$DBFILESIZE = $MBSize;
$DBFILESIZe = $DBFILESIZE + “MB”;
# Output info
$MyData = New-Object Object;
$MyData | Add-Member NoteProperty Name
$DB.Name;
$MyData | Add-Member NoteProperty Server $DB.Server;
$MyData | Add-Member NoteProperty Name
$DB.Name;
$MyData | Add-Member NoteProperty Server $DB.Server;
$MyData | Add-Member NoteProperty Size $DBFILESIZE;
$MyData;
}
Tweet $MyData;
}