SELECT MailContacts,RecipientCount,DistributionGroups,MailboxCount
FROM OpenExchangePSQuery(
POWERSHELL, '
$MailContacts = (Get-MailContact -ResultSize Unlimited).count
$Recipients = (Get-Recipient -Resultsize Unlimited).count
$DG = (Get-DistributionGroup -ResultSize Unlimited).count
$Mailboxes = (Get-Mailbox -ResultSize Unlimited).count
$Result = New-Object PSObject -Property @{
MailContacts = $MailContacts
RecipientCount = $Recipients
DistributionGroups = $DG
MailboxCount = $Mailboxes
}
$Result | Select MailContacts,RecipientCount,DistributionGroups,MailboxCount
', POWERSHELL
)