topic Re: List all VM's in a virtual centre running windows XP OS in VMware PowerCLI Discussions

List all VM's in a virtual centre running windows XP OS

Guv — Fri, 24 Feb 2017 10:50:26 GMT

Is it possible to get a script which will list all VM's in a virtual centre which is running windows XP OS. And also which vmware datacentre they are in.

That would be great to have in a csv format

Re: List all VM's in a virtual centre running windows XP OS

iamamit — Fri, 24 Feb 2017 11:24:22 GMT

This should help in exactly what you want.. Just you need to work on CSV file alignment little-bit..

http://www.techiessphere.com/2017/02/managing-guest-os-software-or-database-license-inventory-using-vSphere.html

Refer the to the command section of this article (Step-3).

Get-VM | select Name, Guest | Export-CSV D:\test.csv

It should do for you. I am not sure if Datacentre column can be fit in the report.. will try and let you know..

Thanks,

Amit

Re: List all VM's in a virtual centre running windows XP OS

iamamit — Fri, 24 Feb 2017 11:38:27 GMT

Ok, so here is the command you can use to get the VM Name, Guest OS Details and Datacenter Details...

Get-VM | Select Name, Guest, @{N="Datacenter";E={Get-Datacenter -VM $_}}

To export the result in CSV, you can use it like below:

Get-VM | Select Name, Guest, @{N="Datacenter";E={Get-Datacenter -VM $_}} | Export-Csv D:\Test.CSV

Thanks,

Amit

Re: List all VM's in a virtual centre running windows XP OS

Guv — Mon, 27 Feb 2017 15:47:39 GMT

Thanks for the replies.

Is there anyway we can list out only the VM's with windows XP OS, as the above scripts lists out all VM's

Re: List all VM's in a virtual centre running windows XP OS

LucD — Mon, 27 Feb 2017 17:20:54 GMT

Try like this

Get-VM |

where{$_.Guest.OSFullName -match "XP"} |

Select Name,@{N='GuestOS';E={$_.Guest.OSFullName}}

Re: List all VM's in a virtual centre running windows XP OS

iamamit — Mon, 27 Feb 2017 17:32:03 GMT

You may try below one, should work for filtering only "Windows Xp" guest VMs.

--------------------------------------------------------------------------------------------------------------------------

$vms = Get-VM

Foreach ($vm in $vms){

if ((Get-View $vm).Guest.GuestFullName -match "windows xp"){

Write-Host $vm.Name, " => " , (Get-View $vm).Guest.GuestFullName

}

--------------------------------------------------------------------------------------------------------------------------

You can check keeping "Xp" instead of "Windows Xp", it should also work..

Thanks,

Amit