Need to find unused distribution groups in Exchange 2010.

I use Exchange 2010. I have a large number of distribution groups created over the years. I need to find all the distribution groups that have not been used in the last 6 months and identify them and eventually delete them over time. How do I go about this?
anosh11Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
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.

MaheshArchitectCommented:
you can export message tracking logs on exchange server with RelatedRecipientAddress attribute and then compare it with all DL export list to identify if group is being used or not
Steps
http://ivan.dretvic.com/2011/10/how-to-clear-old-unused-distribution-lists-from-exchange-2010-programatically/
2

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
anosh11Author Commented:
Mahesh thank you for your response. This sounds very complicated but I will discuss it with my colleagues and get you some feedback. If there is an easier way please feel free to chime in.
0
MaheshArchitectCommented:
This is most clear article I had came across in this subject
The process has no other alternatives exchange don't have any built-in logic to do what you are asking for
You can make recommendations to Microsoft to include statistical reports like above as out of box feature
0
anosh11Author Commented:
The solution provided by Mahesh above is very efficient but you need to be hands on in Exchange Power shell. There are also 3rd party exchange reporting tools that can be bought that pull the reports for you once the exchange logs are adjusted. Also, a manual way to do this would be to pull reports from your email relay service about groups that have not been used in the last 6 months individually which would get the job done provided you have a few groups.
0
MaheshArchitectCommented:
Agreed Anosh
This will be possible with 3rd party tools most probably, however as exchange admin the free method above should not be an issue
probably your exchange admin can follow that
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.