script powercli

[jlovera]

Hello

please I need a powercli script to know how much CPU and memory a cluster uses for a period of 30 days

could you help me?

[LucD]

You could do something like this

$clusterName = 'MyCluster'

$stat = 'cpu.usage.average','mem.usage.average'

$entity = Get-Cluster -Name $clusterName

$start = (Get-Date).AddDays(-30)

Get-Stat -Entity $entity -Stat $stat -Start $start |

Group-Object -Property Timestamp |

ForEach-Object -Process {

   New-Object PSObject -Property @{

   Cluster = $_.Group[0].Entity.Name

   Time = $_.Group[0].Timestamp

   CPUPerc = ($_.Group | where{$_.MetricId -eq 'cpu.usage.average'} | Measure-Object -Property Value -Average).Average

   MemPerc = ($_.Group | where{$_.MetricId -eq 'mem.usage.average'} | Measure-Object -Property Value -Average).Average

   }

}