topic Re: Get Guest OS disks letter in VMware PowerCLI Discussions

Get Guest OS disks letter

lElOUCHE_79 — Thu, 09 Nov 2023 09:42:24 GMT

I find this script in the community Get List of VMs, Datastores and VMDK / path per Cluster

I would like to exclude vCLS from output and get also the below information

Drive Letter, Storage Format, Size, free space

I believe that I'm tackling this in wrong way.

Any idea?

Re: Get Guest OS disks letter

LucD — Thu, 09 Nov 2023 09:51:14 GMT

That is a rather old thread.
To exclude the vCLS VMs you could add a Where-clause

ForEach ($VM in ($Cluster | Get-VM | where{$_.Name -notmatch '^vcls'} | Sort-Object -Property Name)) {

To link this to Guest OS disk info you can use the Get-VMGuestDisk cmdlet, provided all the prerequisites for that cmdlet are fulfilled.

Re: Get Guest OS disks letter

lElOUCHE_79 — Thu, 09 Nov 2023 10:00:37 GMT

Thanks LuD, it's OK for excluding the vCLS.

Not sure how to use the cmdlet Get-VMGuestDisk in the script

can you assist ?

Re: Get Guest OS disks letter

LucD — Thu, 09 Nov 2023 11:36:28 GMT

You could do something like this, but be aware that there can be more than 1 guest partition on a VMDK.
Hence the -join operator

Also, if the Get-VMGuestDisk does not return anything, those Guest* properties will be empty.

$VmInfo = ForEach ($Datacenter in (Get-Datacenter | Sort-Object -Property Name)) { ForEach ($Cluster in ($Datacenter | Get-Cluster | Sort-Object -Property Name)) { ForEach ($VM in ($Cluster | Get-VM | where{$_.Name -notmatch '^vcls'} | Sort-Object -Property Name)) { ForEach ($HardDisk in ($VM | Get-HardDisk | Sort-Object -Property Name)) { $guestHD = Get-VMGuestDisk -HardDisk $HardDisk "" | Select-Object -Property @{N="VM";E={$VM.Name}}, @{N="Datacenter";E={$Datacenter.name}}, @{N="Cluster";E={$Cluster.Name}}, @{N="Hard Disk";E={$HardDisk.Name}}, @{N="Datastore";E={$HardDisk.FileName.Split("]")[0].TrimStart("[")}}, @{N="VMConfigFile";E={$VM.ExtensionData.Config.Files.VmPathName}}, @{N="VMDKpath";E={$HardDisk.FileName}}, @{N="VMDK Size";E={($vm.extensiondata.layoutex.file|?{$_.name -contains $harddisk.filename.replace(".","-flat.")}).size/1GB}}, @{N="Drive Size";E={$HardDisk.CapacityGB}}, @{N='GuestDiskPath';E={$guestHD.DiskPath}}, @{N='GuestCapacityGB';E={$guestHD.CapacityGB}}, @{N='GuestFreeGB';E={$guestHD.FreeSpaceGB}}, @{N='GuestDiskType';E={$guestHD.FileSystemType}} } } } } $VmInfo | Export-Csv -NoTypeInformation -UseCulture -Path "C:\VmInfo4.csv"

Re: Get Guest OS disks letter

lElOUCHE_79 — Thu, 09 Nov 2023 14:27:05 GMT

Thanks again it's working but we are missing the drive letter is that possible?

Re: Get Guest OS disks letter

LucD — Thu, 09 Nov 2023 14:46:40 GMT

No, I'm getting the drive letter under the GuestDiskPath property.
Is Get-VMGuestDisk returning the letter for those VMs?
It might be an issue with the cmdlet for a specific Guest OS and/or VMware Tools version.

I seem to have forgotten the -join operator I mentioned earlier.

$VmInfo = ForEach ($Datacenter in (Get-Datacenter | Sort-Object -Property Name)) { ForEach ($Cluster in ($Datacenter | Get-Cluster | Sort-Object -Property Name)) { ForEach ($VM in ($Cluster | Get-VM | where{$_.Name -notmatch '^vcls'} | Sort-Object -Property Name)) { ForEach ($HardDisk in ($VM | Get-HardDisk | Sort-Object -Property Name)) { $guestHD = Get-VMGuestDisk -HardDisk $HardDisk "" | Select-Object -Property @{N="VM";E={$VM.Name}}, @{N="Datacenter";E={$Datacenter.name}}, @{N="Cluster";E={$Cluster.Name}}, @{N="Hard Disk";E={$HardDisk.Name}}, @{N="Datastore";E={$HardDisk.FileName.Split("]")[0].TrimStart("[")}}, @{N="VMConfigFile";E={$VM.ExtensionData.Config.Files.VmPathName}}, @{N="VMDKpath";E={$HardDisk.FileName}}, @{N="VMDK Size";E={($vm.extensiondata.layoutex.file|?{$_.name -contains $harddisk.filename.replace(".","-flat.")}).size/1GB}}, @{N="Drive Size";E={$HardDisk.CapacityGB}}, @{N='GuestDiskPath';E={$guestHD.DiskPath -join '|'}}, @{N='GuestCapacityGB';E={$guestHD.CapacityGB -join '|'}}, @{N='GuestFreeGB';E={$guestHD.FreeSpaceGB -join '|'}}, @{N='GuestDiskType';E={$guestHD.FileSystemType -join '|'}} } } } } $VmInfo | Export-Csv -NoTypeInformation -UseCulture -Path "C:\VmInfo4.csv"

Re: Get Guest OS disks letter

lElOUCHE_79 — Thu, 09 Nov 2023 16:50:47 GMT

Thanks LucD it's working fine.

for VMDK Size & Drive Size they are in GB, right?

I made a change in order to get data without "." unfortunately GuestCapacityGB and GuestFreeGB are Empty

@{N='GuestCapacityGB';E={([Math]::Round($guestHD.CapacityGB)/1GB,0) -join "`n"}},

@{N='GuestFreeGB';E={([Math]::Round($guestHD.FreeSpaceGB)/1GB,0) -join "`n"}},

Re: Get Guest OS disks letter

LucD — Thu, 09 Nov 2023 18:00:36 GMT

Yes, that is why I added GB to the property name.

Try like this

@{N='GuestCapacityGB';E={($guestHD.CapacityGB.foreach{[math]::Round($_)}) -join '|'}}, @{N='GuestFreeGB';E={($guestHD.FreeSpaceGB.foreach{[math]::Round($_)}) -join '|'}},

Re: Get Guest OS disks letter

lElOUCHE_79 — Thu, 09 Nov 2023 19:03:51 GMT

for this line, I tried multiple ways to get things like other lines unfortunately without success

@{N="VMDK Size";E={($vm.extensiondata.layoutex.file|Where-Object{$_.name -contains $harddisk.filename.replace(".","-flat.")}).size/1GB}}

by the way, do you know why for some VMs the below details are missing?

Is it related to Guest OS? vmwareTools?

GuestDiskPath GuestCapacityGB GuestFreeGB GuestDiskType

Re: Get Guest OS disks letter

LucD — Thu, 09 Nov 2023 19:32:54 GMT

You mean like this?

@{N="VMDK Size";E={[math]::Round(($vm.extensiondata.layoutex.file|?{$_.name -contains $harddisk.filename.replace(".","-flat.")}).size/1GB)}},

Like I said earlier, this Get-VMGuestDisk doesn't always work.
There are many prerequisites for this cmdlet and VMware Tools to return values.

Re: Get Guest OS disks letter

lElOUCHE_79 — Fri, 10 Nov 2023 11:05:25 GMT

Thanks LucD as always, you help me a lot.

the script is working fine and I tried to add some details related to VM and I made it like this, unfortunately, I get an error message related to this line **$guestHD = Get-VMGuestDisk -HardDisk $HardDisk**

what's wrong in the modified script?

$VmInfo = ForEach ($Datacenter in (Get-Datacenter | Sort-Object -Property Name)) {

ForEach ($Cluster in ($Datacenter | Get-Cluster | Sort-Object -Property Name)) {

ForEach ($VM in ($Cluster | Get-VM | Where-Object{$_.Name -notmatch '^vcls'} | Sort-Object -Property Name)) {

ForEach ($HardDisk in ($VM | Get-HardDisk | Sort-Object -Property Name)) {

foreach ($VM in (Get-View -ViewType VirtualMachine -Property Guest.GuestFullName, Config.GuestFullName)){

$guestHD = Get-VMGuestDisk -HardDisk $HardDisk

"" | Select-Object -Property @{N="VM";E={$VM.Name}},

@{N="Configured OS";E={$Config.GuestFullName}},

@{N="Running OS";E={$Guest.GuestFullName}},

@{N="Datacenter";E={$Datacenter.name}},

@{N="Cluster";E={$Cluster.Name}},

@{N="Hard Disk";E={$HardDisk.Name}},

@{N="Datastore";E={$HardDisk.FileName.Split("]")[0].TrimStart("[")}},

@{N="VMConfigFile";E={$VM.ExtensionData.Config.Files.VmPathName}},

@{N="VMDKpath";E={$HardDisk.FileName}},

@{N="VMDK Size";E={[math]::Round(($vm.extensiondata.layoutex.file|Where-Object{$_.name -contains $harddisk.filename.replace(".","-flat.")}).size/1GB)}},

@{N="Drive Size";E={$HardDisk.CapacityGB.foreach{[math]::Round($_)}}},

@{N='GuestDiskPath';E={$guestHD.DiskPath -join "`n"}},

@{N='GuestCapacityGB';E={($guestHD.CapacityGB.foreach{[math]::Round($_)}) -join "`n"}},

@{N='GuestFreeGB';E={($guestHD.FreeSpaceGB.foreach{[math]::Round($_)}) -join "`n"}},

@{N='GuestDiskType';E={$guestHD.FileSystemType -join "`n"}}

}

$VmInfo | Export-Csv -NoTypeInformation -UseCulture -Path ".\VmInfo.csv"

Re: Get Guest OS disks letter

LucD — Fri, 10 Nov 2023 11:38:07 GMT

What exactly does the error say?

That line with Get-View is not needed.
You can get those values also from the original $vm variable.

$VmInfo = ForEach ($Datacenter in (Get-Datacenter | Sort-Object -Property Name)) { ForEach ($Cluster in ($Datacenter | Get-Cluster | Sort-Object -Property Name)) { ForEach ($VM in ($Cluster | Get-VM | Where-Object{$_.Name -notmatch '^vcls'} | Sort-Object -Property Name)) { ForEach ($HardDisk in ($VM | Get-HardDisk | Sort-Object -Property Name)) { $guestHD = Get-VMGuestDisk -HardDisk $HardDisk "" | Select-Object -Property @{N="VM";E={$VM.Name}}, @{N="Configured OS";E={$vm.ExtensionData.Config.GuestFullName}}, @{N="Running OS";E={$vm.ExtensionData.Guest.GuestFullName}}, @{N="Datacenter";E={$Datacenter.name}}, @{N="Cluster";E={$Cluster.Name}}, @{N="Hard Disk";E={$HardDisk.Name}}, @{N="Datastore";E={$HardDisk.FileName.Split("]")[0].TrimStart("[")}}, @{N="VMConfigFile";E={$VM.ExtensionData.Config.Files.VmPathName}}, @{N="VMDKpath";E={$HardDisk.FileName}}, @{N="VMDK Size";E={[math]::Round(($vm.extensiondata.layoutex.file|Where-Object{$_.name -contains $harddisk.filename.replace(".","-flat.")}).size/1GB)}}, @{N="Drive Size";E={$HardDisk.CapacityGB.foreach{[math]::Round($_)}}}, @{N='GuestDiskPath';E={$guestHD.DiskPath -join "`n"}}, @{N='GuestCapacityGB';E={($guestHD.CapacityGB.foreach{[math]::Round($_)}) -join "`n"}}, @{N='GuestFreeGB';E={($guestHD.FreeSpaceGB.foreach{[math]::Round($_)}) -join "`n"}}, @{N='GuestDiskType';E={$guestHD.FileSystemType -join "`n"}} } } } } $VmInfo | Export-Csv -NoTypeInformation -UseCulture -Path ".\VmInfo.csv"

Re: Get Guest OS disks letter

lElOUCHE_79 — Fri, 10 Nov 2023 12:28:40 GMT

sorry I didn't add the error message: "11/10/2023 12:00:00 PM Get-VMGuestDisk An error occurred while sending the request."

Re: Get Guest OS disks letter

LucD — Fri, 10 Nov 2023 12:31:44 GMT

I haven't seen that one yet.
Sounds like an issue in the communication to the VMware Tools in the Guest OS.
Are the VMware Tools running?
Can you try a restart of the VMware Tools?

Re: Get Guest OS disks letter

lElOUCHE_79 — Fri, 10 Nov 2023 14:32:35 GMT

the issue is related to my modified script, once I used the one you shared it's fine and OK