PS - Get-Mailbox, Get-DistributionGroup, Get-Recipient, Get-MailContact, SQL - SELECT MailContacts,RecipientCount,DistributionGroups,MailboxCount
Print
Created by: Carlos Zayas
Modified on: Fri, 7 Jul, 2017 at 12:46 PM
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
)
Carlos is the author of this solution article.
Did you find it helpful?
Yes
No
Send feedback Sorry we couldn't be helpful. Help us improve this article with your feedback.