Solved

Message tracking Exchange 2007 - Distribution groups

Posted on 2010-08-31
4
906 Views
Last Modified: 2012-05-10
Hi,

I need to report how many messages (total numer of messages and size in Mb's) were received by exchange distribution groups.
I wrote some powershell script which counts only total messages sent to a distr. groups but i don't know how to add to the script info about total messages in Mb's.

Plese help.
Thanks in advance!
Get-TransportServer | foreach {get-messagetrackinglog -resultsize unlimited -server $_.Identity -start "2010-08-01 00:01" -end "2010-08-31 23:59" -EventId Expand | group-object RelatedRecipientAddress | select Name,Count} | export-csv c:\Exchange_Message_tracking_Distr_Groups.csv

Open in new window

0
Comment
Question by:pi01162
  • 3
4 Comments
 
LVL 13

Expert Comment

by:soostibi
ID: 33567260
This gives a new column TotalMBs.
Get-TransportServer |
	foreach {get-messagetrackinglog -resultsize unlimited -server $_.identity -start "2010-08-01 00:01" -end "2010-08-31 23:59" -EventId Expand | 
		Group-Object RelatedRecipientAddress | Select-Object Name, Count, 
			@{n="totalMBs"; e={[int] (($_.group | Measure-Object -Property totalbytes -Sum).sum/1mb)}}
	}

Open in new window

0
 
LVL 13

Expert Comment

by:soostibi
ID: 33567367
This is even simpler:
Get-TransportServer | ?{$_.name -eq "iqjb-exchback"} |
	get-messagetrackinglog -resultsize unlimited -start "2010-08-01 00:01" -end "2010-08-31 23:59" -EventId Expand | 
		Group-Object RelatedRecipientAddress | Select-Object Name, Count, 
			@{n="totalMBs"; e={[int] (($_.group | Measure-Object -Property totalbytes -Sum).sum/1mb)}}

Open in new window

0
 
LVL 13

Accepted Solution

by:
soostibi earned 500 total points
ID: 33567376
Sorry, this is it:
Get-TransportServer | 
	get-messagetrackinglog -resultsize unlimited -start "2010-08-01 00:01" -end "2010-08-31 23:59" -EventId Expand | 
		Group-Object RelatedRecipientAddress | Select-Object Name, Count, 
			@{n="totalMBs"; e={[int] (($_.group | Measure-Object -Property totalbytes -Sum).sum/1mb)}}

Open in new window

0
 

Author Closing Comment

by:pi01162
ID: 33574734
Thanks!
0

Featured Post

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

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

Microsoft Windows Server Update Service (WSUS) is free for everyone, but it lacks of some desirable features like send an e-mail to the administrator with the status of all computers on the WSUS server. This article is based on my PowerShell script …
"Migrate" an SMTP relay receive connector to a new server using info from an old server.
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.
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…

776 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