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

Lansweeper LSPUSH and Group Policy
by  HurricaneDave   Go to last post Go to first unread
Last post: Yesterday at 10:15:12 PM(UTC)
Lansweeper How to see additional info columns on Asset Groups
by  virtualnik8  
Go to last post Go to first unread
Last post: Yesterday at 7:40:41 PM(UTC)
Lansweeper Certificate status & end dates
by  doone128   Go to last post Go to first unread
Last post: Yesterday at 11:43:46 AM(UTC)
Lansweeper O365
by  Azkor  
Go to last post Go to first unread
Last post: 9/18/2020 10:45:23 PM(UTC)
Lansweeper 2012R2: LSAgent: Could not create SSL/TLS secure channel
by  JimL   Go to last post Go to first unread
Last post: 9/18/2020 6:35:00 AM(UTC)
Lansweeper Biometric Devices
by  FrankSc   Go to last post Go to first unread
Last post: 9/17/2020 6:56:05 PM(UTC)
Lansweeper Auto Assign Agent on First Email Response
by  Elwood472  
Go to last post Go to first unread
Last post: 9/17/2020 4:33:16 PM(UTC)