vmware cli script assistance

meanwhile, when we login vcenter, at VM Summary tab, it will show whether the vm require Upgrade / install Vmware tools, how may i collect this info also via cli

Do you need a script or will RVTools do ?

https://www.robware.net/rvtools/

Hi, i prefer a script

You can use this to get tools versions
Get-VM | Select-Object -Property Name,@{Name='ToolsVersion';Expression={$_.Guest.ToolsVersion}}
https://blogs.vmware.com/PowerCLI/2018/09/discovering-vms-with-specific-vmware-tools-versions.html 

or you can try this
Get-VM | Select Name,
    @{N="Tools Installed";E={$_.Guest.ToolsVersion -ne ""}},
    @{N="Tools Status";E={$_.ExtensionData.Guest.ToolsStatus}},
    @{N="Tools version";E={if($_.Guest.ToolsVersion -ne ""){$_.Guest.ToolsVersion}}}

How can i combine both below command together

1.get-vm | Select-Object Name, Powerstate
2.get-vm | select -expandproperty ExtensionData | select -expandproperty Guest | Select ToolsStatus, ToolsVersionStatus, ToolsVersionStatus2, ToolsRunningStatus,ToolsVersion

When i running below command, i could not get vm name and its powersate. The rest of output looks fine.

get-vm | Select-Object Name, Powerstate, ExtensionData | select -expandproperty ExtensionData | select -expandproperty Guest | Select ToolsStatus, ToolsVersionStatus, ToolsVersionStatus2, ToolsRunningStatus,ToolsVersion | Format-Table Name, Powerstate, ToolsStatus, ToolsVersionStatus, ToolsVersionStatus2, ToolsRunningStatus, ToolsVersion