Link to home
Start Free TrialLog in
Avatar of alopez2
alopez2

asked on

Exchange 2013 Reporting Challenge

There is an application in the environment that sends out a thousand messages each month via SMTP on a scheduled date and time.  I have been asked to verify that every message has arrived and been processed successfully by the Exchange servers (the SMTP server has, in the past, encountered issues forwarding mail).

Is there a log file on the Exchange servers somewhere that contains metadata information that I can query via PowerShell?

I don't want to check every mailbox in the environment to see if it contains a specifically worded message, since that message can be deleted by the recipient upon arrival -- not to mention the time and resource utilization that would be required.  

Any thoughts or suggestions on how to make this happen?
ASKER CERTIFIED SOLUTION
Avatar of Adam the 32-bit Aardvark
Adam the 32-bit Aardvark
Flag of Poland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of alopez2
alopez2

ASKER

Very nice PowerShell command.  Thank you.

Is there a way to get a list of the users who received a specific message?  

Something to the effect of:

Get-MessageTrackingLog -ResultSize unllimited -Sender <name of sender here> -SubjectContains <Some text here that's in the subject line> -EventID <Success, or something to the effect, to get successful deliveries>
Avatar of alopez2

ASKER

You're got me real close, CodeTwo.

By removing the Event ID parameter, I can get a list of all the messages that were sent from the specified sender.

Is there a way to only retrieve messages with specific words in the Subject?  Or to specify the date range to pull the messages from?

Than you!  I'll keep looking to see if I can answer my own question.  Will post for other's future reference if I do find the correct syntax.
Avatar of alopez2

ASKER

Found it!  Thank you for getting me going in the right direction CodeTwo.

The syntax, which includes start and end date and time, is here:  https://technet.microsoft.com/en-us/library/aa997573(v=exchg.160).aspx
Avatar of alopez2

ASKER

Great work.  Thanks.