SELECT DisplayName,EmailAddress,LastMessageReceived
FROM OpenExchangePSQuery(
    POWERSHELL, '
$Mailboxes=Get-Mailbox -ResultSize Unlimited | Where {$_.RecipientTypeDetails -eq "UserMailbox"}


foreach ($m in $mailboxes)
{


$name=$m.name


$emailaddress=$m.primarysmtpaddress


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


foreach ($message in $messagesreceived)


{


$Result = New-Object PSObject -Property @{
DisplayName = $name
EmailAddress = $emailaddress
LastMessageReceived = $message.timestamp}$Result | Select DisplayName,EmailAddress,LastMessageReceived


}


}
              ', POWERSHELL
)