Enumerate VMware guests and the datastores each one uses

get-datastores.ps1

$vms = get-view -type virtualmachine

$hosts = $vms | %{
  $obj = New-Object Object
  $obj | Add-Member noteproperty name $_.name
  $obj | Add-Member noteproperty datastores ($_.datastore | %{(get-view -Id $_).Name})
  $obj
}

# Dump to CSV
$hosts | convertto-csv > hosts.csv