To Fetch Monthly Resource Utilization Report for CPU,Memory,Disk,Network Utilization on Esxi 6.5 with running vms

You can achieve it using RVTools. Download RVTools and See the script written on Vmware code site and you can automate it with WIndows Task Manager.


$ExportPath = 'C:\Temp'

$Servers = 'vcenter1','vcenter2'

 

$Servers | %{

. "C:\Program Files (x86)\Robware\RVTools 3.9.3\RVTools.exe" -passthroughAuth -s "$($_)" -c ExportAll2xls -d "$($ExportPath)" -f "RVTools-$($_)"

}


$smtpServer = 'smtp address'

$to = 'Receiver Email ID'

$from = 'Sender Email ID'


$att = Get-ChildItem -Path $ExportPath -Filter RVTools*.xlsx | select -ExpandProperty FullName


Send-MailMessage -SmtpServer $smtpServer -Subject 'RVTools reports' -To $to -From $from -Attachments $att

Reference :

https://communities.vmware.com/message/2665608#2665608

Thanks ,but my need is -To Fetch Monthly Resource Utilization Report  for CPU,Memory,Disk,Network Utilization on Esxi 6.5 with running vms

Monthly report like extract in excel/reporting format for 1 month cpu,mem,disk utilization @Host/VM

Do you mean that you are wanting to automate this type of report ?

If so, you might find this a useful starting point

Thanks @ArneLovius.

How can I achieve this using script to automate my monthly report  in user friendly dashboard /Excel/presentations

Did you look at the 2nd link ?

not working for me

What is not working for you, the second link ?

Link is fine ,But not getting report as expected , looking for monthly for CPU,Memory,Disk and Network Utilization @Host/VM level

As I said, "it may be a useful starting point"

Okay ,Thanks ,Will check for more enhancements

Great , Thanks Senior IT System Engineer,Let me give a try

Great Help Senior IT System Engineer , working fine for me.

Is it required to run it on weekly/monthly basis ?

Thanks a lot.

Yes, I usually run it monthly not weekly.

glad that it could help you man :-)

Can someone tell me the sample syntax to run this script?