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 Software List by Computer/Server Name
by  Andy.S  
Go to last post Go to first unread
Last post: Yesterday at 8:06:43 AM(UTC)
Lansweeper Asset: Duplicate Serial Number (Built-in)
by  brodiemac-too   Go to last post Go to first unread
Last post: 8/5/2020 1:28:56 PM(UTC)
Lansweeper A Simple Report (or so I thought)
by  Andy.S  
Go to last post Go to first unread
Last post: 8/5/2020 11:30:45 AM(UTC)
Lansweeper Paid Report Writer Service
by  endyk   Go to last post Go to first unread
Last post: 8/4/2020 11:56:20 AM(UTC)
Lansweeper Multiple Computers per User
by  brodiemac-too  
Go to last post Go to first unread
Last post: 7/30/2020 12:43:38 PM(UTC)
Lansweeper Workstations with No AV
by  brodiemac-too   Go to last post Go to first unread
Last post: 7/29/2020 7:44:53 PM(UTC)
Lansweeper AV Audit Report
by  RC62N  
Go to last post Go to first unread
Last post: 7/29/2020 5:17:42 PM(UTC)