show vms with datastores

[tdubb123]

I want to get my vms on a cluster with their datastores location.

how can i do this?

get-cluster "cluster" | get-vm * | select Name, etc....

[LucD]

Something like this ?

Get-Cluster | Get-VM | 
Select Name,@{N="Datastore";E={[string]::Join(',', (Get-Datastore -VM  $_ | %{$_.Name})}}

[tdubb123]

thank luc. I dont quite understand  what

E={[string]::Join(',', (Get-VM $_ | %{$_.Name})}} does.

it gave me an output like this

Name                 Datastore

-------                                  -------------------

vm                                       vm

but I was able to change it to

get-cluster cluster | get-vm vm* | Select NAme, @{N="Datastore";E={Get-Datastore -VM $_}}

which works now

thank you

[LucD]

That was indeed what it should have been. The join was there in case your VM is spread over multiple datastores? It's corrected now.