Where clause question

[Rick360]

Hello,

I'm reviewing a script I found that returns guest information and whether hot add is enabled:

Get-VM | Get-View | Select Name, `

@{N="CpuHotAddEnabled";E={$_.Config.CpuHotAddEnabled}}, `

@{N="CpuHotRemoveEnabled";E={$_.Config.CpuHotRemoveEnabled}}, `

@{N="MemoryHotAddEnabled";E={$_.Config.MemoryHotAddEnabled}}

How would I limit this to show where CpuHotAddEnabled = false ?

When I pipe the above to a where I receive "The property 'CpuHotAddEnabled' cannot be found on this object"

Thanks.

[LucD · Accepted solution]

Try like this

Get-VM | Get-View |

where{$_.Config.CpuHotAddEnabled -ne $true} |

Select Name,

@{N="CpuHotAddEnabled";E={$_.Config.CpuHotAddEnabled}},

@{N="CpuHotRemoveEnabled";E={$_.Config.CpuHotRemoveEnabled}},

@{N="MemoryHotAddEnabled";E={$_.Config.MemoryHotAddEnabled}}

[Rick360]

Thank You LucD, I was thinking in SQL I guess!!!