Solved

get-Messagetrackinglog script

Posted on 2012-03-28
5
1,856 Views
Last Modified: 2012-04-16
Hi Team,

I need to know the script which will give the Mailflow for the month in our exchange servers.
I have edge server and need to track the mailflow based on the Sender ip and i need specifically counts.

Like this how many numbers are from this specific sender id and i need each count of the senderip or client ip.

The below command i tried to get for one day but not able to get the counts of each senderemailaddress or sender id. Kindly suggest

get-messagetrackinglog -start "03/26/2012 00:00:01" -end "03/26/2012 23:59:59" -eventid "receive" -resultsize unlimited | Export-Csv
0
Comment
Question by:sekar_raj32
  • 3
  • 2
5 Comments
 
LVL 42

Assisted Solution

by:sedgwick
sedgwick earned 500 total points
ID: 37780691
do u have sender email/username?

try the following (replace "sender@domaincom"):

Get-MessageTrackingLog -start "03/26/2012 00:00:01" -end "03/26/2012 23:59:59" -Sender "sender@domaincom"
0
 
LVL 7

Author Comment

by:sekar_raj32
ID: 37781684
Let me explain clearly.

If i run the command it will give all the details like, sender id, client id and etc..


But i want to count the senderid and client id. For ex

If i get the report as

a@test.com
b@test.com
c@test.com
a@test.com

for this i need the count like

a@test.com = 2
b@test.com = 1
c@test.com = 1

Like this i need to get a count details based on senderid or client ip

Thanks
0
 
LVL 42

Accepted Solution

by:
sedgwick earned 500 total points
ID: 37782110
the following code will group all results by senderid (you can choose to group them by clientid instead).

run this code and post the output and we'll keep from there to export the reault to csv.

get-messagetrackinglog -start "03/26/2012 00:00:01" -end "03/26/2012 23:59:59" -eventid "receive" -resultsize unlimited | Group-Object senderid

Open in new window

0
 
LVL 7

Author Comment

by:sekar_raj32
ID: 37790025
When i run the command, it is just giving total number of counts but in need to get individually..

#TYPE Microsoft.PowerShell.Commands.GroupInfo
"Values","Count","Group","Name"
"System.Collections.ArrayList","4530","System.Collections.ObjectModel.Collection`1[System.Management.Automation.PSObject]",""
0
 
LVL 7

Author Closing Comment

by:sekar_raj32
ID: 37854516
partial
0

Featured Post

Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

Join & Write a Comment

Find out how to use Active Directory data for email signature management in Microsoft Exchange and Office 365.
Scam emails are a huge burden for many businesses. Spotting one is not always easy. Follow our tips to identify if an email you receive is a scam.
In this video we show how to create an Address List 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 Organization >> Ad…
In this video we show how to create an Accepted Domain 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 >> Ac…

758 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

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now