PS - Get-MessageTrackingLog,Get-Mailbox, SELECT DisplayName,EmailAdress,LastMessageSent
Print
Created by: Carlos Zayas
Modified on: Thu, 29 Jun, 2017 at 7:01 PM
SELECT DisplayName,EmailAddress,LastMessageSent
FROM OpenExchangePSQuery(
POWERSHELL, '
$Mailboxes=Get-Mailbox -ResultSize Unlimited | Where {$_.RecipientTypeDetails -eq "UserMailbox"}
foreach ($m in $mailboxes)
{
$name=$m.name
$emailaddress=$m.primarysmtpaddress
$messagesSent=Get-MessageTrackingLog -EventId "Send" -ResultSize Unlimited -Start (Get-Date).AddDays(-3) | Where {$_.Sender -icontains "$emailaddress"} | Sort timestamp -desc | select -First 1
foreach ($message in $messagesSent)
{$Result = New-Object PSObject -Property @{
DisplayName = $name
EmailAddress = $emailaddress
LastMessageSent = $message.timestamp
}
$Result | Select DisplayName,EmailAddress,LastMessageSent
}
}
', 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.