How to Audit who sends to a Distribution Group
We have the need to clean up the Distribution lists in our GAL. Is there a way in Exchange Server 2007 SP1 Rollup 9 where we can monitor what distribution lists are being used? We would like to disable any distribution lists that have not been used for more than 30 days.
November 30th, 2009 10:58pm
Using Message Tracking is probably the most effective in this case:http://technet.microsoft.com/en-us/library/bb124375.aspx
Managing Message Tracking
http://technet.microsoft.com/en-us/library/bb124926.aspx
How to Search Message Tracking Logs
Free Windows Admin Tool Kit Click here and download it now
November 30th, 2009 11:01pm
I use this powershell command to look at the message tracking logs:get-transportserver | get-messagetrackinglog -start 4/1/2009 -end 4/30/2009 -EventID Expand -ResultSize Unlimited | group-object RelatedRecipientAddress | sort Name | ft Name,Count -Autosize > c:\temp\4_2009.txtJust change the -start and -end dates, and the name of the text file you put the output to.
December 1st, 2009 12:03am
Thank you, I modified your script to search all hub transport servers. Thanks again.
Get-ExchangeServer | where {$_.isHubTransportServer -eq $true -or $_.isMailboxServer -eq $true} | get-messagetrackinglog -start 11/1/2009 -end 11/30/2009 -EventID Expand -ResultSize Unlimited | group-object RelatedRecipientAddress | sort Name | ft Name,Count -Autosize > c:\temp\11_1.txt
Free Windows Admin Tool Kit Click here and download it now
December 1st, 2009 12:30am