SELECT Name,Count
FROM OpenExchangePSQuery(
    POWERSHELL, '
   
$distlist = Get-DistributionGroup -resultsize unlimited
Foreach ($dl in $distlist)
{
$name = $dl.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
)