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 Microsoft EDGE browser support
by  Vapoured   Go to last post Go to first unread
Last post: Today at 4:54:30 AM(UTC)
Lansweeper Asset Management - Unattached assets
by  MrDiamond  
Go to last post Go to first unread
Last post: Yesterday at 8:15:16 PM(UTC)
Lansweeper Help Desk not disabling for regular users?
by  Maveritsch   Go to last post Go to first unread
Last post: Yesterday at 3:22:03 PM(UTC)
Lansweeper Lansweeper Fresh Install Hanging, High CPU, Unusable
by  ebars  
Go to last post Go to first unread
Last post: 11/24/2020 7:53:38 PM(UTC)
Lansweeper Forwarding tickets to regular email recipents
by  ChristerT   Go to last post Go to first unread
Last post: 11/24/2020 9:48:15 AM(UTC)
Lansweeper Outlook task and calendar
by  Squack the Duck  
Go to last post Go to first unread
Last post: 11/24/2020 12:40:37 AM(UTC)
Lansweeper Cap on number of routers?
by  MarkPayton   Go to last post Go to first unread
Last post: 11/23/2020 10:04:12 PM(UTC)
Lansweeper Authenticate from CLI
by  blunderdog  
Go to last post Go to first unread
Last post: 11/23/2020 9:57:04 PM(UTC)