Список всех ящиков и групп рассылки в csv

by

Скрипт для выгрузки всех ящиков и групп рассылки в csv:

$FileExport = "c:\ab_company.csv"
$dgs = Get-DistributionGroup
$mbx = Get-Mailbox
$CSVrows = @()
foreach ($m in $mbx) {
	$CSVrows += $m | Select DisplayName, PrimarySmtpAddress, HiddenFromAddressListsEnabled
}
foreach ($dg in $dgs) {
	$CSVrows += $dg | Select DisplayName, PrimarySmtpAddress, HiddenFromAddressListsEnabled
}
$CSVrows | Export-CSV -Path $FileExport -force -NoTypeInformation -Encoding "UTF8" -Delimiter ";"

Скрипт для выгрузки состава групп рассылки:

$FileExport = "c:\dgs.csv"
$dgs = Get-DistributionGroup
$mbx = Get-Mailbox
$CSVrows = @()
foreach ($dg in $dgs) {
	Write-Host $dg.Name -fore Green
	Get-DistributionGroupMember -Identity $dg.Identity | % {
		#Write-Host "`t"$_.DisplayName"`t"$_.PrimarySmtpAddress"`t"$_.RecipientType
		$CSVrow = "" | Select DistributionGroup,DG_email,Member_DisplayName,Member_PrimarySmtpAddress,Member_RecipientType
		$CSVrow.DistributionGroup = $dg.Name
		$CSVrow.DG_email = $dg.PrimarySmtpAddress
		$CSVrow.Member_DisplayName = $_.DisplayName
		$CSVrow.Member_PrimarySmtpAddress = $_.PrimarySmtpAddress
		$CSVrow.Member_RecipientType = $_.RecipientType
		$CSVrows += $CSVrow
	}
}
$CSVrows | Export-CSV -Path $FileExport -force -NoTypeInformation -Encoding "UTF8" -Delimiter ";"
11