Retrieve number of mailboxes per database in Exch 2010

Question

I'm attempting to build a custom PS command that will return the number of mailboxes per database in our Exchange 2010 environment. This is the script I'm using which works through Powershell

add-pssnapin Microsoft.Exchange.Management.PowerShell.E2010
(Get-MailboxDatabase) | ForEach-Object {Write-Host $_.Name (Get-Mailbox -Database $_.Name).Count}

How can I make this work through Adaxes Custom Command?

Answer 1

Michael,

The Write-Host function is not supported in Adaxes actions, however if you want to output some information, you can add a record to the Execution Log of the operation using the $Context.LogMessage method. For more information, see ExecuteScriptContext.

Here's a modified version of your script that can be used with Custom Commands, Business Rules and Scheduled Tasks using the Run a program or PowerShell script action:

add-pssnapin Microsoft.Exchange.Management.PowerShell.E2010
(Get-MailboxDatabase) | ForEach-Object {
    $message = $_.Name + ": " + (Get-Mailbox -Database $_.Name).Count
    $Context.LogMessage($message, "Information")
}

Comments

Is there anyway the output could be generated to the web interface, such as a results page or something similar?

---

Michael,

The Execution Log of the operation is displayed in the Web Interface once the operation is complete.

---

I tested and the it brought me back to Home screen with "Operation successull" displayed at the top.

What object type would my Custom Command need to be run against?

---

You should also be able to see the Execution Log below. It should look like this:

Can you post a screenshot of your Custom Command?

What object type would my Custom Command need to be run against?

It doesn't matter as the above script does not read any properties of the target object on which the Custom Command is executed.

---

I'm using the script you provided in this post as Powershell command and attempting to run in web interface

add-pssnapin Microsoft.Exchange.Management.PowerShell.E2010
(Get-MailboxDatabase) | ForEach-Object {
$message = $_.Name + ": " + (Get-Mailbox -Database $_.Name).Count
$Context.LogMessage($message, "Information")
}

---

My appologies! It is working. Ijust needed to expand the Details next to "Operation successull". Thank you very much for your assistance!