email sent using sendmail not readable

marlon3 · 2021-05-13T12:04:45.000Z

$csv = import-csv c:\temp\Server_Status_Report.csv
$csvHthml =import-csv C:\temp\Server_Status_Report.csv | ConvertTo-Html -Fragment l|out-string

$Report= $csv | group status,Vcenter,Serverstatus | select count,name
$Total = $CSV.count
$TotalFailed = (($CSV | Where-Object status -ne “Success”).count)
$Report += “Total systems checked: $Totaln" $Report += "Total failures : $TotalFailedn”
$Report += “********”

$emailSmtpServer = “smtp.gmail.com”
$emailSmtpServerPort = “587”
$emailSmtpUser = " "
$emailSmtpPass =
$emailFrom = “green0tree22@gmail.com”
$emailTo = “”

$emailMessage = New-Object System.Net.Mail.MailMessage( $emailFrom , $emailTo )
$emailMessage.Subject = “Server Status Report”
$emailMessage.Body = @"
Hello Test
$csvHthm + `n$Report
Thanks
"@

$SMTPClient = New-Object System.Net.Mail.SmtpClient( $emailSmtpServer , $emailSmtpServerPort )
$SMTPClient.EnableSsl = $True
$SMTPClient.Credentials = New-Object System.Net.NetworkCredential( $emailSmtpUser , $emailSmtpPass );
$SMTPClient.Send( $emailMessage )

marlon3 · 2021-05-13T13:11:46.000Z

How can i display the content of the csv file

Here is the output when i execute the script.

Hello Test

Total systems checked: 3

Total failures : 2

Thanks

atypical-it-guy · 2021-05-13T13:42:34.000Z

Your variables don’t match

$csvHthml vs $csvHthm

Neally · 2021-05-13T13:47:29.000Z

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! Programming & Development

Hi, and welcome to the PowerShell forum! Don’t apologize for being a “noob” or “newbie” or “n00b.” There’s just no need – nobody will think you’re stupid, and the forums are all about asking questions. Just ask! Use a descriptive subject. Don’t say “Need help” or “PowerShell Help”, actually summarize what the problem is. It helps the rest of us keep track of which problem is which. Don’t post massive scripts. We’re all volunteers and we don’t have time to read all that, nor will we copy…

marlon3 · 2021-05-13T13:53:05.000Z

Hi Nelly,

I change the script and add foreach loop in csv file but i only received this and the content of the csv file is not display in email.

see my script and the sample csv file.

need your help.

Thanks

email recieved

Hello Test

(),

Total systems checked: 3

Total failures : 2

Thanks

 $csv = import-csv c:\temp\Server_Status_Report.csv 
$csv | ForEach-Object {
    $msg+="$($_.Vcenter), is $($_.Status), $($_.ServerStatus)."
    
    }

         $Report= $csv | group status,Vcenter,Serverstatus | select count,name
         $Total       = $CSV.count
         $TotalFailed = (($CSV | Where-Object status -ne "Success").count)
         $Report += "Total systems checked: $Total`n"
         $Report += " Total failures       : $TotalFailed`n"
         $Report += "********"
              
$emailSmtpServer = "smtp.gmail.com"
$emailSmtpServerPort = "587"
$emailSmtpUser = "green0tree22@gmail.com"
$emailSmtpPass = ""
$emailFrom = "green0tree22@gmail.com"
$emailTo = ""

$emailMessage = New-Object System.Net.Mail.MailMessage( $emailFrom , $emailTo )
$emailMessage.Subject = "Server Status Report"
$emailMessage.Body = @"
                      Hello Test
                    "$msg"`n  `n$Report
                     Thanks
"@
                    
$SMTPClient = New-Object System.Net.Mail.SmtpClient( $emailSmtpServer , $emailSmtpServerPort )
$SMTPClient.EnableSsl = $True
$SMTPClient.Credentials = New-Object System.Net.NetworkCredential( $emailSmtpUser , $emailSmtpPass );
$SMTPClient.Send( $emailMessage )

Server_Status_Report.txt (488 Bytes)

marlon3 · 2021-05-13T14:09:48.000Z

Hi Team,

Here is the email output but seems some error because it was repeat the first line which is the .137?

i only add plus sign + in foreach loop, how can i fix it?

$csv = import-csv c:\temp\Server_Status_Report.csv 
$csv | ForEach-Object {
    $msg+="$($_.Vcenter), is $($_.Status), $($_.ServerStatus).`n"
    
    }

"

Hello Test

192.168.254.137, is Failed, Cannot connect and Could not resolve the requested 192.168.254.137.

192.168.254.136, is Failed, Cannot complete login due to an incorrect user name or password.

192.168.254.135, is Success, Connected.

192.168.254.137, is Failed, Cannot connect and Could not resolve the requested 192.168.254.137."

Total systems checked: 3

Total failures : 2

Neally · 2021-05-13T14:35:53.000Z

Amberdawn:

Server_Status_Report.csv

is that server twice in your CSV ?

