PS - Get-MessageTrackingLog, SELECT Timestamp,MessageID,Sender,Recipients,RecipientCount : Support Portal

PS - Get-MessageTrackingLog, SELECT Timestamp,MessageID,Sender,Recipients,RecipientCount Print

Created by: Carlos Zayas

Modified on: Thu, 29 Jun, 2017 at 3:04 PM

SELECT Timestamp,MessageID,Sender,Recipients,RecipientCount
FROM OpenExchangePSQuery(
POWERSHELL, '
Get-MessageTrackingLog -ResultSize unlimited -Start (Get-Date).AddDays(-30) -End (Get-Date) | where { $_.sender -notmatch 'SystemMailbox.*' -and $_.sender -notmatch 'MicrosoftExchange.*' } | select Timestamp,@{Name="messageid"; Expression={$_.messageid -replace "<", "" -replace ">", ""} },sender,@{Name="recipients"; Expression={$_.recipients -join "," } },@{Name="recipientcount"; Expression={$_.recipients.Count} }

', POWERSHELL
)

Carlos is the author of this solution article.

Did you find it helpful? Yes No

How can we help you today?

PS - Get-MessageTrackingLog, SELECT Timestamp,MessageID,Sender,Recipients,RecipientCount Print

Related Articles