topic Re: Powershell script to list VMs with attached iso in VMware PowerCLI Discussions

Powershell script to list VMs with attached iso

pasalott — Mon, 01 Aug 2022 19:46:05 GMT

I have a simple powershell script for listing VMs with attached iso's. I would like to add a column for vCenter server but not exactly sure what cmdlet to use.

Connect-VIServer [vcenter1],[vcenter2],[vcenter3],[vcenter4] -User [username] -Password [password] Get-VM | Get-CDDrive | select @{N=”VM”;E=”Parent”},IsoPath | where {$_.IsoPath -ne $null} | Export-Csv -Path “C:\Temp\VMs_ISOs.csv” -NoTypeInformation -UseCulture

Re: Powershell script to list VMs with attached iso

LucD — Mon, 01 Aug 2022 19:51:53 GMT

Try like this

Get-VM | Get-CDDrive | Where-Object { $_.IsoPath -ne $null } | Select-Object @{N = 'VM'; E = {$_.Parent.Name }}, IsoPath, @{N = 'vCenter'; E = { ([uri]($_.Parent.ExtensionData.Client.ServiceUrl)).Host } }

Re: Powershell script to list VMs with attached iso

pasalott — Mon, 01 Aug 2022 20:21:55 GMT

That worked. Thanks