Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

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

Posted on 2011-02-16
11
Medium Priority
?
444 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 44

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 44

Expert Comment

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

http://www.systemtools.com/hyena/index.html
0
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 

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 44

Accepted Solution

by:
Amit earned 1500 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 44

Expert Comment

by:Amit
ID: 34928240
0
 
LVL 44

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 44

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

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

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

Know the reasons and solutions to move/import EDB to New Exchange Server. Also, find out how to recover an Exchange .edb file and to restore the file back.
With so many activities to perform, Exchange administrators are always busy in organizations. If everything, including Exchange Servers, Outlook clients, and Office 365 accounts work without any issues, they can sit and relax. But unfortunately, it…
In this video we show how to create an Accepted Domain in Exchange 2013. We show this process by using the Exchange Admin Center. Log into Exchange Admin Center.: First we need to log into the Exchange Admin Center. Navigate to the Mail Flow >> Ac…
In this video we show how to create a mailbox database in Exchange 2013. We show this process by using the Exchange Admin Center. Log into Exchange Admin Center.: First we need to log into the Exchange Admin Center. Navigate to the Servers >> Data…
Suggested Courses

604 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