Thanks for the tip.
I'm trying to add a field with the information of the average in a certain period, in this script below:
$report += Get-Folder -Name 'nome_da_pasta' | Get-VM |
Select Name,MemoryGB,
@{N='UsedMemoryGB';E={$_.ExtensionData.Summary.Quickstats.GuestMemoryUsage}}
#$_.ExtensionData.Summary.Quickstats.GuestMemoryUsage
}
$report | Export-Csv -Path $log -NoTypeInformation -UseCulture
if ((Get-Content $log) -ne $null)
{
Add-PSSnapin Microsoft.Exchange.Management.Powershell.Admin -erroraction silentlyContinue
$msg = new-object Net.Mail.MailMessage
$smtp = new-object Net.Mail.SmtpClient($smtpServer)
$att = new-object Net.Mail.Attachment($log)
$msg.From = $from
$msg.To.Add($to)
$msg.Subject = "[VCENTER] Relatório de consumo de recursos PRD - $data"
$msg.Attachments.Add($att)
$msg.IsBodyHTML = $true
$body = @"
Relatório de consumos de recursos PRD ON PREMISE por pasta na data de $data.
"@
$msg.body = $body
$smtp = New-Object Net.Mail.SmtpClient($SmtpServer, 587)
$smtp.EnableSsl = $true
$user = "AKIAWJ54FS3T366IGXWY"
$password = "BH1Ko2CLzTE1oNBD5/FoWiTIuP5Jg7Z+ieUScKiuhntq"
$smtp.Credentials = New-Object System.Net.NetworkCredential($user, $password);
$smtp.Send($msg)
}
if (Test-Path $log)
{
Remove-Item $log -Force -ErrorAction: Ignore
}
}
- but i'm not succeeding
