Vmware: Tools out of date (Built-in)

[Daniel_B]

The report below lists all VMware guests with VMware tools out of date.

The report will only list assets that meet all of the following criteria:

• The asset state is set to "active".
  
• The asset has been successfully scanned at least once.
  
• The asset is a VMware guest.
  
• The asset's VMware tools are out of date.
  

Select Top 1000000 tblAssets.AssetID,
  tblAssets.AssetName,
  tsysAssetTypes.AssetTypeIcon10 As icon,
  tblAssets.IPAddress,
  tsysIPLocations.IPLocation,
  tblAssetCustom.Manufacturer,
  tblAssetCustom.Model,
  tblVmwareInfo.Version,
  tblVmwareInfo.BiosVersion,
  tblAssets.Lastseen,
  tblAssets.Lasttried,
  tblVmwareGuest.Name,
  tblVmwareGuest.IsRunning
From tblAssetCustom
  Inner Join (tblVmwareGuest
  Inner Join tblAssets On tblVmwareGuest.AssetID = tblAssets.AssetID)
    On tblAssetCustom.AssetID = tblAssets.AssetID
  Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
  Inner Join tsysIPLocations On tsysIPLocations.LocationID =
    tblAssets.LocationID
  Inner Join tblState On tblState.State = tblAssetCustom.State
  Inner Join tblVmwareInfo On tblVmwareInfo.AssetID = tblAssets.AssetID
Where (Case When tblVmwareGuest.ToolsVersionStatus = 2 Then 'Out of date'
  End) = 'Out of date' And tblState.Statename = 'Active'
Order By tblAssets.IPNumeric,
  tblAssets.AssetName,
  tblVmwareGuest.Name