# !!! Warning !!! To run this script you need download and install VMware Power-CLI from vmware web site
get-vm |
#
# This filter allow parameter "toolsOK", "toolsNotRunning", "toolsNotInstalled", "toolsOld"
# Unmark line bellow to run filter
#Where-Object {$_.ExtensionData.Guest.ToolsStatus -ne "toolsOK"}|
#
#This filter to sort by type of OS Family. Allow parameter "*Windows*", "*Linux*", "Other"
#Unmark line bellow to run filter
Where-Object {$_.ExtensionData.Guest.guestFamily -notlike "*Windows*" }|
#
# This filer to sort by VMWare Tools Version.
# Unmark line bellow to run filter
#Where-Object {$_.ExtensionData.config.tools.toolsVersion -eq "9216"} |
#
%{ get-view $_.ID } |
select Name, @{ Name="hostName"; Expression={$_.guest.hostName}}, '
@{ Name="ToolsStatus"; Expression={$_.guest.toolsstatus}}, @{ Name="ToolsVersion"; '
Expression={$_.config.tools.toolsVersion}} |
# Export to csv-file.Open csv-file in Notepad and add first
#line "sep=," without " symbol. Just now will be open file in Microsoft Excel.
#
sort-object name | export-csv VMwareToolsReport.csv
|
