cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
keys_it
Engaged Sweeper III
I had a requirement that we needed to know what machines had .Net 4 version installed and what release this version fell under. In addition, we needed a separate report for .net 3.5 machines and if they had an SP installed. I could not find a report on the community that fit my needs so I was able to build one that might help out someone in the future.

I used https://docs.microsoft.com/en-us/dotnet/framework/migration-guide/how-to-determine-which-versions-are-installed as a starting point to get version numbers and release numbers.

You first have to setup registry scanning for the following keys:

RegPath - HKLM\SOFTWARE\Microsoft\NET Framework Setup\NDP\v4\Full
RegValue - Version
RegPath - HKLM\SOFTWARE\Microsoft\NET Framework Setup\NDP\v4\Full
RegValue - Release
RegPath - HKLM\SOFTWARE\Microsoft\NET Framework Setup\NDP\v3.5
RegValue - Version
RegPath - HKLM\SOFTWARE\Microsoft\NET Framework Setup\NDP\v3.5
RegValue - SP

Force scan or let your schedule pick up these registry items.

Report Name: Software: .Net 4 Versions
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypename,
tsysOS.OSname As [Operating System],
tsysAssetTypes.AssetTypeIcon10 As icon,
tblRegistry.Value As [.Net Version],
Case
When SubQuery1.Value >= '528040' Then '4.8'
When SubQuery1.Value >= '461808' Then '4.7.2'
When SubQuery1.Value >= '461308' Then '4.7.1'
When SubQuery1.Value >= '460798' Then '4.7'
When SubQuery1.Value >= '394802' Then '4.6.2'
When SubQuery1.Value >= '394254' Then '4.6.1'
When SubQuery1.Value >= '393295' Then '4.6'
When SubQuery1.Value >= '379893' Then '4.5.2'
When SubQuery1.Value >= '378675' Then '4.5.1'
When SubQuery1.Value >= '378389' Then '4.5'
Else 'Registry key not scanned or .Net 4.5 and later not detected'
End As [.Net Release],
tblAssets.IPAddress,
tsysIPLocations.IPLocation As [Office Location],
tblAssets.Lastseen,
tblAssets.Lasttried
From tblAssets
Inner Join tblRegistry On tblAssets.AssetID = tblRegistry.AssetID
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
Left Outer Join tsysIPLocations On tblAssets.IPNumeric >=
tsysIPLocations.StartIP And tblAssets.IPNumeric <= tsysIPLocations.EndIP
Left Join (Select Top 1000000 tblRegistry.AssetID,
tblRegistry.Value
From tblRegistry
Where tblRegistry.Valuename = 'Release' And
tblRegistry.Regkey Like '%NET Framework Setup\NDP\v4\Full') As SubQuery1
On tblAssets.AssetID = SubQuery1.AssetID
Where tblRegistry.Valuename = 'Version' And
tblRegistry.Regkey Like '%NET Framework Setup\NDP\v4\Full' And
tblAssets.Assettype = -1
Order By 'Office Location',
tblAssets.AssetName


Report Name: Software: .Net 3.5 Versions
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypename,
tsysOS.OSname As [Operating System],
tsysAssetTypes.AssetTypeIcon10 As icon,
tblRegistry.Value As [.Net Version],
SubQuery1.Value As [.Net Service Pack],
tblAssets.IPAddress,
tsysIPLocations.IPLocation As [Office Location],
tblAssets.Lastseen,
tblAssets.Lasttried
From tblAssets
Inner Join tblRegistry On tblAssets.AssetID = tblRegistry.AssetID
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
Left Outer Join tsysIPLocations On tblAssets.IPNumeric >=
tsysIPLocations.StartIP And tblAssets.IPNumeric <= tsysIPLocations.EndIP
Left Join (Select Top 1000000 tblRegistry.AssetID,
tblRegistry.Value
From tblRegistry
Where tblRegistry.Valuename = 'SP' And tblRegistry.Regkey Like
'%NET Framework Setup\NDP\v3.5') As SubQuery1 On tblAssets.AssetID =
SubQuery1.AssetID
Where tblRegistry.Valuename = 'Version' And
tblRegistry.Regkey Like '%NET Framework Setup\NDP\v3.5' And
tblAssets.Assettype = -1
Order By 'Office Location',
tblAssets.AssetName
2 REPLIES 2
kosta
Engaged Sweeper II
Hi,

thank you for the report!

What do I need to change in the report in order to show me the computers that DO NOT HAVE dotnet 3.5 installed?
ErikT
Lansweeper Tech Support
Lansweeper Tech Support
Hi keys_it,

Thank you for sharing this! I'm sure many other people will find this very useful.