Powershell to email individual users in a csv

spiceuser-y2pq8 · 2020-06-10T17:29:21.000Z

hi,

I have exported disconnected RDP sessions from a server.

Just trying to figure out how to email those users individually and list of managers

The CSV header is SessionID that has the email address.

See script below

& ‘C:\Scripts\MASTER-RDP SESSIONS.ps1’ | Where-Object {($.SessionID = $.SessionID + “@domain.com”)} |export-csv -NoTypeInformation -Path “C:\temp\InactiveSessions.csv”

}

#import Report

$report = “C:\temp\InactiveSessions.csv”
$UserList = Import-Csv $report

Setup email parameters

$Subject = “DISCONNECTED SERVER SESSIONS” + $today
$priority = “Normal”
$smtpServer = “xxxx.xxxx.local”
$emailFrom = “xxxx@domain.com”
$emailTo = “Managers”
$EmailBody = “Disconnected Server Sessions”

Send-MailMessage -To $emailTo -From $emailFrom -SmtpServer $smtpServer -Subject $Subject -Attachments $report

foreach ($SessionID IN $UserList) {
Send-MailMessage -To $SessionID -From $emailFrom -SmtpServer $smtpServer -Subject $Subject -Body $EmailBody}

Neally · 2020-06-10T19:33:29.000Z

Welcome

If you post code, please use the ‘Insert Code’ button. Please and thank you!

PLEASE READ BEFORE POSTING! Read if you're new to the PowerShell forum! .

Neally · 2020-06-10T19:58:34.000Z

spiceuser-y2pq8:

you might have to add another step to query active directory to get the manager proprty and get the manager email that waye.g.

foreach ($SessionID IN $UserList) {
Send-MailMessage -To $SessionID `
-cc ((get-aduser $sessionID -properties manager | foreach {get-aduser $_.manager -properties emailaddress).emailaddress})`
-From $emailFrom -SmtpServer $smtpServer -Subject $Subject -Body $EmailBody
}