Hi

I  have scheduled a report generation mechanism on a dailiy basis with the below command

Get-MessageTrackingLog -ResultSize Unlimited | Group-Object -Property:EventId | Sort-Object Count -Desc | Select Name,Count

The result of this query is displayed as below .

Name        Count
----        -----
RECEIVE     58679
DELIVER     47496
NOTIFYMAPI  20812
SUBMIT      20806
SEND        19863
RESUBMIT     8679
HAREDIRECT   6826
TRANSFER      351
DSN            96
FAIL           95
SUBMITDEFER     6
BADMAIL         2

Now My Boss wants only the report of SEND and the FAIL count ..How can I do this ..Can any one help p

Hi,

Here you are:

Get-MessageTrackingLog -ResultSize Unlimited | where-object {$_.EventID -eq "SEND" -or $_.EventID -eq "FAIL"} | Group-Object -Property:EventId | Sort-Object Count -Desc | Select Name,Count

Best Regards.

• Edited by Lynn-Li 9 hours 11 minutes ago

Hi,

Here you are:

Get-MessageTrackingLog -ResultSize Unlimited | where-object {$_.EventID -eq "SEND" -or $_.EventID -eq "FAIL"} | Group-Object -Property:EventId | Sort-Object Count -Desc | Select Name,Count

Best Regards.

• Edited by Lynn-Li Thursday, February 12, 2015 2:39 AM
• Marked as answer by Shivaprasad Ariga Sunday, February 15, 2015 8:14 AM

Thank you ...That helped me!

Just another query can we change the following fields in blue to the ones in yellow  is "receive" should be renamed as Generated in the report ..is it possible?

RECEIVE	Generated
SEND	Send Externally
DELIVER	Send Internally- Staff
FAIL	FAIL