Get VM DRS-Group and Datatsore

[vmware-oebb]

Hello,

I'm a Script Newbie.

Hope somebody can help me. This Script works fine. But I Need also the Datastore Location of each VM.

$Cluster = Get-Cluster -Name <Name>

$vmsInGroup = $cluster.ExtensionData.ConfigurationEx.Group | where {$_-is [VMware.Vim.ClusterVmGroup]} | %{Get-View -Id $_.VM | Select -ExpandProperty Name}

$VMsNotInDrsGroup = @(Get-VM -Location $Cluster | where {$vmsInGroup -notcontains $_.Name} | Select Name,VMHost | Sort VMHost)

Thank you

Andi

[LucD · Accepted solution]

Try like this

$Cluster = Get-Cluster -Name <Name>

$vmsInGroup = $cluster.ExtensionData.ConfigurationEx.Group | where {$_ -is [VMware.Vim.ClusterVmGroup]} | %{Get-View -Id $_.VM | Select -ExpandProperty Name}

$VMsNotInDrsGroup = @(Get-VM -Location $Cluster |

                      where {$vmsInGroup -notcontains $_.Name} |

                      Select Name,VMHost,@{N='Datastore';E={$_.ExtensionData.Config.Files.vmPathName.Split(']')[0].TrimStart('[')}} | Sort VMHost)

[vmware-oebb]

Hi Luc,

Script works fine. Thank you so much.

Andi