powercli scratch

gistfile1.txt

PowerCLI> GetStatType -Entity CLUSTERNAME
cpu.reservedCapacity.average
mem.reservedCapacity.average
mem.granted.average
mem.active.average
mem.shared.average
mem.zero.average
mem.swapused.average
mem.vmmemctl.average
mem.compressed.average
mem.compressionRate.average
mem.decompressionRate.average
power.power.average
cpu.usagemhz.average
cpu.usage.average
mem.usage.average
mem.overhead.average
mem.consumed.average
clusterServices.effectivecpu.average
clusterServices.effectivemem.average
cpu.totalmhz.average
mem.totalmb.average
clusterServices.failover.latest
vmop.numPoweron.latest
vmop.numPoweroff.latest
vmop.numSuspend.latest
vmop.numReset.latest
vmop.numRebootGuest.latest
vmop.numStandbyGuest.latest
vmop.numShutdownGuest.latest
vmop.numCreate.latest
vmop.numDestroy.latest
vmop.numRegister.latest
vmop.numUnregister.latest
vmop.numReconfigure.latest
vmop.numClone.latest
vmop.numDeploy.latest
vmop.numChangeHost.latest
vmop.numChangeDS.latest
vmop.numChangeHostDS.latest
vmop.numVMotion.latest
vmop.numSVMotion.latest

Passing the host as the entity works quickly, even for 1 year, as below:

Get-Stat -Entity entity -Start (Get-Date).AddHours(-8760) -Stat  cpu.usage.average | Export-Csv c:\users\jcoleman\foo2.csv