topic Find/count VMs with 2 or more VMDKs on different Datastores in VMware PowerCLI Discussions

Find/count VMs with 2 or more VMDKs on different Datastores

qwert1235 — Wed, 05 May 2010 18:55:14 GMT

Hello:

I am wondering how to find (and count later) all VMs that have 2 or more VMDKs on different datastore...

Thanks,

qwert

Re: Find/count VMs with 2 or more VMDKs on different Datastores

RvdNieuwendijk — Wed, 05 May 2010 19:39:37 GMT

The attached script gets the VM's with vmdk's on more then one datastore.

I have to attach the script because it contains square brackets and the forum software has problems with them.

Re: Find/count VMs with 2 or more VMDKs on different Datastores

sm7012 — Wed, 05 May 2010 19:40:09 GMT

This script worked great for me. Simple script and it tells you the "VMNAME, DATASTORE, Cluster". If a VM has 2 VMDKs, it just lists the VM on 2 lines, obviously 2nd line shows the other VMDK file. Creates a CSV file in the root of C. You can change it to whatever you like.

$report = @() 
$allvms = Get-VM 
foreach ($vm in $allvms) { 
        $clusterName = ($vm | Get-Cluster).Name
        $dstores = $vm | Get-Datastore 
        foreach($ds in $dstores){ 
                $row = "" | select VMNAME, DATASTORE, Cluster 
                $row.VMNAME = $vm.name 
                $row.DATASTORE = $ds.Name 
                $row.Cluster = $clusterName
                $report += $row 
        } 
} 
$report | Export-Csv "C:\VM_DS.csv" -NoTypeInformation

Re: Find/count VMs with 2 or more VMDKs on different Datastores

RvdNieuwendijk — Wed, 05 May 2010 19:40:34 GMT

The attached script counts the VM's with vmdk's on more then one datastore.

I have to attach the script because it contains square brackets and the forum software has problems with them.

Regards, Robert

Re: Find/count VMs with 2 or more VMDKs on different Datastores

qwert1235 — Fri, 07 May 2010 16:27:07 GMT

Folks,

Thanks a lot for your help!!!

I like this script very much:

$report = @() 
$allvms = Get-VM 
foreach ($vm in $allvms) { 
$clusterName = ($vm | Get-Cluster).Name
$dstores = $vm | Get-Datastore 
foreach($ds in $dstores){ 
$row = "" | select VMNAME, DATASTORE, Cluster 
$row.VMNAME = $vm.name 
$row.DATASTORE = $ds.Name 
$row.Cluster = $clusterName
$report += $row 
} 
} 
$report | Export-Csv "C:\VM_DS.csv" -NoTypeInformation

However, I cannot figure out how to collect only VMs with vmdks different datastore... I know I should use "-Unique" but could not figure out where...

Any help will be really appreciated.

Thanks,

qwert

Re: Find/count VMs with 2 or more VMDKs on different Datastores

LucD — Fri, 07 May 2010 16:37:16 GMT

Try to change this line

$dstores = $vm | Get-Datastore

into this

$dstores = $vm | Get-Datastore | Select-Object -Unique

____________

Blog: LucD notes

Twitter: lucd22

Re: Find/count VMs with 2 or more VMDKs on different Datastores

RvdNieuwendijk — Fri, 07 May 2010 16:57:21 GMT

The next script will do the job:

$report = @() 
$allvms = Get-VM 
foreach ($vm in $allvms) { 
	$clusterName = ($vm | Get-Cluster).Name
	$dstores = $vm | Get-Datastore 
	foreach($ds in $dstores){ 
		$row = "" | select VMNAME, DATASTORE, Cluster 
		$row.VMNAME = $vm.name 
		$row.DATASTORE = $ds.Name 
		$row.Cluster = $clusterName
		$report += $row 
	} 
} 
$report | `
Sort-Object -Property VMName,Datastore -Unique | `
Group-Object -Property VMName | `
Where-Object { $_.Count -gt 1 } | `
Export-Csv "C:\VM_DS.csv" -NoTypeInformation

Regards, Robert

Re: Find/count VMs with 2 or more VMDKs on different Datastores

qwert1235 — Fri, 07 May 2010 17:10:13 GMT

Luc,

No, it did not change anything at all...

I still have report of all VMs with 2 or more vmdks, but if VM has 2 (or more) vmdks on the same datastore it's still listed in the report, but only once... and I do not to have it in the report at all...

Thanks,

qwert

Re: Find/count VMs with 2 or more VMDKs on different Datastores

LucD — Fri, 07 May 2010 17:18:44 GMT

Oh, I see. Got your question wrong then.

Robert's latest script will do what you want.

The where-clause in there will get rid of VMs who are only using 1 datastore.

____________

Blog: LucD notes

Twitter: lucd22

Re: Find/count VMs with 2 or more VMDKs on different Datastores

qwert1235 — Fri, 07 May 2010 17:19:10 GMT

Robert,

Looks like onle VMs with vmdks on different datastore were selected. However report does not have any information right now about VMs name, datastore name and cluster...

Instead it give something like that:

System.Collections.ArrayList,2,System.Collections.ObjectModel.Collection`1[http://System.Management.Automation.PSObject|http://System.Management.Automation.PSObject],myvirtualMachine_name

Thanks,

qwert

Re: Find/count VMs with 2 or more VMDKs on different Datastores

RvdNieuwendijk — Fri, 07 May 2010 17:38:11 GMT

Argh, you will allways see that the only line in my script that I didn't test, the Export-CSV cmdlet, gives you trouble. The next script I tested from the beginning to the end and gives even better output:

$report = @() 
$allvms = Get-VM 
foreach ($vm in $allvms) { 
	$clusterName = ($vm | Get-Cluster).Name
	$dstores = $vm | Get-Datastore 
	foreach($ds in $dstores){ 
		$row = "" | select VMNAME, DATASTORE, Cluster 
		$row.VMNAME = $vm.name 
		$row.DATASTORE = $ds.Name 
		$row.Cluster = $clusterName
		$report += $row 
	} 
} 
$report | `
Sort-Object -Property VMName,Datastore -Unique | `
Group-Object -Property VMName | `
Where-Object { $_.Count -gt 1 } | `
Foreach-Object { 
	foreach ($Record in $_.Group) {$Record } 
} | `
Export-Csv "C:\VM_DS.csv" -NoTypeInformation

Update: I saw that the first line was missing, so I added the first line to the script.

Message was edited by: RvdNieuwendijk

Re: Find/count VMs with 2 or more VMDKs on different Datastores

qwert1235 — Fri, 07 May 2010 18:00:44 GMT

Robert,

Thanks a lot!!!

It's exactly what I was looking for!!!

Thanks again,

qwert

Re: Find/count VMs with 2 or more VMDKs on different Datastores

RvdNieuwendijk — Fri, 07 May 2010 21:29:35 GMT

Inspired by a post by Jason Major, jmajor1111, in thread I came to an even more simple solution:

Get-VM | `
ForEach-Object {
	$vm = $_
	$Datastores = $vm | Get-Datastore
	$Count = ($Datastores | Measure-Object).Count
	if ($Count -ge 2)
	{
		foreach ($ds in $Datastores) {
			$Report = "" | Select-Object -Property VmName, Datastore, Cluster
			$Report.VmName = $vm.Name
			$Report.Datastore = $ds.Name
			$Report.Cluster = ($vm | Get-Cluster).Name
			$Report
		}
	}
}

I even found a bug in the previous script. If you have two VMs with the same name in two different clusters, with both VMs having only one datastore, the previous script will show these VMs. The new script does not.