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: 14
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: 13  
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

Lansweeper Jan 2020 Patch Tuesday Report
by  zor999   Go to last post Go to first unread
Last post: Today at 7:36:42 PM(UTC)
Lansweeper Asset config history
by  Chris C.  
Go to last post Go to first unread
Last post: Today at 7:16:15 PM(UTC)
Lansweeper Registry report
by  Jac   Go to last post Go to first unread
Last post: Today at 5:15:00 PM(UTC)
Lansweeper Pull Description from Active Directory
by  Jeff HLava  
Go to last post Go to first unread
Last post: Today at 3:17:10 PM(UTC)
Lansweeper Manually added assets
by  Elmar  
Go to last post Go to first unread
Last post: Today at 11:55:49 AM(UTC)
Lansweeper Updating asset custom fields from Excel
by  steveb   Go to last post Go to first unread
Last post: Yesterday at 7:16:52 PM(UTC)
Lansweeper Changes in the licensing model
by  SolusMIB  
Go to last post Go to first unread
Last post: Yesterday at 6:47:47 PM(UTC)