Notification

Icon
Error

.Net 4 version report - Registry Key based - Reports versions of .Net 4.5 through 4.8 and converts build number to human readable version

Posted: Wednesday, June 12, 2019 6:25:10 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

--Used to reference reg keys to Version numbers, for future updates to the query
--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

Active Discussions

Action Remote Uninstaller
by  miek_g   Go to last post Go to first unread
Last post: 10/28/2020 3:52:20 PM(UTC)
Action Setting Computer AD Description Attribute
by  DJSMC  
Go to last post Go to first unread
Last post: 10/27/2020 12:39:54 PM(UTC)
Action Open Teams/SfB Chat with user
by  marceman   Go to last post Go to first unread
Last post: 9/10/2020 4:10:18 PM(UTC)
Lansweeper Report showing app even after it has gone
by  TimHolmes1973  
Go to last post Go to first unread
Last post: 9/9/2020 11:50:17 PM(UTC)
Action Remote Device Manager
by  steveb   Go to last post Go to first unread
Last post: 9/4/2020 9:52:01 PM(UTC)
Action View Windows Defender detections remotely
by  steveb  
Go to last post Go to first unread
Last post: 9/4/2020 9:37:48 PM(UTC)
Lansweeper Filter Assets' groups by WinSystemLocale
by  Alex Beaumier   Go to last post Go to first unread
Last post: 8/20/2020 4:17:17 PM(UTC)
Action Chrome History
by  csys  
Go to last post Go to first unread
Last post: 8/14/2020 2:14:21 PM(UTC)