Solved

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

Posted on 2011-02-16
11
435 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
Too many email signature changes to deal with?

Are you constantly being asked to update your organization's email signatures? Do they take up too much of your time? Wouldn't you love to be able to manage all signatures from one central location, easily design them and deploy them quickly to users. Well, you can!

 

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

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

"Migrate" an SMTP relay receive connector to a new server using info from an old server.
Scam emails are a huge burden for many businesses. Spotting one is not always easy. Follow our tips to identify if an email you receive is a scam.
In this video we show how to create a Shared Mailbox 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 Recipients >> Sha…
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

746 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

12 Experts available now in Live!

Get 1:1 Help Now