atypical-it-guy · 2021-05-13T14:44:06.000Z

EDIT: When I run your script, I’m getting your expected output, the second time I had double the expected output (because I never cleared the variable)

I’m not sure how you’re running your script, but it seems like you may not have cleared $msg between runs.
Try initializing it as a blank string to ensure the data is clean.

$csv = import-csv c:\temp\Server_Status_Report.csv 
$msg = ""
$csv | ForEach-Object {
    $msg+="$($_.Vcenter), is $($_.Status), $($_.ServerStatus).`n"
    
    }

marlon3 · 2021-05-13T15:15:46.000Z

No Neally,

it only display once

Here is the output of csv

192.168.254.136 Failed Cannot complete login due to an incorrect user name …
192.168.254.135 Success Connected
192.168.254.137 Failed Cannot connect and Could not resolve the requested 1…

when i execute the script:

here is what i receive

Hello Test

192.168.254.137, is Failed, Cannot connect and Could not resolve the requested 192.168.254.137.

192.168.254.136, is Failed, Cannot complete login due to an incorrect user name or password.

192.168.254.135, is Success, Connected.

192.168.254.137, is Failed, Cannot connect and Could not resolve the requested 192.168.254.137.

marlon3 · 2021-05-13T15:24:56.000Z

same result

Hello Test

“192.168.254.136, is Failed, Cannot complete login due to an incorrect user name or password.192.168.254.135, is Success, Connected.192.168.254.137, is Failed, Cannot connect and Could not resolve the requested 192.168.254.137.”

Total systems checked: 3

Total failures : 2

Thanks

marlon3 · 2021-05-13T15:55:24.000Z

i tried to use custom object but no results

 $csv = import-csv c:\temp\Server_Status_Report.csv 
 $i=0;
 $msg=ForEach($out in $csv) {
 [pscustomobject]  @{
 Vcenter="$($out.vcenter)"
 Status="$($out.status)"
 ServerStatus="$($out.serverstatus)"}
    $msg+="$($_.Vcenter), is $($_.Status), $($_.ServerStatus).`n"
    $i++
    }

Neally · 2021-05-13T16:28:01.000Z

ok, what EXACTLY do you want to show in your email?

marlon3 · 2021-05-13T17:22:45.000Z

Hi.

Seems i got correct email.

see below reuslt:

$csv = import-csv c:\temp\Server_Status_Report.csv
$msg=ForEach($t in $csv) {
    "$($t.Vcenter), is $($t.Status), $($t.ServerStatus).`n"
     }

email recieved.

Hello.

Here is the Server connection logs.

192.168.254.136, is Failed, Cannot complete login due to an incorrect user name or password.

192.168.254.135, is Success, Connected.

192.168.254.137, is Failed, Cannot connect and Could not resolve the requested 192.168.254.137.

Total systems checked: 3

Total failures : 2

Thanks

Neally · 2021-05-13T17:27:50.000Z

how about like so:

$csv = import-csv "C:\Users\Administrator\Desktop\input.csv"
 
$body = 
@"
Hello.

$(
    ForEach ($out in $csv) {
        "$($out.Vcenter), is $($out.Status), $($out.ServerStatus)`r`n"
    }
)
Total Systems Checked: $(($csv|measure-object).count)
Total Failures: $((($csv|Where-Object status -eq 'failed')|measure-object).count)

Thanks
"@

$emailSmtpServer = "smtp.gmail.com"
$emailSmtpServerPort = "587"
$emailSmtpUser = "green0tree22@gmail.com"
$emailSmtpPass = ""
$emailFrom = "green0tree22@gmail.com"
$emailTo = ""
$emailMessage = New-Object System.Net.Mail.MailMessage( $emailFrom , $emailTo )
$emailMessage.Subject = "Server Status Report"
$emailMessage.Body = $body                    
$SMTPClient = New-Object System.Net.Mail.SmtpClient( $emailSmtpServer , $emailSmtpServerPort )
$SMTPClient.EnableSsl = $True
$SMTPClient.Credentials = New-Object System.Net.NetworkCredential( $emailSmtpUser , $emailSmtpPass );
$SMTPClient.Send( $emailMessage )

marlon3 · 2021-05-13T17:34:06.000Z

I think my issue is now resolve.

Thanks everyone for your time.

marlon3 · 2021-05-13T17:37:24.000Z

Hi neally,

I used this one. and it worked, i only change below and it receive correct output in email.

$csv = import-csv c:\temp\Server_Status_Report.csv
$msg=ForEach($t in $csv) {
    "$($t.Vcenter), is $($t.Status), $($t.ServerStatus).`n"
     }

Here is the email recieved:

Hello.

Here is the Server connection logs.

192.168.254.136, is Failed, Cannot complete login due to an incorrect user name or password.

192.168.254.135, is Success, Connected.

192.168.254.137, is Failed, Cannot connect and Could not resolve the requested 192.168.254.137.

Total systems checked: 3

Total failures : 2

Thanks

Neally · 2021-05-13T17:41:07.000Z

whatever floats your boat