$allclust = @() $clust = Get-Cluster foreach($clu in $clust){ $clusstat = "" | Select ClusterName, MemMax, MemAvg, CPUMax, CPUAvg $clusstat.ClusterName = $clu.name $thisMonth = [datetime](Get-Date -Format "y") 12..1 | %{ $from = $thisMonth.AddMonths(- $_ ) $to = $thisMonth.AddMonths(- $_ +1).AddDays(-1) } $statcpu = Get-Stat -Entity ($clu) -start $from -Finish $to -MaxSamples 10000 -stat cpu.usagemhz.average $statmem = Get-Stat -Entity ($clu) -start $from -Finish $to -MaxSamples 10000 -stat mem.usage.average $cpu = $statcpu | Measure-Object -Property value -Average -Maximum $mem = $statmem | Measure-Object -Property value -Average -Maximum $clusstat.CPUMax = $cpu.Maximum $clusstat.CPUAvg = $cpu.Average $clusstat.MemMax = $mem.Maximum $clusstat.MemAvg = $mem.Average $allclust += $clusstat } $allclust | select ClusterName, MemMax, MemAvg, CPUMax, CPUAvg | Export-Csv "c:\g.csv" -noTypeInformation