Exchange 2007 Mailbox Database Reporting Script


We use the following script to report on Exchange 2007 Mailbox Database usage.

I will be modifying it for 2010 soon – watch this space 🙂

 

001
002
003
004
005
006
007
008
009
010
011
012
013
014
015
016
017
018
019
020
021
022
023
024
025
026
027
028
029
030
031
032
033
034
035
036
037
038
039
040
041
042
043
044
045
046
047
048
049
050
051
052
053
054
055
056
057
058
059
060
061
062
063
064
065
066
067
068
069
070
# Script to show the size and mailbox count of all databases
# Karl Mitschke 4/9/2008
# Modified 1/26/2010 to gather whitespace information

#requires -pssnapin Microsoft.Exchange.Management.PowerShell.Admin
#requires -version 2

# Get-ExchangeWhiteSpace from Shay Levi’s blog
# http://blogs.microsoft.co.il/blogs/scriptfanatic/archive/2009/08/13/exchange-white-space.aspx
function Get-ExchangeWhiteSpace { 

param( 
   $ComputerName = $(throw "ComputerName cannot be empty.") 
)

# Convert Dates to WMI CIM dates
$tc = [System.Management.ManagementDateTimeconverter] 
$Start =$tc::ToDmtfDateTime( (Get-Date).AddDays(-1).Date ) 
$End =$tc::ToDmtfDateTime( (Get-Date).Date) 

#Create a hash Table to hold the freespace information
$whiteSpace = @{}

# Create two claculated properties for InsertionStrings values
$DB = @{Name="DB";Expression={$_.InsertionStrings[1]}} 
$FreeMB = @{Name="FreeMB";Expression={[int]$_.InsertionStrings[0]}} 

$freespace = Get-WMIObject Win32_NTLogEvent -ComputerName $ComputerName -Filter "LogFile=’Application’ AND EventCode=1221 AND TimeWritten>=’$Start’ AND TimeWritten<=’$End’" | Select-Object $DB,$FreeMB | Sort-Object FreeMB –Unique –Descending
$freespace | ForEach-Object {$whiteSpace.Add($_.DB,$_.FreeMB)}
}

$date = ( get-date ).ToString(‘MM-dd-yyyy’)

