exchange 2010 distribution list report

[jd20075]

Hi All,

 

I currently have exchange 2010 and am planning some house keeping on the server, is there away where i can create a report of all distribution list on my exchange 2010 server and and export to csv or txt file so i will end up with a complete list of DL and it's members

 

Thanks in Advance

[jd20075]

Any ideas people

[morganw]

Powershell is usually the best way:

 

$file = "C:\output.csv"
$groups = Get-DistributionGroup

echo "Distribution Group,Display Name,Alias,E-Mail address" | out-file -Encoding ascii $file

foreach ($group in $groups) {
$groupmembers = Get-DistributionGroupMember $group
foreach ($groupmember in $groupmembers) {
	$displayname = $groupmember.displayname
	$alias = $groupmember.alias
	$email = $groupmember.primarysmtpaddress
	echo "$group,$displayname,$alias,$email" | out-file -Encoding ascii -Append $file
}
}