Exchange question

Oh man! Ad-blocking software has been detected! :'(

This website is run by the community, for the community... and it needs advertisements in order to keep running. Blocking our ads means your killing our stats!
Please disable your ad-block, or become a premium member to hide all advertisements and this notice.

Question, what do you guys do to export a list of all the distribution groups in Exchange 2007? There's usually an export list option, but the version of exchange I am dealing with needs to be updated I think because it does not have Export list option.. I know there are scripts and powershell commands that can be run... I am also wondering if get-distributiongroup command in EMS would do the trick... ideal I just want to export 1000 DG's to an excel file... I can run it and pop all the DG's but can't seem to find the export to csv command... maybe I am missing something simple.

 

I'd have to check tomorrow to be sure... but I think its related to a service pack as to why I don't have the export list option in distribution groups.

 

It does not have a service pack... would explain why I am missing the option... I will have to script something I guess to get the list and update to SP2...

Edit: I was able to export the list of DG's through the exchange powershell command below:

Get-DistributionGroup -ResultSize Unlimited | export-csv dg1.csv

 

That will do part of the job, but you'll find that certain fields will contain multiple values, so a basic Get/Export won't do the trick (you may only want some basic info, in which case this won't bother you). Get-DistributionGroup also won't give you the members.

If you want to do the members as well, it's probably easiest to create multiple CSVs, something like...

Export:

$dgs = Get-DistributionGroup
foreach ($dg in $dgs){
$filename = $dg.alias+".csv"
Get-DistributionGroupMember $dg | Export-CSV $filename
}

Import:
$dgs = Get-Childitem C:\DGs\
foreach ($dg in $dgs){
$dgmembers = Import-CSV $dg
foreach ($dgmember in $dgmembers){
Add-DistributionGroupMember -identity $dg.primarysmtpaddress -member $dgmember.primarysmtpaddress
}
}

I haven't tested the above code, but I've written a similar script recently that worked (albeit a little more polished than the above example)

 

Nice! I agree with you, in this particular requirement, the user wanted just the email groups with their email address... not the individual users in them I have a powershell script that I can customize to run, similar to yours actually... I set it aside for when I really need it