Notification

Icon
Error

.Net 4.5 through 4.8 report - Reg Key scanning based - Reports on versions of .net installed from 4.5 to 4.8

Posted: Wednesday, June 12, 2019 6:30:05 PM(UTC)
Noobmode

Noobmode

Member Original PosterPosts: 16
0
Like
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tsysAssetTypes.AssetTypename,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.IPAddress,
tblAssets.Lastseen,
tblAssets.Lasttried,
tblRegistry.Regkey,
tblRegistry.Valuename,
tblRegistry.Value As Build,
Version = Case tblRegistry.Value
When '378389' Then '4.5'
When '378675' Then '4.5.1'
When '378758' Then '4.5.1'
When '379893' Then '4.5.2'
When '393295' Then '4.6'
When '393297' Then '4.6'
When '394254' Then '4.6.1'
When '394271' Then '4.6.1'
When '394802' Then '4.6.2'
When '394806' Then '4.6.2'
When '460798' Then '4.7'
When '460805' Then '4.7'
When '461308' Then '4.7.1'
When '461310' Then '4.7.1'
When '461808' Then '4.7.2'
When '461814' Then '4.7.2'
When '528040' Then '4.8'
When '528049' Then '4.8'
Else '?'
End
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tblRegistry On tblAssets.AssetID = tblRegistry.AssetID
Where
tblRegistry.Regkey =
'HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\NET Framework Setup\NDP\v4\Full' And
tblRegistry.Valuename = 'release' And tblAssetCustom.State = 1
Order By Build,
tblAssets.AssetName

--Dot Net Framework versions and dependencies
--Used to reference reg keys to Version numbers
--https://docs.microsoft.com/en-us/dotnet/framework/migration-guide/versions-and-dependencies
--https://docs.microsoft.com/en-us/dotnet/framework/migration-guide/how-to-determine-which-versions-are-installed
nekrosoft13
#1nekrosoft13 Member Posts: 15  
posted: 8/4/2019 4:17:53 AM(UTC)
getting this error

There was an error parsing the query. [ Token line number = 1,Token line offset = 311,Token in error = = ]
Martin Schulz
#2Martin Schulz Member Posts: 1  
posted: 12/11/2019 11:55:24 AM(UTC)
The code above works for SQL Express databases. If you use SQL Compact, you can use the following.

Select Top 1000000 tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.AssetName,
tblAssets.Domain,
Case tblRegistry.Value
When '378389' Then '4.5'
When '378675' Then '4.5.1'
When '378758' Then '4.5.1'
When '379893' Then '4.5.2'
When '393295' Then '4.6'
When '393297' Then '4.6'
When '394254' Then '4.6.1'
When '394271' Then '4.6.1'
When '394802' Then '4.6.2'
When '394806' Then '4.6.2'
When '460798' Then '4.7'
When '460805' Then '4.7'
When '461308' Then '4.7.1'
When '461310' Then '4.7.1'
When '461808' Then '4.7.2'
When '461814' Then '4.7.2'
When '528040' Then '4.8'
When '528049' Then '4.8'
Else '?'
End As Version,
tblAssets.IPAddress,
tblAssets.Lastseen,
tblAssets.Lasttried
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tblRegistry On tblAssets.AssetID = tblRegistry.AssetID
Where
tblRegistry.Regkey =
'HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\NET Framework Setup\NDP\v4\Full' And
tblRegistry.Valuename = 'release' And tblAssetCustom.State = 1
Order By tblRegistry.Value,
tblAssets.AssetName

Active Discussions

Action Remote Uninstaller
by  hirogen   Go to last post Go to first unread
Last post: 7/15/2021 2:09:47 PM(UTC)
Lansweeper uVNC Portable (trying to replace LSRemote)
by  CyberCitizen  
Go to last post Go to first unread
Last post: 6/15/2021 11:40:21 PM(UTC)
Action Password Status
by  steveb   Go to last post Go to first unread
Last post: 5/20/2021 5:24:13 PM(UTC)
Lansweeper Verify a successful copy to user computer
by  Brandon  
Go to last post Go to first unread
Last post: 4/22/2021 9:09:50 PM(UTC)
Lansweeper Pablo
by  Pablo   Go to last post Go to first unread
Last post: 4/20/2021 8:05:07 PM(UTC)
Lansweeper Can Actions work when using when using a Ubuntu machine
by  mzipperer  
Go to last post Go to first unread
Last post: 4/1/2021 10:16:34 PM(UTC)
Lansweeper Remove user from local admin group
by  jhartley@alcona-county.net   Go to last post Go to first unread
Last post: 3/24/2021 4:27:30 PM(UTC)
Lansweeper Network Scanning
by  MZU  
Go to last post Go to first unread
Last post: 3/7/2021 8:23:10 AM(UTC)