SELECT Name,LastMessageReceived
FROM OpenExchangePSQuery(
    POWERSHELL, '
    $distlist = Get-DistributionGroup -resultsize unlimited

Foreach ($dl in $distlist)
{
$name = $dl.PrimarySmtpAddress

$messages = Get-MessageTrackingLog -EventId Receive -ResultSize Unlimited -Start(Get-Date).AddDays(-5) -End (Get-Date) | Where {$_.Recipients -icontains "$name"} | Sort timestamp   -desc | select -First 1

foreach ($m in $messages)
{
$Result = New-Object PSObject -Property @{
Name = $name
LastMessageReceived = $m.timestamp
}
$Result | Select name,lastmessagereceived
}
}

              ', POWERSHELL
)