Workstations with .NET Framework 4.5.2 or higher

[zberkshier91]

Hello,

I'm looking to build a report for PCs that have .NET Framework 4.5.2 or higher installed. In my research, I've determined that the registry key name is "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\NET Framework Setup\NDP\v4\Full" and has a key labeled "Release"

If .NET framework 4.5.2 is installed, the value this would read is 379893. I'm looking to build a report that will query domain workstations for this key and return results on anything it finds with this version or higher.

How would I structure this in the report builder?

[Bruce_B]

To clarify for future visitors, this report will only return the desired information if you've set up custom registry scanning for the values relevant to this report. For more information on custom registry scanning you can check this knowledgebase article.

[Bruce_B · Accepted solution]

The information retrieved from custom registry scanning is stored in your Lansweeper database in the table tblRegistry, which links back to tblAssets. We've pasted a report below that will list all assets with a 'release' value name, and this value number being greater than 379893. Instructions for adding this report to your Lansweeper installation can be found in this post.

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' And
  tblRegistry.Valuename = 'release' And Cast(tblRegistry.Value As int) > 379893
  And tblAssetCustom.State = 1
Order By tblAssets.Domain,
  tblAssets.AssetName