List virtual machines by hard drive size

[TheVMinator]

How can I list the virtual machines that have a single hard drive greater than 50GB?  If they have a total of all hard drives greater than 50GB, I DONT want to list them.

Thanks!

[LucD · Accepted solution]

You mean something like this ?

Get-VM | Get-HardDisk | where {$_.CapacityGB -gt 50} |

Select @{N="VM";E={$_.Parent.Name}},Name,CapacityGB

[TheVMinator]

Ok great thanks