?
Solved

List of users who recieved and email sent by external email

Posted on 2013-12-10
3
Medium Priority
?
262 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:Ahmad Al Raeesi
[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
3 Comments
 
LVL 35

Accepted Solution

by:
Joseph Daly earned 800 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 1200 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:Ahmad Al Raeesi
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

Has Powershell sent you back into the Stone Age?

If managing Active Directory using Windows Powershell® is making you feel like you stepped back in time, you are not alone.  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

Find out what you should include to make the best professional email signature for your organization.
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…
In this video we show how to create a Contact 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 Recipients >> Contact ta…
This video demonstrates how to sync Microsoft Exchange Public Folders with smartphones using CodeTwo Exchange Sync and Exchange ActiveSync. To learn more about CodeTwo Exchange Sync and download the free trial, go to: http://www.codetwo.com/excha…
Suggested Courses

800 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