Notification

Icon
Error

.Net 3.5 and .Net 4 Detail Reports

Posted: Tuesday, April 7, 2020 10:34:57 PM(UTC)
keys_it

keys_it

Member Original PosterPosts: 31
0
Like
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.c...h-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
Code:
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
Code:
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
Erik.T
#1Erik.T Member Administration Posts: 99  
posted: 4/9/2020 1:54:24 PM(UTC)
Hi keys_it,

Thank you for sharing this! I'm sure many other people will find this very useful.
Kkadysh
#2Kkadysh Member Posts: 6  
posted: 6/25/2020 11:51:06 AM(UTC)
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?

Active Discussions

Lansweeper HP Warranty scan - broken for some products
by  TBMPS   Go to last post Go to first unread
Last post: Yesterday at 3:13:19 PM(UTC)
Lansweeper Assets with different MACs/IPs getting merged
by  MartinO  
Go to last post Go to first unread
Last post: 10/23/2020 3:15:25 PM(UTC)
Lansweeper Where is Extension Attribute 1
by  CoolDood   Go to last post Go to first unread
Last post: 10/22/2020 8:45:46 PM(UTC)
Lansweeper Accessing IMEI/MEID fields for manual assets
by  Tom Londe  
Go to last post Go to first unread
Last post: 10/22/2020 5:31:27 PM(UTC)
Lansweeper Server 2019 Version Numbers
by  MCBowman  
Go to last post Go to first unread
Last post: 10/22/2020 2:35:32 PM(UTC)