PowerShell.com
Library » Script Library » Exchange Server 2003 » Find-ExchangeDBFreeSpace

Find-ExchangeDBFreeSpace

Previous | Next | View all files | View Slideshow
posted by Richard Giles
02-27-2009
Downloads: 437
File size: 1.8kB
Views: 1,402
Embed
Find-ExchangeDBFreeSpace
  1. # Jonathan Medd 
  2. # http://jonathanmedd.blogspot.com/2009/01/using-powershell-to-find-free-space-in.html 
  3. # Find free space in Exchange 2003 databases 
  4.  
  5. # Check to see if csv exists and if so remove it 
  6. if (Test-Path "FreeSpaceGreaterThan1GB.csv") 
  7. { 
  8.     Remove-Item "FreeSpaceGreaterThan1GB.csv" 
  9. } 
  10.  
  11. #Set the columns for the csv file 
  12. $rows = "Servername," + "Mailbox Store," + "Free Space (MB)," 
  13. Add-Content FreeSpaceGreaterThan1GB.csv $rows 
  14.  
  15. $ExchServer = 'server1','server2' 
  16. foreach ($Server in $ExchServer) 
  17. { 
  18.     #Get the time 1 day ago in the right format for WMI query 
  19.     $WmidtQueryDT = [System.Management.ManagementDateTimeConverter]::ToDmtfDateTime([DateTime]::Now.AddDays(-1)) 
  20.     #Perform WMI query of Event 1221 in Application log in the last day 
  21.     $1221 = Get-WmiObject -computer $ExchServer -query ("Select * from Win32_NTLogEvent Where Logfile='Application' and Eventcode = '1221' and TimeWritten >='" + $WmidtQueryDT + "'") 
  22.      
  23.     foreach ($event in $1221) 
  24.     { 
  25.         #Get the name of the Mailbox Store 
  26.         $MBXStoreLocationStart = $event.Message.IndexOf("Storage Group") + 16 
  27.         $MBXStoreLocationFinish = $event.Message.IndexOf("has") - 2 
  28.         $MBXStoreLocation = $event.Message.SubString($MBXStoreLocationStart, $MBXStoreLocationFinish - $MBXStoreLocationStart) 
  29.          
  30.         #Get the free space figure and convert it to an integer 
  31.         $MBLocationStart = $event.Message.IndexOf("has") + 4 
  32.         $MBLocationFinish = $event.Message.IndexOf("megabytes") - 1 
  33.         $MBLocation = $event.Message.SubString($MBLocationStart, $MBLocationFinish - $MBLocationStart) 
  34.         $result = [int]$MBLocation 
  35.          
  36.         $ComputerName = $event.ComputerName 
  37.          
  38.         #If free space > 3GB, add the details to the csv file 
  39.         if ($result -ge 3072) 
  40.         { 
  41.             $rowline = "$ComputerName," + "$MBXStoreLocation," + "$MBLocation," 
  42.             Add-Content FreeSpaceGreaterThan1GB.csv $rowline 
  43.         } 
  44.     } 
  45. } 
Filed under: , ,

Find free space in Exchange 2003 databases.

Attributed To: Jonathan Medd

URL: http://jonathanmedd.blogspot.com/2009/01/using-powershell-to-find-free-space-in.html

 

Concentrated Tech NSoftware Dell Compellent Sponsored by Idera and Concentrated Tech and NSoftware and Dell Compellent
Copyright 2011 PowerShell.com. All rights reserved.