?
Solved

get-Messagetrackinglog script

Posted on 2012-03-28
5
Medium Priority
?
2,056 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
  • 3
  • 2
5 Comments
 
LVL 42

Assisted Solution

by:Meir Rivkin
Meir Rivkin earned 1500 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:Kamalasekar Parthasarathy
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:
Meir Rivkin earned 1500 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:Kamalasekar Parthasarathy
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:Kamalasekar Parthasarathy
ID: 37854516
partial
0

Featured Post

Will You Be GDPR Compliant by 5/28/2018?

GDPR? That's a regulation for the European Union. But, if you collect data from customers or employees within the EU, then you need to know about GDPR and make sure your organization is compliant by May 2018. Check out our preparation checklist to make sure you're on track today!

Question has a verified solution.

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

There are literally thousands of Exchange recovery applications out there. So how do you end up picking one that’s ideal for your business & purpose? By carefully scouting the product’s features, the benefits it offers you, & reading ample reviews f…
There’s hardly a doubt that Business Communication is indispensable for both enterprises and small businesses, and if there is an email system outage owing to Exchange server failure, it definitely results in loss of productivity.
To add imagery to an HTML email signature, you have two options available to you. You can either add a logo/image by embedding it directly into the signature or hosting it externally and linking to it. The vast majority of email clients display l…
Planning to migrate your EDB file(s) to a new or an existing Outlook PST file? This video will guide you how to convert EDB file(s) to PST. Besides this, it also describes, how one can easily search any item(s) from multiple folders or mailboxes…

601 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