Solved

List of users who recieved and email sent by external email

Posted on 2013-12-10
3
256 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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

Exchange server is not supported in any cloud-hosted platform (other than Azure with Azure Premium Storage).
This article lists the top 5 free OST to PST Converter Tools. These tools save a lot of time for users when they want to convert OST to PST after their exchange server is no longer available or some other critical issue with exchange server or impor…
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

785 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