# Exchange management Shell Connect #

. 'D:\Exchange Server\V15\bin\RemoteExchange.ps1'

Connect-ExchangeServer -auto 

$StartDay = (Get-Date).AddDays(-7).ToString("yyyy-MM-dd")

$EndDay = (Get-Date)

$EndDayprint = (Get-Date).AddDays(-1).ToString("yyyy-MM-dd")

$Path = "C:\Work\Scripts\DLReceive\Export"

get-exchangeserver | Get-MessageTrackingLog -start $StartDay -End $EndDay.ToString("yyyy-MM-dd") -ResultSize unlimited -eventid `

expand | select Timestamp,RelatedRecipientAddress,Sender,MessageSubject | export-csv -Encoding UTF8 -Path $Path\DLReceive_$StartDay"_"$EndDayprint.csv -NoTypeInformation

get-childitem -path "c:\work\Scripts\DLCleanUp\Export" -exclude childitem.txt -name > "$Path\childitem.txt"

$From = "notice@redplug.com"

$To = "redplug@redplug.com"

$SmtpServer = "mail.redplug.com"

$Subject = "[AutoJob] $EndDay DLReceiveListExport End"

$Body = get-content -path "$Path\Childitem.txt" | Out-String

Send-MailMessage -From $From -To $To -SmtpServer $SmtpServer -Subject $Subject -Body $Body 

# Exchange management Shell Connect #

. 'D:\Exchange Server\V15\bin\RemoteExchange.ps1'

Connect-ExchangeServer -auto 

# 작업 날짜

$Date = (Get-date).toString("yyyyMMdd") 

# Export path

$Path = "C:\Work\Scripts\DLReceive\Export" 

get-DistributionGroup -resultsize unlimited -filter {HiddenFromAddressListsEnabled -eq "False"} | `

Select SamAccountName, OrganizationalUnit,DisplayName,`

HiddenFromAddressListsEnabled,WindowsEmailAddress,WhenCreated | `

export-csv -Encoding UTF8 -Path $Path\AllDLList_$Date.csv -NoTypeInformation