topic powercli get guest OS version reported by VMware tools versus configured when VM created or edited. in VMware PowerCLI Discussions

powercli get guest OS version reported by VMware tools versus configured when VM created or edited.

mprobst — Fri, 29 May 2015 00:16:38 GMT

in my inventory scripts and in what RV tools outputs I get the OS version that is selected for the VM in edit settings - options - version. I would like to also output a list of the OS version that VMware tools is reporting so I can find the ones with wrong OS selected and fix them. I have tried .extensiondata.config.tools and I dont see the OS listed there, does anyone know where it is listed?

PowerCLI C:\Program Files (x86)\VMware\Infrastructure\vSphere PowerCLI> $vm1.extensiondata.config.tools

ToolsVersion : 9354

AfterPowerOn : True

AfterResume : True

BeforeGuestStandby : True

BeforeGuestShutdown : True

BeforeGuestReboot :

ToolsUpgradePolicy : upgradeAtPowerCycle

PendingCustomization :

SyncTimeWithHost : True

LastInstallInfo : VMware.Vim.ToolsConfigInfoToolsLastInstallInfo

DynamicType :

DynamicProperty :

side note, where can I find a resource that shows what options are available for each get command, like get-host and get-vm? I am learning a lot about what I can find in powercli by running this command and exploring the ones that return VMware.Vim......, but would save me a lot of time to be able to just go look it up.

PowerCLI C:\Program Files (x86)\VMware\Infrastructure\vSphere PowerCLI> $vm1 = get-vm test-vm1

PowerCLI C:\Program Files (x86)\VMware\Infrastructure\vSphere PowerCLI> $vm1.extensiondata

Capability : VMware.Vim.VirtualMachineCapability

Config : VMware.Vim.VirtualMachineConfigInfo

Layout : VMware.Vim.VirtualMachineFileLayout

LayoutEx : VMware.Vim.VirtualMachineFileLayoutEx

Storage : VMware.Vim.VirtualMachineStorageInfo

EnvironmentBrowser : EnvironmentBrowser-envbrowser-653

ResourcePool : ResourcePool-resgroup-11

ParentVApp :

ResourceConfig : VMware.Vim.ResourceConfigSpec

Runtime : VMware.Vim.VirtualMachineRuntimeInfo

Guest : VMware.Vim.GuestInfo

Summary : VMware.Vim.VirtualMachineSummary

Datastore : {Datastore-datastore-591}

Network : {Network-network-145}

Snapshot :

RootSnapshot : {}

GuestHeartbeatStatus : green

LinkedView :

Parent : Folder-group-v41

CustomValue : {}

OverallStatus : green

ConfigStatus : green

ConfigIssue : {}

EffectiveRole : {-1}

Permission : {}

Name : test-vm1

DisabledMethod : {Destroy_Task, UnregisterVM, RevertToCurrentSnapshot_Task, RemoveAllSnapshots_Task...}

RecentTask : {}

DeclaredAlarmState : {alarm-10.vm-653, alarm-11.vm-653, alarm-2.vm-653, alarm-23.vm-653...}

TriggeredAlarmState : {}

AlarmActionsEnabled : True

Tag : {}

Value : {}

AvailableField : {FA.GosAgent}

MoRef : VirtualMachine-vm-653

Client : VMware.Vim.VimClientImpl

Re: powercli get guest OS version reported by VMware tools versus configured when VM created or edited.

LucD — Fri, 29 May 2015 05:33:10 GMT

Try $vm.ExtensionData.Guest.GuestFullName

Re: powercli get guest OS version reported by VMware tools versus configured when VM created or edited.

MKguy — Fri, 29 May 2015 09:19:22 GMT

You can use this one-liner to get a list of VMs with their configured and running Guest OS:

Get-VM | Sort | Get-View -Property @("Name", "Config.GuestFullName", "Guest.GuestFullName") | Select -Property Name, @{N="Configured OS";E={$_.Config.GuestFullName}},  @{N="Running OS";E={$_.Guest.GuestFullName}} | Format-Table -AutoSize

Re: powercli get guest OS version reported by VMware tools versus configured when VM created or edited.

mprobst — Fri, 29 May 2015 13:19:59 GMT

Thank you, this is what I was looking for

Re: powercli get guest OS version reported by VMware tools versus configured when VM created or edited.

jessem — Fri, 19 Feb 2016 17:41:35 GMT

How can I output this to a csv or file?

Get-VM | Sort | Get-View -Property @("Name", "Config.GuestFullName", "Guest.GuestFullName") | Select -Property Name, @{N="Configured OS";E={$_.Config.GuestFullName}},  @{N="Running OS";E={$_.Guest.GuestFullName}} | Format-Table -AutoSize

Re: powercli get guest OS version reported by VMware tools versus configured when VM created or edited.

jessem — Fri, 19 Feb 2016 17:41:57 GMT

How can I get this exported to a csv or excel file?

Get-VM | Sort | Get-View -Property @("Name", "Config.GuestFullName", "Guest.GuestFullName") | Select -Property Name, @{N="Configured OS";E={$_.Config.GuestFullName}},  @{N="Running OS";E={$_.Guest.GuestFullName}} | Format-Table -AutoSize

