Solved

How to view an email sent - recipient list

Posted on 2013-01-30
11
521 Views
Last Modified: 2013-02-04
We have a training application that can be used to draft a notificaiton and send it out to users who have valid email addresses in the company in order to inform them they have been assigned training. This morning it had an issue with users who do not have one and it was caught in a loop. I need to be able to see who actually got the training notification via their email so we can compile a new list of users who still need to know it has been assigned.
Is there a way to search for the subject and see who recieved it and export that list ?
Exchange 2010
Outlook 2007
0
Comment
Question by:CaridianBCTSA
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 6
  • 5
11 Comments
 
LVL 52

Expert Comment

by:Manpreet SIngh Khatra
ID: 38836970
Does it uses some Mailbox ?
You can check with Message Tracking in Exchange

- Rancy
0
 

Author Comment

by:CaridianBCTSA
ID: 38836991
When I try to use Tracking it wants a particular mailbox, which it actually delivered to at least 1,000. Is there a way to have it search all mailboxes ?
0
 
LVL 52

Expert Comment

by:Manpreet SIngh Khatra
ID: 38837007
Get-Mailbox | Serach-Mailbox
OR
Get-MessageTrackingLogs

- Rancy
0
Salesforce Made Easy to Use

On-screen guidance at the moment of need enables you & your employees to focus on the core, you can now boost your adoption rates swiftly and simply with one easy tool.

 

Author Comment

by:CaridianBCTSA
ID: 38837037
That definitely got me closer. I can see tons and just need to refine my parameters. I will see if I can figure out the context.
0
 
LVL 52

Expert Comment

by:Manpreet SIngh Khatra
ID: 38837061
Use Subject or Sender filter

- Rancy
0
 

Author Comment

by:CaridianBCTSA
ID: 38837090
I understand that, but I am very green when it comes to exchange powershell. I am usually quite good at picking it up but the filters got me.
0
 
LVL 52

Expert Comment

by:Manpreet SIngh Khatra
ID: 38837096
:) ....

- Rancy
0
 

Author Comment

by:CaridianBCTSA
ID: 38837128
So now that I have that part figured out how do I save it to a .csv locally to view it ?
This is what it looks like:
get-messagetrackinglog -Sender "my.user@company.com" -EventID "DELIVER" -MessageSubject "Training:  Completion Required" -Start "1/30/2013 7:00:00 AM" -End "1/30/2013 2:03:00 PM"
0
 
LVL 52

Assisted Solution

by:Manpreet SIngh Khatra
Manpreet SIngh Khatra earned 500 total points
ID: 38837135
get-messagetrackinglog -Server "mailboxserver" -MessageID "<366551554.9408.1359557718634.JavaMail.mytrainingserver`$@mytrainingserver>" -Start "1/30/2013 7:45:00 AM" -End "1/30/2013 8:05:00 AM" > C:\Tracking.csv

- Rancy
0
 

Accepted Solution

by:
CaridianBCTSA earned 0 total points
ID: 38837164
I changed it to RECIEVE and got a much better result. The .csv was pretty ugly though because it throws it all in a single column. I did notice however that my name was not listed and I know I receieved the email 11 times this morning, does it perhaps have to be run on every mailbox server ?

get-messagetrackinglog -Sender "my.user@company.com" -EventID "RECIEVE" -MessageSubject "Training:  Completion Required" -Start "1/30/2013 7:00:00 AM" -End "1/30/2013 2:03:00 PM" - ResultSize unlimited > c:\tracking.csv

I am thinking this has something to do with it ..
"WARNING: There are more results available than are currently displayed. To view them, increase the value of the
ResultSize parameter."

I added -resultsize unlimited to the end and it ran !
0
 

Author Closing Comment

by:CaridianBCTSA
ID: 38850487
I used the advice and crafted my own script.
0

Featured Post

Problems using Powershell and Active Directory?

Managing Active Directory does not always have to be complicated.  If you are spending more time trying instead of doing, then it's time to look at something else. For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article explains in simple steps how to renew expiring Exchange Server Internal Transport Certificate.
After hours on line I found a solution which pointed to the inherited Active Directory permissions . You have to give/allow permissions to the "Exchange trusted subsystem" for the user in the Active Directory...
To show how to create a transport rule in Exchange 2013. We show this process by using the Exchange Admin Center. Log into Exchange Admin Center.: First we need to log into the Exchange Admin Center. Navigate to the Mail Flow >> Rules tab.:  To cr…
To show how to generate a certificate request in Exchange 2013. We show this process by using the Exchange Admin Center. Log into Exchange Admin Center.:  First we need to log into the Exchange Admin Center. Navigate to the Servers >> Certificates…

710 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question