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
Is there a way to export the names of all distribution lists, probably with owner details??
Thanks
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,Displ ayName | Export-Csv c:\groups.csv
Get-QADGroup -GroupType Distribution | Get-QADUser $_.ManagedBy | Select SamAccountName,Email,Displ
ASKER
can this be rum from EMS?
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?
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
get-distributiongroup -managedby | export-csv c:\groups.csv
ASKER
iEndital,
I ran the script, it says:
Get-DistributionGroup : Missing an argument for parameter 'ManagedBy'. Specify a parameter of type 'Microsoft.Exchange.Config uration.Ta sks.Genera lRecipient IdParamete r' and try again.
I am looking to export all DL names and if possible to include DL owner name.
I ran the script, it says:
Get-DistributionGroup : Missing an argument for parameter 'ManagedBy'. Specify a parameter of type 'Microsoft.Exchange.Config
I am looking to export all DL names and if possible to include DL owner name.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks for the tip.
I further added:
get-distributiongroup | select name,primarysmtpaddress,gr ouptype,ma nagedby | export-csv c:\groups.csv
I further added:
get-distributiongroup | select name,primarysmtpaddress,gr
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