$start=get-date
$Pools=get-pool|select Pool_ID,Enabled,RefreshPolicy,Minimumcount,MaximumCount,VMcreated,Perc,Nota
$a=0
$soglia=90
foreach ($Pool in $Pools)
{
$Pools[$a].VMcreated=(Get-DesktopVM -pool_id $Pools[$a].pool_id).Count
$Pools[$a].Perc=[int]($Pools[$a].VMcreated*100/$Pools[$a].maximumcount)
#$allerta=$Pools[$a].MaximumCount-$soglia
if ($Pools[$a].perc -ge $soglia)
{
$Pools[$a].Nota=("ALERT")
}
$a=$a+1
}
$end=get-date
$Style = "
<style>
BODY{background-color:white;}
TABLE{border-width: 1px;border-style: solid;border-color: black;border-collapse: collapse;}
TH{border-width: 1px;padding: 3px;border-style: solid;border-color: black;background-color:#778899}
TD{border-width: 1px;padding: 3px;border-style: solid;border-color: black;}
tr:nth-child(odd) { background-color:#d3d3d3;}
tr:nth-child(even) { background-color:white;}
</style>
"
$EmailFrom = "Report Pools <no-replay@xxxxxx.xx>"
# $EmailTo =
$EmailSubject = "Testo"
$SMTPServer = "smtp"
$emailBody1=$Pools|ConvertTo-HTML -Head $style|out-string
function send_email {
$mailmessage = New-Object system.net.mail.mailmessage
$mailmessage.from = ($emailfrom)
$mailmessage.To.add($emailto)
$mailmessage.Subject = $emailsubject
$mailmessage.Body = $emailbody
$attachment = New-Object System.Net.Mail.Attachment($emailattachment, 'text/plain')
$mailmessage.IsBodyHTML = $true
$SMTPClient = New-Object Net.Mail.SmtpClient($SmtpServer, 25)
$SMTPClient.Credentials = New-Object System.Net.NetworkCredential("$SMTPAuthUsername", "$SMTPAuthPassword")
$SMTPClient.Send($mailmessage)
}
send_email