feed_powerbi.ps1

Connect-VIServer asdf

Clear-Variable report

$report = Get-Datacenter -PipelineVariable datacenter | 
    ForEach-Object {
        get-cluster -Location $_ -PipelineVariable cluster | 
            ForEach-Object { get-vmhost -Location $_ | 
                foreach-object {[pscustomobject]@{
                    Datacenter=$datacenter.Name;
                    Cluster=$cluster.Name;
                    Name=$_.Name;
                    NumCPU=$_.NumCpu;
                    MemoryGB=[math]::Round($_.MemoryTotalGB);
                    MemoryUsedGB=[math]::Round($_.MemoryUsageGB);
                    CpuTotalMhz=[math]::Round($_.CpuTotalMhz);
                    CpuUsedMhz=[math]::Round($_.CpuUsageMhz);
                    MemoryUsedPct=[math]::Round(($_.MemoryUsageGB/$_.MemoryTotalGB*100));
                    CpuUsedPct=[math]::Round($_.CpuUsageMhz/$_.CpuTotalMhz*100);
                    NumVMs=$(get-vm -Location $_).count
                }
            }
        }
    }

$report | export-csv -Force -NoTypeInformation -path "c:\temp\powerbifeed.csv"