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?
PowershellExchangeEmail Protocols

Avatar of undefined
Last Comment
alopez2

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Adam the 32-bit Aardvark

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
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>
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.
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
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck
alopez2

ASKER
Great work.  Thanks.