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 Ticket Content Default Value
by  CPG   Go to last post Go to first unread
Last post: Today at 8:45:12 PM(UTC)
Lansweeper New status to mimic Closed
by  chris.anderson  
Go to last post Go to first unread
Last post: Today at 7:14:27 PM(UTC)
Lansweeper Active Directory Groups not scanned properly
by  cross_eur   Go to last post Go to first unread
Last post: Today at 5:45:00 PM(UTC)
Lansweeper Change Management - Voting and Tracking
by  brodiemac-too  
Go to last post Go to first unread
Last post: Today at 2:48:01 PM(UTC)
Lansweeper No incoming Mails after update 8.4.100.9
by  EDELL   Go to last post Go to first unread
Last post: Today at 2:38:50 PM(UTC)
Lansweeper Anti-Virus on Mac
by  Ian.Prentice  
Go to last post Go to first unread
Last post: Today at 9:30:32 AM(UTC)
Lansweeper how to scan intune managed win10 clients?
by  brodiemac-too   Go to last post Go to first unread
Last post: Yesterday at 9:17:07 PM(UTC)
Lansweeper Sort by in Helpdesk
by  brodiemac-too  
Go to last post Go to first unread
Last post: Yesterday at 9:15:05 PM(UTC)