Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

How to view an email sent - recipient list

Posted on 2013-01-30
11
Medium Priority
?
531 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
  • 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
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

 

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 2000 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

Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

Question has a verified solution.

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

The core idea of this article is to make you acquainted with the best way in which you can export Exchange mailbox to PST format.
As much as Microsoft wants to kill off PST file support, just as they tried to do with public folders, there are still times when it is useful or downright necessary to export Exchange mailboxes to PST files. Thankfully, it is still possible to e…
In this video we show how to create a Resource Mailbox in Exchange 2013. We show this process by using the Exchange Admin Center. Log into Exchange Admin Center.: Navigate to the Recipients >> Resources tab.: "Recipients" is our default selection …
This video discusses moving either the default database or any database to a new volume.
Suggested Courses

916 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