Vmware: tools unmanaged (Built-in)

[Daniel_B]

The report below lists all VMware guests with unmanaged tools.

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 host/guest.
  
• The asset has unmanaged tools.
  

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 As Guest,
  tblVmwareGuest.IsRunning As State
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 = 4 Then 'Unmanaged'
  End) = 'Unmanaged' And tblState.Statename = 'Active'
Order By tblAssets.IPNumeric,
  tblAssets.AssetName,
  Guest