Solved

List of users who recieved and email sent by external email

Posted on 2013-12-10
3
257 Views
Last Modified: 2013-12-10
I would to know how can I get list of internal users who received an email from external party. I used the Discovery account but that was not accurate. If there is anyway using PowerShell to this then export the result to csv file.??
0
Comment
Question by:alraisi0
3 Comments
 
LVL 35

Accepted Solution

by:
Joseph Daly earned 200 total points
ID: 39709834
If you have message tracking logs enabled. You could use the following.

get-messagetrackinglog -server Casservername(s) -sender sender@domain.com -start "12/10/2013 00:00:01" -end "12/10/2013 23:59:59" -eventid deliver

Basically change the command above replacing the name of your cas server and date/times the emails came. This will show you who got it.

http://technet.microsoft.com/en-us/library/aa997573%28v=exchg.141%29.aspx
0
 
LVL 53

Assisted Solution

by:Will Szymkowski
Will Szymkowski earned 300 total points
ID: 39709895
You can use Message Tracking Cmdlet to accomplish this... Use the below script.

Get-MessageTrackingLog -Server <HTServername> -Start "12/10/2013 1:00AM" -End "12/10/2013 4:00PM" -ResultSize "Unlimited" | ? {$_.Sender -notlike "*@yourodmain.com"} | Select EventID, Source, Sender, Recipients | Export-CSV "c:\ExternalSenders.csv"

Open in new window


- Replace HTServername with the Hub Transport Server in your Exchange enviornment
- "*@yourdomain.com" change this to your FQDN mailing domain

*remember that you can only go back in time based on what you have setup on your Hub Transport server. I believe by default it is 30 days.

The script above will get all mail items from everything except your for domain between the hours of 1:00AM and 4:00PM for today. it will then export the results to a CSV file called ExternalSenders.csv. You can change the date/time vaules to accomodate your query.

Will.
0
 

Author Closing Comment

by:alraisi0
ID: 39710668
This Exactly what I was looking for I hope that I spread the point fairly since I really was looking to export the result in CSV format. that's why I gave Spec01 more. Thanks Guys
0

Featured Post

Are your AD admin tools letting you down?

Managing Active Directory can get complicated.  Often, the native tools for managing AD are just not up to the task.  The largest Active Directory installations in the world have relied on one tool to manage their day-to-day administration tasks: Hyena. Start your trial today.

Question has a verified solution.

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

Marketers need statistics and metrics like everybody else needs oxygen. In this article we explain how to enable marketing campaign statistics for Microsoft Exchange mail.
This article explains how to install and use the NTBackup utility that comes with Windows Server.
In this video we show how to create a mailbox database 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 >> Data‚Ķ
The video tutorial explains the basics of the Exchange server Database Availability groups. The components of this video include: 1. Automatic Failover 2. Failover Clustering 3. Active Manager

829 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