$AllServers = @()
foreach ($server in Get-MailboxServer)
{
. Get-ExchangeWhiteSpace $server
    foreach ($objItem in Get-MailboxDatabase -server $server)
    {
    $edbfilepath = $objItem.edbfilepath
    $path = "`\`\" + $server + "`\" + $objItem.EdbFilePath.DriveName.Remove(1).ToString() + "$"+ $objItem.EdbFilePath.PathName.Remove(0,2)
    $dbsize = Get-ChildItem $path
$dbpath = $EdbFilePath.PathName.Remove(0,2).remove($EdbFilePath.PathName.length6)
$mailboxpath = "$server$dbpath"
$size = get-wmiobject -computername $server win32_logicaldisk |where-object {$_.deviceid -eq $objItem.EdbFilePath.DriveName} |select-object deviceID, Freespace, Size
$freespace = ($size.freespace / 1GB)
$total = ($size.size / 1GB)
$PercentFree = "{0:n2}" -f ($freespace / $total *100)
$mailboxcount = Get-MailboxStatistics -database "$mailboxpath" |Where {$_.DisconnectDate -eq $null -and $_.ObjectClass -eq ‘Mailbox’} |measure-object
$disconnectedmailboxcount = Get-MailboxStatistics -database "$mailboxpath" |Where {$_.DisconnectDate -ne $null} |measure-object
$ReturnedObj = New-Object PSObject
$ReturnedObj | Add-Member -MemberType NoteProperty -Name "Server\StorageGroup\Database" -Value $objItem.Identity
$ReturnedObj | Add-Member -MemberType NoteProperty -Name "Total Size (GB)" -Value ("{0:n2}" -f ($total))
$ReturnedObj | Add-Member -MemberType NoteProperty -Name "Used Space (GB)" -Value ("{0:n2}" -f ($dbsize.Length/1024MB))
$ReturnedObj | Add-Member -MemberType NoteProperty -Name "Free Space (GB)" -Value ("{0:n2}" -f ($freespace))
$ReturnedObj | Add-Member -MemberType NoteProperty -Name "Percent Disk Free" -Value $percentfree
$ReturnedObj | Add-Member -MemberType NoteProperty -Name "User Mailbox Count" -Value $mailboxcount.count
$dbasename = $objitem.Identity.parent.name +"\" + $objitem.Identity.name
$ReturnedObj | Add-Member -MemberType NoteProperty -Name "White Space (GB)" -Value ("{0:n2}" -f ($whiteSpace[$dbasename]/1024))
$ReturnedObj | Add-Member -MemberType NoteProperty -Name "Total Free (GB)" -Value ("{0:n2}" -f ($freespace + $whiteSpace[$dbasename]/1024))
$TotalPercent = ($freespace + $whiteSpace[$dbasename]/1024) / $total *100
$ReturnedObj | Add-Member -MemberType NoteProperty -Name "Total Percent Free" -Value ("{0:n2}" -f ($TotalPercent))
    $AllServers += $ReturnedObj
}
}

$body = "<font color=blue>Mailbox database size report for $date<br /><br />"
$bodydetail = $allservers |sort-object "Server\StorageGroup\Database" |convertto-html
$body = $body + $bodydetail
Send-MailMessage -To "kmitschke@contoso.com" -Body $body -Subject "Mailbox Database Size Report" -SmtpServer "mail.contoso.com" -BodyAsHtml:$true -From mailboxdatabaseizereport@noreply.com

 

Here is a sample output:

 

Mailbox database size report for 01-26-2010

Server\StorageGroup\Database

Total Size (GB)

Used Space (GB)

Free Space (GB)

Percent Disk Free

User Mailbox Count

White Space (GB)

Total Free (GB)

Total Percent Free

Server1\StorageGroup1\Mail1

39.99

25.92

11.40

28.51

553

2.93

14.33

35.84

Server1\StorageGroup2\Mail2

39.99

28.76

8.72

21.79

625

2.75

11.47

28.68

Server2\StorageGroup1\Mail1

30.00

23.25

3.81

12.69

477

2.41

6.22

20.74

Server3\StorageGroup1\Mail1

30.00

12.60

15.04

50.14

206

1.43

16.47

54.91

Server3\StorageGroup2\Mail2

39.99

25.84

13.15

32.88

439

3.38

16.53

41.34

Server3\StorageGroup3\Mail3

30.00

15.00

13.41

44.70

233

1.45

14.86

49.54

Server3\StorageGroup4\Mail4

50.00

35.49

12.48

24.97

707

1.96

14.44

28.89

Advertisements
  1. #1 by Link by umeee on February 5, 2010 - 13:45

    thanks its helped me alot

  2. #3 by Roy on February 13, 2010 - 13:48

    Hi Karl,
    I appreciate if you post the script which works for powrshell v1. Tahnks

    • #4 by karlmitschke on February 16, 2010 - 15:40

      Roy;

      I will try to get to that this week – as far as I remember, the only thing that needs modifying is hte last line, “Send-MailMessage” as Send-MailMessage doesn’t exist in v1.
      Change that as:
      $SmtpClient = new-object system.net.mail.smtpClient
      $MailMessage = New-Object system.net.mail.mailmessage
      $SmtpClient.Host = “mail.contoso.com”
      $mailmessage.from = “mailboxdatabaseizereport@noreply.com”
      $mailmessage.To.add(“kmitschke@contoso.com”)
      $mailmessage.Subject = “Mailbox Database Size Report”
      $mailmessage.Body = $body
      $MailMessage.IsBodyHtml = $TRUE
      $smtpclient.Send($mailmessage)

  3. #5 by Roy on February 16, 2010 - 19:34

    Thanks it worked, however I can not get any result for User Maibox Count column, the script returns the follwoing errors, any idea:
    At C:\R1.ps1:50 char:50
    + $disconnectedmailboxcount = Get-MailboxStatistics <<<< -database "$mailboxpa
    th" |Where {$_.DisconnectDate -ne $null} |measure-object
    Get-MailboxStatistics : The specified mailbox database "mbx16\SG14\MDB" does no
    t exist.
    At C:\R1.ps1:49 char:38
    + $mailboxcount = Get-MailboxStatistics <<<< -database "$mailboxpath" |Where {
    $_.DisconnectDate -eq $null -and $_.ObjectClass -eq `Mailbox'} |measure-object
    Get-MailboxStatistics : The specified mailbox database "mbx16\SG14\MDB" does no
    t exist.
    At C:\R1.ps1:50 char:50
    + $disconnectedmailboxcount = Get-MailboxStatistics <<<< -database "$mailboxpa
    th" |Where {$_.DisconnectDate -ne $null} |measure-object
    Get-WmiObject : Invalid query
    At C:\R1.ps1:28 char:27
    + $freespace = Get-WMIObject <<<=’$Start’ AN
    D TimeWritten<='$End'" | Select-Object $DB,$FreeMB | Sort-Object FreeMB -Unique
    -Descending
    Exception calling "Add" with "2" argument(s): "Key cannot be null.
    Parameter name: key"

    • #6 by karlmitschke on February 17, 2010 - 00:41

      Roy;

      Does that database exist?
      Karl

      • #7 by karlmitschke on February 19, 2010 - 20:41

        Roy;

        Kill this line, and try it again:
        “$disconnectedmailboxcount = Get-MailboxStatistics -database “$mailboxpath” |Where {$_.DisconnectDate -ne $null} |measure-object

        Karl

  4. #8 by Steven on February 19, 2010 - 14:50

    I’m getting the following errors for database:

    Get-MailboxStatistics : Cannot bind parameter ‘Database’. Cannot convert value
    “EXTLAB\Program Files\Microsoft\Exchange Server\Mailbox\extlab-CDSGE5000\extlab
    -CDSGE5000” to type “Microsoft.Exchange.Configuration.Tasks.DatabaseIdParameter
    “. Error: “‘EXTLAB\Program Files\Microsoft\Exchange Server\Mailbox\extlab-CDSGE
    5000\extlab-CDSGE5000’ is not a valid value for the identity.
    Parameter name: Identity”
    At C:\getDBinfo2.ps1:44 char:48
    + $mailboxcount = Get-MailboxStatistics -database <<<< "$mailboxpath" |Where {
    $_.DisconnectDate -eq $null -and $_.ObjectClass -eq `Mailbox'} |measure-object
    + CategoryInfo : InvalidArgument: (:) [Get-MailboxStatistics], Pa
    rameterBindingException
    + FullyQualifiedErrorId : CannotConvertArgumentNoMessage,Microsoft.Exchang
    e.Management.MapiTasks.GetMailboxStatistics

    Get-MailboxStatistics : Cannot bind parameter 'Database'. Cannot convert value
    "EXTLAB\Program Files\Microsoft\Exchange Server\Mailbox\extlab-CDSGE5000\extlab
    -CDSGE5000" to type "Microsoft.Exchange.Configuration.Tasks.DatabaseIdParameter
    ". Error: "'EXTLAB\Program Files\Microsoft\Exchange Server\Mailbox\extlab-CDSGE
    5000\extlab-CDSGE5000' is not a valid value for the identity.
    Parameter name: Identity"
    At C:\getDBinfo2.ps1:45 char:60
    + $disconnectedmailboxcount = Get-MailboxStatistics -database <<<< "$mailboxpa
    th" |Where {$_.DisconnectDate -ne $null} |measure-object
    + CategoryInfo : InvalidArgument: (:) [Get-MailboxStatistics], Pa
    rameterBindingException
    + FullyQualifiedErrorId : CannotConvertArgumentNoMessage,Microsoft.Exchang
    e.Management.MapiTasks.GetMailboxStatistics

    The odd thing is, I've been using one of your older scripts (http://powershellcommunity.org/Forums/tabid/54/afv/topic/aff/3/aft/1110/afpg/1/Default.aspx) and it works perfectly…

    • #9 by karlmitschke on February 19, 2010 - 16:42

      Steven;

      I’ll take a look at this.

      Out of curiosity, which script on that page were you using (out of the 7 pages) 😉

      Karl

  5. #10 by Steven on February 19, 2010 - 19:04

    Sorry! 🙂

    $exchangeservers = Get-ExchangeServer |where-object {$_.admindisplayversion.major -eq 8 -and $_.IsMailboxServer -eq $true }
    $AllServers = @()
    foreach ($server in $exchangeservers)
    {
    $db = Get-MailboxDatabase -server $server
    foreach ($objItem in $db)
    {
    $edbfilepath = $objItem.edbfilepath
    $path = “`\`\” + $server + “`\” + $objItem.EdbFilePath.DriveName.Remove(1).ToString() + “$”+ $objItem.EdbFilePath.PathName.Remove(0,2)
    $dbsize = Get-ChildItem $path

    $DiskObj = get-WmiObject Win32_LogicalDisk -computerName $server | Where-Object { $_.DriveType -eq 3 -and $_.DeviceID -ieq $objItem.EdbFilePath.DriveName}
    $FreeOnStorage = [double]($DiskObj.freespace)
    # $FreeOnStorageProc = [float](($DiskObj.freespace /$Jumbo) / ($DiskObj.size / $Jumbo))

    $start = $path.LastIndexOf(‘\’)
    $dbpath = $path.Substring($start +1).remove($path.Substring($start +1).length -4)
    $mailboxpath = “$server\$dbpath”
    $mailboxcount = Get-MailboxStatistics -database “$mailboxpath” |measure-object
    $ReturnedObj = New-Object PSObject
    $ReturnedObj | Add-Member NoteProperty -Name “Server\StorageGroup\Database” -Value $objItem.Identity
    $ReturnedObj | Add-Member NoteProperty -Name “Size (MB)” -Value (“{0:n2}” -f ($dbsize.Length/1024KB))
    $ReturnedObj | Add-Member NoteProperty -Name “Mailbox Count” -Value $mailboxcount.count
    $ReturnedObj | Add-Member NoteProperty -Name “FreeOnStorage (MB)” -Value (“{0:n2}” -f ($FreeOnStorage/1024KB))
    # $ReturnedObj | Add-Member NoteProperty -Name “FreeOnStorageProc” -Value $FreeOnStorageProc
    $AllServers += $ReturnedObj
    }
    }

    $AllServers |export-csv c:\test2.csv -notype -force | Sort $mailboxpath

    • #11 by karlmitschke on February 19, 2010 - 20:40

      Steven;

      Try this:

      . C:\getDBinfo2.ps1
      $mailboxpath
      $server
      $dbpath

      Tell me what you get for each variable.

      Karl

  6. #12 by Steven on February 19, 2010 - 21:57

    Nothing for each. No information, no errors. Those variable did return the correct information last week when I was working with the other script…

    • #13 by karlmitschke on February 24, 2010 - 22:49

      Steven;

      Try this:
      foreach ($server in Get-MailboxServer)
      {

      foreach ($objItem in Get-MailboxDatabase -server $server)
      {
      $edbfilepath = $objItem.edbfilepath
      $dbpath = $EdbFilePath.PathName.Remove(0,2).remove($EdbFilePath.PathName.length-6)
      $mailboxpath = “$server$dbpath”
      write-host $server.name $mailboxpath $dbpath
      }
      }

      Does that return data?

      • #14 by Steven on November 30, 2010 - 13:55

        Sorry for the delay. I’m just now getting back to this due to other projects. The suggestion you made on 2/24/2010 does return data.

      • #15 by Karl Mitschke on December 1, 2010 - 19:36

        Glad to hear it!

  7. #16 by Mithun on March 2, 2010 - 19:15

    Hi Karl,

    Do we need to update edit any fields in the script, because when iam running this script and get same error as steven.
    Regards,
    Mithun

    • #17 by karlmitschke on March 2, 2010 - 21:04

      Mithun;

      I am still trying to find the error.

      Did you run the test I asked Steven to run?
      Karl

      • #18 by Mithun on March 4, 2010 - 04:34

        foreach ($server in Get-MailboxServer)
        {

        foreach ($objItem in Get-MailboxDatabase -server $server)
        {
        $edbfilepath = $objItem.edbfilepath
        $dbpath = $EdbFilePath.PathName.Remove(0,2).remove($EdbFilePath.PathName.length-6)
        $mailboxpath = “$server$dbpath”
        write-host $server.name $mailboxpath $dbpath
        }
        }
        you want me to run this and check if i get some data,

      • #19 by karlmitschke on March 4, 2010 - 14:57

        Yes, please 🙂

      • #20 by Mithun on March 4, 2010 - 15:50

        Yes I get the details of server and storage group in Below format
        “server\Mnt\DB\ExchSrvr\storage group \Mnt\DB\ExchSrvr\Storage group

      • #21 by Mithun on March 4, 2010 - 15:51

        Hi Karl,

        I have one more query could you please help me with this

        We are using exchange 2007 .Using powershell how can we extract the list of Acceptmessagesonlyfrom from a mail
        We used the following cmdlets: –

        get-mailbox “user logon” |fl acceptmessagesonlyfrom,acceptmessagesonlyfromdlmembers |out-file “c:/output/”

        its is not giving complete list it just gives 16 users not more than that , do you have any solution?

      • #22 by karlmitschke on March 12, 2010 - 14:58

        Mithun;

        I suggest never using a format-* cmdlet on anything you will be sending down the pipeline.
        Try this and see if it helps:
        get-mailbox “user logon” |Select-Object acceptmessagesonlyfrom,acceptmessagesonlyfromdlmembers |out-file “c:/output/file”

      • #23 by karlmitschke on March 18, 2010 - 16:13

        Mithun;

        Try’s this:
        function Convert-LocalPathToUNC
        {
        param(
        [string]$ComputerName=$env:COMPUTERNAME,
        [string]$Path=$(throw “Path cannot be empty.”)
        )

        if(Test-Path $Path -IsValid)
        {
        $Path -replace “^(.)(.)”,”\\$computerName\`$1$”
        }
        else
        {
        Write-Error “Invalid Path. The syntax of the path is incorrect.”
        }
        }

        Get-ExchangeServer | where {$_.admindisplayversion.major -eq 8 -and $_.IsMailboxServer} | Foreach-Object{
        $server = $_
        $_ | Get-MailboxDatabase | Select-Object @{n=”Server”;e={$server.Name}},Name,EdbFilePath,@{n=”Size(MB)”;e={ (dir (Convert-LocalPathToUNC -ComputerName $server.Name -Path $_.EdbFilePath)).Length/1MB }},DistinguishedName
        } | Sort-Object “Size(MB)”

        from:
        http://powershellcommunity.org/Forums/tabid/54/aff/3/aft/4726/afv/topic/afpgj/1/Default.aspx#8999

        Does that return data?

        If so, i ewill modify my script.

  8. #24 by Sandeep on March 11, 2010 - 17:27

    Karl,

    I get following output in addition to DB names

    Total Size (GB) Used Space (GB) Free Space (GB) Percent Disk Free User Mailbox Count White Space (GB) Total Free (GB) Total Percent Free
    1.00 124.03 0.97 96.73 0 0.00 0.97 96.73
    1.00 105.36 0.97 96.73 0 0.00 0.97 96.73
    1.00 78.25 0.97 96.73 0 0.00 0.97 96.73
    1.00 82.66 0.97 96.73 0 0.00 0.97 96.73
    1.00 75.01 0.97 96.73 0 0.00 0.97 96.73
    1.00 78.99 0.97 96.73 0 0.00 0.97 96.73
    1.00 82.40 0.97 96.73 0 0.00 0.97 96.73
    1.00 79.61 0.97 96.73 0 0.00 0.97 96.73
    1.00 86.01 0.97 96.73 0 0.00 0.97 96.73
    1.00 86.87 0.97 96.73 0 0.00 0.97 96.73
    1.00 83.60 0.97 96.73 0 0.00 0.97 96.73
    1.00 87.51 0.97 96.73 0 0.00 0.97 96.73
    1.00 76.42 0.97 96.73 0 0.00 0.97 96.73
    1.00 50.82 0.97 96.73 0 0.00 0.97 96.73
    1.00 79.90 0.97 96.73 0 0.00 0.97 96.73
    1.00 58.44 0.97 96.73 0 0.00 0.97 96.73
    1.00 31.01 0.97 96.73 0 0.00 0.97 96.73
    1.00 72.80 0.97 96.73 0 0.00 0.97 96.73

    Now this isnt correct size of the stores, as well number of users are zero & it doesnt give the white space details..here the difference could be that my database are on different mount points..could that be changed in the script?

    • #25 by karlmitschke on March 12, 2010 - 14:55

      I am going to have to look at this in depth soon.

      I have no mount points to work with, but I will try to spin up a new VM shortly.

  9. #26 by Thomas on March 22, 2010 - 14:30

    I am getting the following error when running the script

    Get-WmiObject : Invalid query
    At C:\Scripts\mbstoragereport.ps1:28 char:27
    + $freespace = Get-WMIObject <<<< Win32_NTLogEvent -ComputerName $ComputerName
    -Filter "LogFile='Application' AND EventCode=1221" | Select-Object $DB,$FreeMB
    | Sort-Object FreeMB -Unique -Descending
    Exception calling "Add" with "2" argument(s): "Key cannot be null.
    Parameter name: key"
    At C:\Scripts\mbstoragereport.ps1:29 char:45
    + $freespace | ForEach-Object {$whiteSpace.Add( <<<< $_.DB,$_.FreeMB)}
    Get-MailboxStatistics : Cannot bind parameter 'Database'. Cannot convert value
    "EXCH-MBX01\Program Files\Microsoft\Exchange Server\Mailbox\Mailbox Database 2"
    to type "Microsoft.Exchange.Configuration.Tasks.DatabaseIdParameter". Error: "
    'EXCH-MBX01\Program Files\Microsoft\Exchange Server\Mailbox\Mailbox Database 2'
    is not a valid value for the identity.
    Parameter name: Identity"
    At C:\Scripts\mbstoragereport.ps1:49 char:48
    + $mailboxcount = Get-MailboxStatistics -database <<<< "$mailboxpath" |Where {
    $_.DisconnectDate -eq $null -and $_.ObjectClass -eq `Mailbox'} |measure-object
    Get-MailboxStatistics : Cannot bind parameter 'Database'. Cannot convert value
    "EXCH-MBX01\Program Files\Microsoft\Exchange Server\Mailbox\Mailbox Database 2"
    to type "Microsoft.Exchange.Configuration.Tasks.DatabaseIdParameter". Error: "
    'EXCH-MBX01\Program Files\Microsoft\Exchange Server\Mailbox\Mailbox Database 2'
    is not a valid value for the identity.
    Parameter name: Identity"
    At C:\Scripts\mbstoragereport.ps1:50 char:60
    + $disconnectedmailboxcount = Get-MailboxStatistics -database <<<< "$mailboxpa
    th" |Where {$_.DisconnectDate -ne $null} |measure-object
    Get-MailboxStatistics : The specified mailbox database "EXCH-MBX01\ForthStorage
    Group\Storage Group MB3" does not exist.
    At C:\Scripts\mbstoragereport.ps1:49 char:38
    + $mailboxcount = Get-MailboxStatistics <<<< -database "$mailboxpath" |Where {
    $_.DisconnectDate -eq $null -and $_.ObjectClass -eq `Mailbox'} |measure-object
    Get-MailboxStatistics : The specified mailbox database "EXCH-MBX01\ForthStorage
    Group\Storage Group MB3" does not exist.
    At C:\Scripts\mbstoragereport.ps1:50 char:50
    + $disconnectedmailboxcount = Get-MailboxStatistics <<<< -database "$mailboxpa
    th" |Where {$_.DisconnectDate -ne $null} |measure-object
    Get-MailboxStatistics : The specified mailbox database "EXCH-MBX01\FifthStorage
    Group\Storage Group MB4" does not exist.
    At C:\Scripts\mbstoragereport.ps1:49 char:38
    + $mailboxcount = Get-MailboxStatistics <<<< -database "$mailboxpath" |Where {
    $_.DisconnectDate -eq $null -and $_.ObjectClass -eq `Mailbox'} |measure-object
    Get-MailboxStatistics : The specified mailbox database "EXCH-MBX01\FifthStorage
    Group\Storage Group MB4" does not exist.
    At C:\Scripts\mbstoragereport.ps1:50 char:50
    + $disconnectedmailboxcount = Get-MailboxStatistics <<<< -database "$mailboxpa
    th" |Where {$_.DisconnectDate -ne $null} |measure-object
    Get-MailboxStatistics : The specified mailbox database "EXCH-MBX01\FirstStorage
    Group\FirstStorageGroup" does not exist.
    At C:\Scripts\mbstoragereport.ps1:49 char:38
    + $mailboxcount = Get-MailboxStatistics <<<< -database "$mailboxpath" |Where {

    • #27 by karlmitschke on March 23, 2010 - 17:29

      Thomas;

      I will take a look at this;

      In the mean time, does this return anything?
      Get-WMIObject Win32_NTLogEvent -ComputerName -Filter “LogFile=’Application’ AND EventCode=1221”

      Karl

      • #28 by stevos on April 20, 2010 - 07:32

        i have the same issue as thomas.

        was there a resolution to this?

      • #29 by karlmitschke on April 20, 2010 - 13:54

        No resolution yet – Can you tell me if this returns anything?
        Get-WMIObject Win32_NTLogEvent -ComputerName -Filter “LogFile=’Application’ AND EventCode=1221″

        Karl

      • #30 by stevos on April 20, 2010 - 23:43

        Get-WmiObject : Missing an argument for parameter ‘ComputerName’. Specify a par
        ameter of type ‘System.String[]’ and try again.
        At line:1 char:45
        + Get-WMIObject Win32_NTLogEvent -ComputerName <<<< -Filter "LogFile='Applicat
        ion' AND EventCode=1221"
        + CategoryInfo : InvalidArgument: (:) [Get-WmiObject], ParameterB
        indingException
        + FullyQualifiedErrorId : MissingArgument,Microsoft.PowerShell.Commands.Ge
        tWmiObjectCommand

  10. #31 by Katherine Bargas on March 22, 2010 - 21:38

    I have Exchange 2007 SP2 and loaded Powershell 2 on my server. From my server I do not get the command get-exchangewhitespace. It says this is not a recognized cmdlet. What do I need to load in order to get this command?

    • #32 by karlmitschke on March 23, 2010 - 16:35

      Katherine;

      Get-ExchangeWhiteSpace is a function at the top of the script, npt a cmdlet 🙂

  11. #33 by karlmitschke on April 20, 2010 - 17:23

    For folks who are using mountpoints, please send me email at karlmitschke at hotmail dot com, and I will send you a test script to see if we can start gathering these data.

    Thanks
    Karl

  12. #34 by stevos on April 21, 2010 - 03:44

    if i remove the computername parameter i get
    Get-WmiObject : Invalid query
    At line:1 char:14
    + Get-WMIObject <<<< Win32_NTLogEvent -Filter "LogFile='Application' AND Event
    Code=1221"
    + CategoryInfo : InvalidOperation: (:) [Get-WmiObject], Managemen
    tException
    + FullyQualifiedErrorId : GetWMIManagementException,Microsoft.PowerShell.C
    ommands.GetWmiObjectCommand

    if i reduce the filter and enter;
    [Get-WMIObject Win32_NTLogEvent – Filter "EventCode=1221"

    i get all the 1221 events scrolling past for the exchage server i am on.

  13. #35 by karlmitschke on April 21, 2010 - 14:14

    Hi – I should have specified that you need to put the name of an exchange server after -ComputerName

    Karl

    • #36 by stevos on April 21, 2010 - 22:39

      Hi Karl, yes figured that out eventually. appears to be something to do with the query though as when i reduced the filter down to just “EventCode=1221” it worked

  14. #37 by stevos on April 21, 2010 - 23:40

    if i run this;
    function Get-ExchangeWhiteSpace {

    param(
    $ComputerName = $(throw “ComputerName cannot be empty.”)
    )

    # Convert Dates to WMI CIM dates
    $tc = [System.Management.ManagementDateTimeconverter]
    $Start =$tc::ToDmtfDateTime( (Get-Date).AddDays(-1).Date )
    $End =$tc::ToDmtfDateTime( (Get-Date).Date)

    # Create two claculated properties for InsertionStrings values
    $DB = @{Name=”DB”;Expression={$_.InsertionStrings[1]}}
    $FreeMB = @{Name=”FreeMB”;Expression={[int]$_.InsertionStrings[0]}}

    Get-WMIObject Win32_NTLogEvent -ComputerName $ComputerName -Filter “LogFile=’Application’ AND EventCode=1221 AND TimeWritten>=’$Start’ AND TimeWrittenc:\whitspacetest.txt

    I get this in the text file

    ComputerName DB FreeMB
    ———— — ——
    SERVERNAME XXXXXXX Storage Group 5\Mailbox Database 5 4324
    SERVERNAME XXXXXXX Storage Group 7\Mailbox Database 7 481
    SERVERNAME XXXXXXX Storage Group 6\Mailbox Database 6 149
    SERVERNAME XXXXXXX Storage Group 8\Mailbox Database 8 128
    SERVERNAME XXXXXXX Public Folder Storage Group 2\Public Folder Database 2 7

    • #38 by stevos on April 21, 2010 - 23:45

      sorry that didn’t paste properly in the previous post – it’s basically the original script from the blog regarding whitespace. the time written line and the line i called the function from have been merged by the look of it

  15. #39 by Kirk on April 29, 2010 - 19:07

    Anybody get this to work with CCR mailbox servers running Win2008 ?
    It works fine with Win2003 CCR mailbox servers.

    On line 31: Get-Mailboxserver returns the “Network Name” cluster resource. Not the actual hostname of the active node of the cluster.
    By default In Win2008 clustering…. you cannot browse shares using the cluster resource “network name”. You have to use the actual hostname.

    This is a recommended security best practice and configured by default when you create clustered resouces.

  16. #41 by Budakkan on June 21, 2010 - 17:02

    I am with Kirk on this. CCR on Win2k8 requires you to use the hostname. Any help in this scenario would be much appreciated Karl.

  17. #42 by karlmitschke on June 25, 2010 - 18:57

    Thanks for the reminder – I will put some more time into this.

  18. #43 by karlmitschke on June 25, 2010 - 19:00

    Kirk and Budakkan;

    Can you replace the Get-MailboxServer on 31 with Get-ClusteredMailboxServer?

    • #44 by Kirk on August 6, 2010 - 15:11

      “get-clusteredmailboxserver” is not a valid command on my Exch2007 boxes.
      is that an Exch2010 command ?

      If I run “Get-ClusteredMailboxServerStatus”… it returns data.

      However, that command pukes if running it from a stand-alone Exchange server (not-CCR enabled).

      – Get-ClusteredMailboxServerStatus : Server MBX02 is not clustered. This task requires a clustered mailbox server.

      We have one utility server that is standalone where we run scheduled jobs and scripts… along with 7 CCR Win2008 production mailbox server pairs.

  19. #45 by Jack on July 21, 2010 - 00:20

    I get:
    Get-WmiObject : Invalid query
    At C:\Documents and Settings\tmc_jtucci\My Documents\Powershell\whitespace.ps1:14 char:27
    + $freespace = Get-WMIObject <<<=’$Start’ AND TimeWritten<='$End'" | Select-Object $DB,$FreeMB | Sort-Object FreeMB -Unique
    -Descending
    Exception calling "Add" with "2" argument(s): "Key cannot be null.
    Parameter name: key"
    At C:\Documents and Settings\tmc_jtucci\My Documents\Powershell\whitespace.ps1:15 char:45
    + $freespace | ForEach-Object {$whiteSpace.Add( <<<< $_.DB,$_.FreeMB)}

    When I try to run the get-whitespace function. I too can only get the filter to work if I remove everything but the EventCode=1221. Has anyone resolved this?

    Thanks,

    Jack

    • #46 by karlmitschke on July 26, 2010 - 14:10

      Jack;

      Can you change the start date as
      $Start =$tc::ToDmtfDateTime( (Get-Date).AddDays(-2).Date ) (should be line 7 in your version of the script)

      Karl

  20. #47 by Kloecker on August 5, 2010 - 10:49

    Hello,
    i get results for these commands,
    but in the script,
    the result of $MountPoint = . Get-MountPointInfo $ServerName is $null and so
    the next if sequences goes into the fault directions.

  21. #48 by Kloecker on August 5, 2010 - 11:25

    Hello,
    i think i know, where the problem on our Exchange Servers is:

    On each mountpoints, we have for each Storagegroup an own directory like M:\DB_SG06-SG10\SG08,
    but in the result of the mountpoints-query are only the path M:\DB_SG06-SG10 stored.

    How could the script changed, that this works for us too?

    Ansgar

  22. #49 by Nickb on November 17, 2010 - 13:29

    Hi-

    I am getting the following error when trying to run the script.

    The script ‘whitespace2.ps1’ cannot be run because the following snap-ins that are specified by the “#requires” statements
    of the script are missing: Microsoft.Exchange.Management.PowerShell.Admin.
    At line:1 char:2
    + . <<<< 'C:\PS1_Scripts\whitespace2.ps1'
    + CategoryInfo : ResourceUnavailable: (whitespace2.ps1:String) [], ScriptRequiresException
    + FullyQualifiedErrorId : ScriptRequiresMissingPSSnapIns

    When I try to add in the Microsoft.Exchange.Management.PowerShell.Admin snap-in it says its already there. I've updated my tools to SP3 and tried again, but to no avail.

    Can you direct me to where I may find an updated version of the snapin if I don't have it already?

    Thanks,
    Nick

    • #50 by karlmitschke on November 17, 2010 - 22:12

      Nick;

      Try removing the #requires line 😉

      Karl

  23. #51 by sam on December 18, 2010 - 19:07

    i’m still trying to fill in the blanks. My environment is currently configured as such: ccr cluster, win2008 vm servers, exchange 2007 sp2 , san fc storage. the example of my server names, storage group names and database names is as follow: servername= mail-mb-01, storage group name= sgjb01 and database name=db-01. the question is where do i fill in my relevant information to get the script to out-put Mailbox database size report? thanks!

  24. #53 by Vinod Kumar on January 19, 2011 - 06:42

    Hi ,

    i want to get report for only one exchange server , please modify and post .

    thank
    vino

    • #54 by Karl Mitschke on January 19, 2011 - 09:07

      Vino;

      Modify this line:
      foreach ($server in Get-MailboxServer)

      To:
      foreach ($server in Get-MailboxServer )

      Karl

      • #55 by Vinod Kumar on February 25, 2011 - 02:49

        Karl ,

        looks same , i am new for scripting . can you please write in details .

        thanks
        vi

  25. #56 by Alzer on February 13, 2011 - 16:32

    This script looks great… I’m very new to powershell and a ‘Junior’ exchange administrator… I’ve tinkered about with the script but I’ve not been successful. Before I post up the errors I’d like to confirm what, where and how I need to enter information, of our environment, in to the script?

    Thanks in advance

    • #57 by Karl Mitschke on August 23, 2011 - 08:28

      I cannot remember if we resolved this through email.

      If you still have issues. please let me know

  26. #58 by albertwt on February 21, 2011 - 16:49

    Thanks Karl for sharing such a great script here, however when I run it on my laptop the following columns are empty “Used Space (GB), User Mailbox Count, Total Percent Free”
    my Exchange server is CCR with 10 drives attached, while the other remaining columns were OK.

  27. #60 by Prince on January 4, 2012 - 06:38

    Hi Karl,

    This could be ery usefull for me, if you could help me to run the same in Powershell version 1

    • #61 by Karl Mitschke on January 4, 2012 - 08:24

      As far as I can see, with a quick perusal, just remove the “#requires -version 2” line 🙂

  28. #62 by Prince on January 5, 2012 - 00:46

    Hi Karl,
    Thank you so much for help, but now it is coming with the error below

    Get-WmiObject : Invalid query
    At E:\SCRP\New.ps1:27 char:27
    + $freespace = Get-WMIObject <<<=’$Start’ AN
    D TimeWritten<='$End'" | Select-Object $DB,$FreeMB | Sort-Object FreeMB -Unique
    -Descending
    Exception calling "Add" with "2" argument(s): "Key cannot be null.
    Parameter name: key"
    At E:\SCRP\New.ps1:28 char:45
    + $freespace | ForEach-Object {$whiteSpace.Add( <<<< $_.DB,$_.FreeMB)}
    Get-MailboxStatistics : Cannot bind parameter 'Database'. Cannot convert value
    "NDA-HCLIN-HT01\Program Files\Microsoft\Exchange Server\Mailbox\First Storage G
    roup\Mailbox Database" to type "Microsoft.Exchange.Configuration.Tasks.Database
    IdParameter". Error: "'NDA-HCLIN-HT01\Program Files\Microsoft\Exchange Server\M
    ailbox\First Storage Group\Mailbox Database' is not a valid value for the ident
    ity.

    Please help.

  29. #63 by Prince on January 5, 2012 - 04:09

    i am also getting the below error , even after runnig the script using domain admin user…..
    Please suggest…

    Get-WmiObject : The RPC server is unavailable. (Exception from HRESULT: 0x80070
    6BA)
    At E:\SCRP\New.ps1:27 char:27
    + $freespace = Get-WMIObject <<<=’$Start’ AN
    D TimeWritten<='$End'" | Select-Object $DB,$FreeMB | Sort-Object FreeMB -Unique
    -Descending
    Exception calling "Add" with "2" argument(s): "Key cannot be null.
    Parameter name: key"
    At E:\SCRP\New.ps1:28 char:45
    + $freespace | ForEach-Object {$whiteSpace.Add( <<<< $_.DB,$_.FreeMB)}

  30. #64 by Somtirtha Das on January 12, 2012 - 08:27

    HI Karl…are u still chekcing this post…i want a urgent help

  1. Exchange 2007 / 2010 Database Reporting Script | Unlock-PowerShell
  2. Exchange 2007 Whitespace | Tempest weblog

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: