We help IT Professionals succeed at work.

Export Distirbution Lists

amku03
amku03 used Ask the Experts™
on
Hi need to get the details of all the Distribution Lists  we have in exchange.
Is there a way to export the names of all distribution lists, probably with owner details??

Thanks
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Satya PathakLead Technical Consultant

Commented:
How to export members of an Exchange distribution group to a text file.
Reff:
http://support.microsoft.com/kb/555937

If you are using Exchange 2007.

reff:
http://www.ucblogs.net/blogs/exchange/archive/2008/07/03/Exporting-distribution-list-membership-to-Excel.aspx
install powershell and the quest ActiveRoles management shell for active directory if you have exchange 2003

Get-QADGroup -GroupType Distribution | Get-QADUser $_.ManagedBy | Select SamAccountName,Email,DisplayName | Export-Csv c:\groups.csv

Author

Commented:
can this be rum from EMS?

Author

Commented:
Just to add: We have Exchange 2007 SP1
So to rephrase, do I need to install Quest tool on exchange box or on DC?
no, you could just run
get-distributiongroup -managedby | export-csv c:\groups.csv

Author

Commented:
iEndital,
I ran the script, it says:

Get-DistributionGroup : Missing an argument for parameter 'ManagedBy'. Specify a parameter of type 'Microsoft.Exchange.Configuration.Tasks.GeneralRecipientIdParameter' and try again.



I am looking to export all DL names and if possible to include DL owner name.


caught me sleeping

get-distributiongroup | select name,managedby

Author

Commented:
Thanks for the tip.

I further added:

get-distributiongroup | select name,primarysmtpaddress,grouptype,managedby  | export-csv c:\groups.csv