Re: powercli get guest OS version reported by VMware tools versus configured when VM created or edited.

LucD — Fri, 19 Feb 2016 19:17:55 GMT

Try like this

Get-VM | Sort-Object -Property Name |

Get-View -Property @("Name", "Config.GuestFullName", "Guest.GuestFullName") |

Select -Property Name,

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

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

Export-Csv report.csv -NoTypeInformation -UseCulture

Re: powercli get guest OS version reported by VMware tools versus configured when VM created or edited.

jessem — Fri, 19 Feb 2016 20:03:00 GMT

Worked great! Thanks LucD. Is there any other way to get a few more things out of this report.

vmem

vcpu

datacenter

cluster

vcenter folder or vm folder as example: discovered virtual machines?

Re: powercli get guest OS version reported by VMware tools versus configured when VM created or edited.

LucD — Fri, 19 Feb 2016 20:23:54 GMT

See my reply in the other thread.

Re: powercli get guest OS version reported by VMware tools versus configured when VM created or edited.

MAThompsPCSO — Fri, 02 Dec 2016 02:39:19 GMT

That worked perfectly!

Re: powercli get guest OS version reported by VMware tools versus configured when VM created or edited.

unibn — Thu, 13 Jun 2019 12:23:59 GMT

Hey LucD,

i have a question about your Script.

I only need the output from Config.GuestFullName and i want to include it in my existing Script:

Get-VM -Location test | Select Name,NumCPU,MemoryMB,@{n="HardDiskSizeGB"; e={(Get-HardDisk -VM $_ | Measure-Object -Sum CapacityGB).Sum}},@{n="Date"; e={((Get-Date).ToString('yyyy-MM-dd'))}},@{n="IOLimit"; e={(Get-HardDisk -VM $_).ExtensionData.StorageIOAllocation.Limit | Measure-Object -Sum | Select -ExpandProperty Sum}},@{N="OS";E={$_.Guest.OSFullName}} | Export-Csv -Path "C:\powercli\VM_Report\csv_reports\$csvfile"

With Guest.OSFullName it works fine. But if i replace Guest.OSFullName with Config.GuestFullName, the output is empty.

It would be very kind of you, if you show me, how to include this in my existing Script above.

Ps. How can i paste code with syntax syntax highlighting this forum.

Re: powercli get guest OS version reported by VMware tools versus configured when VM created or edited.

LucD — Thu, 13 Jun 2019 13:13:39 GMT

The Config.GuestFullName is a property under the ExtensionData property.
It is not exposed in the .Net object of a VM, like Guest.OSFullName is.

It is a property in the vSphere VirtualMachine object.

Get-VM -Location test |

Select Name,NumCPU,MemoryMB,

@{n="HardDiskSizeGB"; e={(Get-HardDisk -VM $_ | Measure-Object -Sum CapacityGB).Sum}},

@{n="Date"; e={((Get-Date).ToString('yyyy-MM-dd'))}},

@{n="IOLimit"; e={

(Get-HardDisk -VM $_).ExtensionData.StorageIOAllocation.Limit | Measure-Object -Sum | Select -ExpandProperty Sum}},

@{N="OS";E={$_.Guest.OSFullName}},

@{N= 'AlternateGuestName';E={$_.ExtensionData.Config.GuestFullName}} |

Export-Csv -Path "C:\powercli\VM_Report\csv_reports\$csvfile"

The HTML code can just be copied from the editor window in Visual Studio Code.

Re: powercli get guest OS version reported by VMware tools versus configured when VM created or edited.

unibn — Thu, 13 Jun 2019 13:24:49 GMT

Ah, stupid mistake... Thank you LucD. Regards Henning

Re: powercli get guest OS version reported by VMware tools versus configured when VM created or edit

vasqu — Tue, 27 Apr 2021 01:25:33 GMT

You have most likely figured this out by now you but ill post as it may benefit someone. I needed to get all my Windows servers to build a list to ingest into another script.

I did the following:

$VMs = get-vm

$VMs.extensiondata.guest | where {$_.GuestFullName -like "Microsoft*"} | select HostName,IpAddress,GuestFullName | export-csv c:\temp\WinVMs.csv -NoTypeInformation

You can also condense to one line and not user a variable:

(get-vm).extensiondata.guest | where {$_.GuestFullName -like "Microsoft*"} | select HostName,IpAddress,GuestFullName | export-csv c:\temp\WinVMs.csv -NoTypeInformation

To get this info for all just drop the where statement:

(get-vm).extensiondata.guest | select HostName,IpAddress,GuestFullName | export-csv c:\temp\WinVMs.csv -NoTypeInformation

--OR--

$VMs = get-vm

$VMs.extensiondata.guest | select HostName,IpAddress,GuestFullName | export-csv c:\temp\WinVMs.csv -NoTypeInformation

Re: powercli get guest OS version reported by VMware tools versus configured when VM created or edit

Mdmohiuddinchy — Mon, 26 Jul 2021 10:28:06 GMT

From where to run this commands or script.