SELECT Name,Count

FROM OpenExchangePSQuery(

    POWERSHELL, '

   

$maillist = Get-Mailbox ReplaceWithServerName



Foreach ($mbx in $maillist)

{

$name = $mbx.PrimarySmtpAddress;


$messages = Get-MessageTrackingLog -resultsize unlimited -start (get-date).adddays(-1) -end (get-date) | where {$_.recipients -icontains "$name"}


$Result = New-Object PSObject -Property @{

Name = $name

Count = $messages.count

}
$Result | Select name,count


}
              ', POWERSHELL
)