Assets with .Net Framework lower than 4.7.2

[Esben_D]

This report displays all assets which have a .Net framework version lower than 4.7.2

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 Windows asset.
  
• The asset has the following registry key and value scanned:
  
  • Key: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\NET Framework Setup\NDP\v4\Full\1033
    
  • Value: release

To learn more about how to scan registry keys, you can go over this knowledgebase article.

Select Top 1000000 tblAssets.AssetID,
  tblAssets.AssetName,
  tblAssets.Domain,
  tsysAssetTypes.AssetTypename,
  tsysAssetTypes.AssetTypeIcon10 As icon,
  tblAssets.IPAddress,
  tblAssets.Lastseen,
  tblAssets.Lasttried,
  tblRegistry.Regkey,
  tblRegistry.Valuename,
  Cast(tblRegistry.Value As int) As Value
From tblAssets
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
  Inner Join tblRegistry On tblAssets.AssetID = tblRegistry.AssetID
Where
  tblRegistry.Regkey =
  'HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\NET Framework Setup\NDP\v4\Full\1033'
  And tblRegistry.Valuename = 'release' And Cast(tblRegistry.Value As int) <
  461808 And tblAssetCustom.State = 1
Order By Value Desc,
  tblAssets.Domain,
  tblAssets.AssetName