I missed your reply for this thread, I was out of station for few days.
Sure, I will give you feedback once all issues get fixed.
I am using below code for 90 days utilisation of 10 VMs for output server name Time | AVG_CPU | AVG_MEM | AVG_disk | AVG_Net
VM1- servers.csv in below script contents below format vm names
VM2
VM3
issues :
1) Unable to get all VMs output, getting on csv file for last VM name listed in servers list
2) Maximum row output is only 168 Rows
3) Disk Output for all VMs showing 0
################################################################################################################################################
$servers=Get-Content C:\Users\servers.csv
foreach ($server in $servers)
{
$vm=Get-VM $server
if($? -eq $false)
{
continue
}
$fileName="C:\Users\VM_Utilization_Report.csv"
$memusageaverage=Get-Stat -entity $vm -MaxSamples 168 -Start (Get-Date).AddDays(-90) -IntervalMins 1440 -stat ‘mem.active.average’ | ? { $_.instance -eq "" } | select Entity,Timestamp,Value |Sort-Object Timestamp
$cpuusageaverage=Get-Stat -entity $vm -MaxSamples 168 -Start (Get-Date).AddDays(-90) -IntervalMins 1440 -stat ‘cpu.usage.average’ | ? { $_.instance -eq "" } | select Entity,Timestamp,Value |Sort-Object Timestamp
$diskusage=Get-Stat -entity $vm -MaxSamples 168 -Start (Get-Date).AddDays(-90) -IntervalMins 1440 -stat ‘virtualdisk.throughput.usage.average’ | ? { $_.instance -eq "" } | select Entity,Timestamp,Value |Sort-Object Timestamp
$netusageaverage=Get-Stat -entity $vm -MaxSamples 168 -Start (Get-Date).AddDays(-90) -IntervalMins 1440 -stat ‘net.usage.average’ | ? { $_.instance -eq "" } | select Entity,Timestamp,Value |Sort-Object Timestamp
Set-Content -Value "ServerName,AVG_CPU_Time,AVG_CPU,AVG_MEM,AVG_disk,AVG_Net" -Path $fileName
$diskus=0
for ($i=0;$i -lt $cpuusageaverage.Count ; $i++)
{
if (($diskus -lt $diskusage.count) -and ($cpuusageaverage[$i].Timestamp -eq $diskusage[$diskus].Timestamp))
{
Add-Content -Value "$($cpuusageaverage[$i].Entity.Name),$($cpuusageaverage[$i].Timestamp),$($cpuusageaverage[$i].Value),$($memusageaverage[$i].Value),$($diskusage[$diskus].Value),$($netusageaverage[$i].value)" -Path $fileName
$diskus++
}
else
{
Add-Content -Value "$($cpuusageaverage[$i].Entity.Name),$($cpuusageaverage[$i].Timestamp),$($cpuusageaverage[$i].Value),$($memusageaverage[$i].Value),0,$($netusageaverage[$i].value)" -Path $fileName
}
}
}
return(0)
##############################################################################################################################################
