Asset: Vpro AMT available

[Michael_V]

This report shows all windows computer with vPro AMT version


Meets all the following criteria:
- Active asset
- Windows asset
- Intel vPro available

Sorted on:
- Asset name

Select Top 1000000 tblAssets.AssetID,
  tblAssets.AssetName,
  tsysAssetTypes.AssetTypename,
  tsysAssetTypes.AssetTypeIcon10 As icon,
  tblAssets.IPAddress,
  tblAssets.Lastseen,
  tblAssets.Lasttried,
  tblVproAMT.HTTPS,
  tblVproAMT.HTTPVersion,
  tblVproAMT.RMCPPingVersion,
  tblVproAMT.RMCPPingStatus
From tblAssets
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
  Inner Join tblVproAMT On tblAssets.AssetID = tblVproAMT.AssetID
Where (tblVproAMT.HTTPVersion <> '' Or tblVproAMT.RMCPPingVersion <> '') And
  tblAssetCustom.State = 1 And tblAssets.Assettype = -1
Order By tblAssets.AssetName