Solved

Easy (I mean easy) way to export mail enabled Exchange (2003) Distribution Lists (DL) with required information

Posted on 2011-02-16
11
442 Views
Last Modified: 2012-08-13
I need a way (trialed Quest and Power Tools with little success) to simply run down a forest, grab every mail enabled DL, output the membership lists which include usernames and alias + email address, even if a DL is made from 5 other DL's (if it is the sub-DL's would opviously be reported again as a DL's farther down the list) to a file (CSV). After searching all the solutions, there is no easy nor is there a consistent reply to extract the information. I want to run this from Exchange or DC server (not Outlook one by one DL export).
0
Comment
Question by:Outsourced2Coud
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 6
  • 4
11 Comments
 
LVL 26

Expert Comment

by:e_aravind
ID: 34918514
IMO, there is no easy way to get the data.

One tool which i would recollect is memberof
http://www.windowsitpro.com/article/tips/jsi-tip-5871-freeware-memberof-utility-.aspx

> Need to double-check and work on the other few lines to get the CSV output
0
 
LVL 43

Expert Comment

by:Amit
ID: 34918572
Login to your Exchange server.
Goto Run>Type dsa.msc hit enter
You will see a Saved Queries Icon
Right Click on that and select New>Query
Give the Name like Mailenable DL
Click on Define Query
Under Find> Select Exchange Recipients and select Mail-Enabled Groups
Uncheck others
Click Ok twice
Click on Action Menu and select Refresh. Right hand side you have the results
Now Goto View and click Add/Remove Column and customise the view more
Right click on the created query and export the results to .csv

Hope this helps
0
 
LVL 43

Expert Comment

by:Amit
ID: 34918602
If you can buy a tool look for Hyena

http://www.systemtools.com/hyena/index.html
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

Author Comment

by:Outsourced2Coud
ID: 34918992
Ik, thanks I'll review these options. I'm not adverse to buying a tool if it can do what is required, the other options, the scripts seem limited. Power GUI with Powershell is close but still missing.
0
 
LVL 43

Accepted Solution

by:
Amit earned 500 total points
ID: 34919096
0
 

Author Comment

by:Outsourced2Coud
ID: 34920867
Thanks 'amitkulshrestha', I get the ist of mailenabled DL's and their email addresses, no members though. Half there, of all the tools, even the ARKES (Exchange Server edition), not one of these can do this task, they all seem to come up short.
0
 
LVL 43

Expert Comment

by:Amit
ID: 34928240
0
 
LVL 43

Expert Comment

by:Amit
ID: 34928271
You can play with two tools at http://joeware.net/freetools/

ADFIND and MEMBER Of
0
 

Author Comment

by:Outsourced2Coud
ID: 34928704
No, two parts of my question, I need the email addresses of the members, be it a domain member of a contact. It has to scour the entire forest, cover all DL's or Security groups that also double as a DL (mail enabled), hence those LDIF and the membo of etc, do not do it.
0
 
LVL 43

Expert Comment

by:Amit
ID: 34928798
Let me see if i can write a script for this...No commitment right now.
0
 

Author Closing Comment

by:Outsourced2Coud
ID: 34948732
The is a Admin Reprting Kir for Exchange which is actually much better and has the reports I need. It is a pay solution but the ability I can get with it and ease of use works for me.
0

Featured Post

Edgartown IT Case Study

Learn about Edgartown's quest to ensure the safety and security of the entire town's employee and citizen data. Read the case study!

Question has a verified solution.

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

MS Outlook is a world-class email client application that is mainly used for e-communication globally.  In this article, we will discuss the basic idea about MS Outlook, its advanced features, and types of MS Outlook File formats.
There are times when we need to generate a report on the inbox rules, where users have set up forwarding externally in their mailbox. In this article, I will be sharing a script I wrote to generate the report in CSV format.
how to add IIS SMTP to handle application/Scanner relays into office 365.
This video discusses moving either the default database or any database to a new volume.

717 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