get-Messagetrackinglog script

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
LVL 7
Kamalasekar ParthasarathyMessaging SupportAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Meir RivkinFull stack Software EngineerCommented:
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
Kamalasekar ParthasarathyMessaging SupportAuthor Commented:
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
Meir RivkinFull stack Software EngineerCommented:
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Kamalasekar ParthasarathyMessaging SupportAuthor Commented:
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
Kamalasekar ParthasarathyMessaging SupportAuthor Commented:
partial
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Exchange

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.