Link to home
Start Free TrialLog in
Avatar of amku03
amku03

asked on

Export Distirbution Lists

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
Avatar of Satya Pathak
Satya Pathak
Flag of India image

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

Avatar of amku03
amku03

ASKER

can this be rum from EMS?
Avatar of amku03

ASKER

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
Avatar of amku03

ASKER

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.


ASKER CERTIFIED SOLUTION
Avatar of endital1097
endital1097
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of amku03

ASKER

Thanks for the tip.

I further added:

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