The Script attached gives you a report ..doing the following

1) Lists all ESX servers

3)List all clusters and calulates VMware capacity for each cluster

Provided detallied information about datstores , RDM and all sorts..

This is the mother of all reports ...... Many thankd to Ivo Beerens ivo@ivobeerens.nl who wrote VMwareHealth Check script and of course LuCD VI tollkit GURU

blog www.ivobeerens.nl

{noformat}
Get-Stat .... -Start  (get-date).Date.adddays(-1) -Finish (get-date).Date.addminutes(-1)
{noformat}

{noformat}
$DaysBack = <n>        # Number of days to go back
$DaysPeriod = <m>      # Number of days in the interval
$StatStart = (Get-Date).Date.adddays(- $DaysBack)
$StatFinish = (Get-Date).Date.adddays(- $DaysBack + $DaysPeriod).addminutes(-1)
Get-Stat .... -Start $StatStart -Finish $StatFinish
{noformat}

The VM Calculation for daily and weekly memory and cpu used i see is in %. is is possible to get actual values for this ?? .If it can it will be awesome!!!

What is it doing with "C:\Program Files\Veeam\Veeam Backup and FastSCP\Putty\plink"?

This is a great script! I have been playing around with it and have managed to use the following to get the Average Memory usage and CPU usage (1 day & 1 week) for the hosts....

######################################################
#Host CPU & Memory Usage
Write-Host "Gathering Host CPU & Memory Usage Information."
function VM-statavg ($vmImpl, $StatStart, $StatFinish, $statId) {

• $stats = $vmImpl | get-stat -Stat $statId -intervalmin 120 -Maxsamples 360 `*
• -Start $StatStart -Finish $StatFinish*
• $statAvg = "{0,9:#.00}" -f ($stats | Measure-Object value -average).average*
• $statAvg*

• $vm = Get-View $_.ID*
• $vms = "" | Select-Object VMName, DayAvgCpuUsage, WeekAvgCpuUsage, DayAvgMemUsage, WeekAvgMemUsage*
• $vms.VMName = $vm.Name*
• $vms.DayAvgCpuUsage = VM-statavg $_ $DayStart $DayFinish "cpu.usage.average"*
• $vms.WeekAvgCpuUsage = VM-statavg $_ $WeekStart $WeekFinish "cpu.usage.average"*
• $vms.DayAvgMemUsage = VM-statavg $_ $DayStart $DayFinish "mem.usage.average"*
• $vms.WeekAvgMemUsage = VM-statavg $_ $WeekStart $WeekFinish "mem.usage.average"*
• $Report += $vms*

Does anyone know if there is an easy way to put this into the clusters section report?

Also is there a command that lists the datastores per cluster?

Cheers

Humpa