topic Re: powerstate list by datacenter in VMware PowerCLI Discussions

powerstate list by datacenter

webmichael01 — Fri, 21 Jul 2023 16:35:28 GMT

Get-Datacenter | Select @{N = 'datcentername'; E = {$_.Name -replace '-','' }}, @{N = 'Cluster_Name'; E = {$datacenter.name}}, @{N = 'VM Count'; E = {( get-vm | where-object { $_.powerstate -eq "poweredOff"}).Count}}

how come this is adding the counts instead of breaking them out per count by Datacenter ?

Human error Im sure

datacenter1 312
datacenter2 312
datacenter3 312

I need it this formate for nodeExporter

Re: powerstate list by datacenter

LucD — Fri, 21 Jul 2023 16:53:29 GMT

Because you do a Get-VM without a Location parameter, that will return all the VMs.
Use

@{N = 'VM Count'; E = {( Get-VM -Location $_ | where-object { $_.powerstate -eq "poweredOff"}).Count}}

Re: powerstate list by datacenter

webmichael01 — Fri, 21 Jul 2023 17:05:18 GMT

thank you sir I tried the location but I see was doing it wrong and leaving off $_

Re: powerstate list by datacenter

webmichael01 — Fri, 21 Jul 2023 17:20:18 GMT

ignore sorry cant delete