0 0

Export AD Users and mail attachment

Import-Module ActiveDirectory
$DateStamp = (Get-Date).ToString("yyyyMMdd")
$ExportFile = "C:\AD_Export\AD_Export_$DateStamp.csv"
$DomainController = (Get-ADDomainController).Name
if (Test-Path $ExportFile) { Remove-Item $ExportFile }
Get-ADUser -Filter * -Server $DomainController -Properties UserPrincipalName, DisplayName, SamAccountName, EmployeeID, Enabled, LastLogonDate | Select-Object UserPrincipalName, DisplayName, SamAccountName, EmployeeID, @{Name="Account Status";Expression={if ($_.Enabled) {"Enabled"} else {"Disabled"}}}, LastLogonDate | Export-Csv -Path $ExportFile -NoTypeInformation
Start-Sleep -Seconds 2
Send-MailMessage -From no-reply@domain.com -To recipient@domain.com, recipient2@domain.com -Subject "Monthly AD Export" -Body "Active Directory Export" -Attachments $ExportFile -SmtpServer domain-com.mail.protection.outlook.com -Port 25
Exit