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 Lost Configuration tab (Admin rights)
by  kspap   Go to last post Go to first unread
Last post: Today at 10:30:12 AM(UTC)
Lansweeper Deployment with different user rights
by  Jupiter_IT  
Go to last post Go to first unread
Last post: Today at 9:39:20 AM(UTC)
Lansweeper cisco fuji device not linking with connected devices
by  char   Go to last post Go to first unread
Last post: Yesterday at 9:12:07 AM(UTC)
Lansweeper Microsoft CVE-2020-1425
by  Richard_B  
Go to last post Go to first unread
Last post: 7/3/2020 4:29:41 PM(UTC)
Lansweeper Wake on Lan in VLANs
by  FrankSc   Go to last post Go to first unread
Last post: 7/3/2020 1:56:46 PM(UTC)
Lansweeper Ticket Closed = email to all helpdesk desk agents
by  Laurent Maene  
Go to last post Go to first unread
Last post: 7/3/2020 1:23:49 PM(UTC)
Lansweeper Helpdek Call Re-Opened
by  pryan67   Go to last post Go to first unread
Last post: 7/3/2020 1:12:17 PM(UTC)
Lansweeper Office 365 32bit vs 64bit?
by  brodiemac-too  
Go to last post Go to first unread
Last post: 7/2/2020 10:35:19 PM(UTC)