?
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
?
443 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
NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

 

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

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.

Question has a verified solution.

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

This article explains how to install and use the NTBackup utility that comes with Windows Server.
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.
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…
To show how to create a transport rule 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 >> Rules tab.:  To cr…
Suggested Courses

762 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