Solved

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

Posted on 2011-02-16
11
436 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
  • 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 41

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 41

Expert Comment

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

http://www.systemtools.com/hyena/index.html
0
 

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 41

Accepted Solution

by:
Amit earned 500 total points
ID: 34919096
0
Are your AD admin tools letting you down?

Managing Active Directory can get complicated.  Often, the native tools for managing AD are just not up to the task.  The largest Active Directory installations in the world have relied on one tool to manage their day-to-day administration tasks: Hyena. Start your trial today.

 

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 41

Expert Comment

by:Amit
ID: 34928240
0
 
LVL 41

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 41

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

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
exchange 2010 to 2016 migration using "old name" 2 43
Outlook Calendar Permissions 4 39
Export user type with mailbox size 41 53
exchange, outlook 2 26
Following basic email etiquette rules will help you write a professional email and achieve a good, lasting impression with your contacts.
Find out what you should include to make the best professional email signature for your organization.
The video tutorial explains the basics of the Exchange server Database Availability groups. The components of this video include: 1. Automatic Failover 2. Failover Clustering 3. Active Manager
This video discusses moving either the default database or any database to a new volume.

914 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

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now