cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
zberkshier91
Engaged Sweeper II
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?
1 ACCEPTED SOLUTION
Bruce_B
Lansweeper Alumni
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

View solution in original post

2 REPLIES 2
Bruce_B
Lansweeper Alumni
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
Lansweeper Alumni
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