get all powered on vms windows type

[tdubb123]

hi

any idea why this is not working?

get-vm | ? {$_.powerstate -eq "PoweredOn" -and {$_.extensiondata.guest.guestfullname -match "Microsoft*"}}

its showing linux as well

[LucD]

That shouldn't be curly braces.

Try like this

Oh, and -match expects a RegEx, so do not use the asterisks, unless you really want it there.

In a RegEx it doesn't mean the same thing as for a -like

get-vm | ? {($_.powerstate -eq "PoweredOn") -and ($_.extensiondata.guest.guestfullname -match "Microsoft")}

[jrodsguitar]

LucD You're like my much wiser clone I love it. :smileyhappy: Much to learn from you so take it easy on me :smileywink:

[tdubb123]

Thank you both!

[tdubb123]

is there a better or shorter query to run for this

get-vm | ? {($_.powerstate -eq "PoweredOn") -and ($_.extensiondata.guest.guestfullname -match "Microsoft")} | select NAme, @{N="tools";e={$_.extensiondata.guest.toolsstatus}}, @{N="vmhardware";e={$_.extensiondata.config.version}} | sort vmhardware | ft -AutoSize

[LucD]

Not shorter, but definitely faster

Get-View -ViewType VirtualMachine -Property Name,Runtime.PowerState,Guest,Config.Version -Filter @{'Runtime.PowerState'='poweredOn'} |

where{$_.Guest.GuestFullName -match 'Windows'} |

select Name, @{N="Tools";e={$_.guest.toolsstatus}},

    @{N="vmhardware";e={$_.config.version}} |

Sort-Object -Property vmhardware |

ft -AutoSize

[jrodsguitar]

This should work for you.

get-vm | where {$_.powerstate -eq "PoweredOn" -and $_.extensiondata.guest.guestfullname -like 'Microsoft*'}