I have a request from a user who wants to get some stats from the Exchange App around specific users. Namely they're looking for a count of incoming and outgoing messages. There's a macro in the Exchange Application that would do what I need. Unfortunately, I would have to run it each time for each user they want to report on. I was attempting to do something almost like a loop, passing the value from the csv lookup as an argument to the macro. Is this possible? Brian ... View more

I'm getting a bunch of powershell errors with the exchange app (mainly around the Mailbox Store). This is on Exchange 2007 that hosts the public folders - really need to get this resolved as I've got high demand for this information. get-publicfolderstats.ps1: Exchange server "PWEXCHPUB01" was not found. Please make sure you have typed it correctly. At C:\Program Files\SplunkUniversalForwarder\etc\apps\TA-Exchange-2007-MailboxStore\bin\powershell\get-publicfolderstats.ps1:40 char:36 + $dblist = (Get-PublicFolderDatabase <<<< -server $env:ComputerName -Status|Where-Object { $_.Mounted -eq "True" }) Get-PublicFolderStatistics : A parameter cannot be found that matches parameter name 'ResultSize'. At C:\Program Files\SplunkUniversalForwarder\etc\apps\TA-Exchange-2007-MailboxStore\bin\powershell\get-publicfolderstats.ps1:47 char:61 + Foreach ($folder in (Get-PublicFolderStatistics -ResultSize <<<< Unlimited | Where-Object { $_.DatabaseName -eq $db.Name })) { get-hoststats.ps1: New-Object : Cannot find type [Collections.Generic.List[string]]: make sure the assembly containing this type is loaded. At C:\Program Files\SplunkUniversalForwarder\etc\apps\TA-Exchange-2007-MailboxStore\bin\powershell\get-hoststats.ps1:31 char:31 + $ServicesRunning = New-Object <<<< Collections.Generic.List[string] New-Object : Cannot find type [Collections.Generic.List[string]]: make sure the assembly containing this type is loaded. At C:\Program Files\SplunkUniversalForwarder\etc\apps\TA-Exchange-2007-MailboxStore\bin\powershell\get-hoststats.ps1:32 char:34 + $ServicesNotRunning = New-Object <<<< Collections.Generic.List[string] You cannot call a method on a null-valued expression. At C:\Program Files\SplunkUniversalForwarder\etc\apps\TA-Exchange-2007-MailboxStore\bin\powershell\get-hoststats.ps1:38 char:24 + $ServicesRunning.Add( <<<< $proc) You cannot call a method on a null-valued expression. At C:\Program Files\SplunkUniversalForwarder\etc\apps\TA-Exchange-2007-MailboxStore\bin\powershell\get-hoststats.ps1:38 char:24 + $ServicesRunning.Add( <<<< $proc) get-databasestats.ps1 The term 'Get-Counter' is not recognized as a cmdlet, function, operable program, or script file. Verify the term and try again. At C:\Program Files\SplunkUniversalForwarder\etc\apps\TA-Exchange-2007-MailboxStore\bin\powershell\get-databasestats.ps1:12 char:14 + (Get-Counter <<<< "\LogicalDisk($Drive)\% Free Space").CounterSamples[0] .CookedValue ... View more