Below script can be used to send email from Powershell, for audit report for yesterday.
1: $yesterday = (get-date).AddDays(-1).Date.ToString("yyyy_MM_dd")
2: $yesterdayMailSubject = (get-date).AddDays(-1).Date.ToString("yyyy-MM-dd")
3: $From = "test@email.com"
4: $To ="test@email.com"
5: $Cc = "test@email.com"
6: $Attachment = "C:\temp\Audit_$yesterday.csv"
7: $Subject = " DB Server Audit for Day: $yesterdayMailSubject "
8: $Body = "<h2>Please see the audit report attached file</h2><br><br>"
9: $SMTPServer = "SMTPServerName"
10: $SMTPPort = "587" #SMTPPort
11: Send-MailMessage -From $From -to $To -Cc $Cc -Subject "test" -Usessl -Body "test" -SmtpServer $SMTPServer -Port $SMTPPort -Credential $From -Verbose -Debug #-Attachments $Attachment
No comments:
Post a Comment