cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Hendrik_VE
Champion Sweeper III
Esben, correct me if I'm wrong, but the color-coded report below gives you an overview of all your scanning servers and indicates (based on .NET version >= 4.6) if they can be upgraded to V7.1.
It also shows you the Scanning Server version and the number of assets scanned per Scanning Server.

Scan the following registry value:
Regpath: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\NET Framework Setup\NDP\v4\Full
Regvalue: Release

Select Top 1000000 tsysOS.Image As icon,
tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.IPAddress,
tsysASServers.Servicelastpolled,
tsysOS.OSname As OS,
tblAssets.SP,
tsysASServers.Version as [SS Version],
Case
When NETVersion.Value = '378389' Then '.NET 4.5'
When NETVersion.Value = '378675' Then '.NET 4.5.1'
When NETVersion.Value = '378758' Then '.NET 4.5.1'
When NETVersion.Value = '379893' Then '.NET 4.5.2'
When NETVersion.Value = '393295' Then '.NET 4.6'
When NETVersion.Value = '393297' Then '.NET 4.6'
When NETVersion.Value = '394254' Then '.NET 4.6.1'
When NETVersion.Value = '394271' Then '.NET 4.6.1'
When NETVersion.Value = '394802' Then '.NET 4.6.2'
When NETVersion.Value = '394806' Then '.NET 4.6.2'
When NETVersion.Value = '460798' Then '.NET 4.7'
When NETVersion.Value = '460805' Then '.NET 4.7'
When NETVersion.Value = '461308' Then '.NET 4.7.1'
When NETVersion.Value = '461310' Then '.NET 4.7.1'
When NETVersion.Value = '461808' Then '.NET 4.7.2'
When NETVersion.Value = '461814' Then '.NET 4.7.2'
When NETVersion.Value = '528040' Then '.NET 4.8'
When NETVersion.Value = '528049' Then '.NET 4.8'
Else 'Older Version'
End As [.NET Version],
cnt.cnt_assets As 'Managed Assets',
tblAssets.Firstseen,
tblAssets.Lastseen,
tblAssets.Lasttried,
Case
When NETVersion.Value = '378389' Then '#ffadad'
When NETVersion.Value = '378675' Then '#ffadad'
When NETVersion.Value = '378758' Then '#ffadad'
When NETVersion.Value = '379893' Then '#ffadad'
When NETVersion.Value = '393295' Then '#d4f4be'
When NETVersion.Value = '393297' Then '#d4f4be'
When NETVersion.Value = '394254' Then '#d4f4be'
When NETVersion.Value = '394271' Then '#d4f4be'
When NETVersion.Value = '394802' Then '#d4f4be'
When NETVersion.Value = '394806' Then '#d4f4be'
When NETVersion.Value = '460798' Then '#d4f4be'
When NETVersion.Value = '460805' Then '#d4f4be'
When NETVersion.Value = '461308' Then '#d4f4be'
When NETVersion.Value = '461310' Then '#d4f4be'
When NETVersion.Value = '461808' Then '#d4f4be'
When NETVersion.Value = '461814' Then '#d4f4be'
When NETVersion.Value = '528040' Then '#d4f4be'
When NETVersion.Value = '528049' Then '#d4f4be'
Else '#ffadad'
End As backgroundcolor
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode
Inner Join tsysASServers On tsysASServers.Servername = tblAssets.AssetName
Left Join (Select tblRegistry.Value,
tblRegistry.AssetID
From tblRegistry
Where tblRegistry.Valuename = 'Release') NETVersion On
tblAssets.AssetID = NETVersion.AssetID
Join (Select tblAssets.Scanserver,
Count(tblAssets.Scanserver) As cnt_assets
From tblAssets
Group By tblAssets.Scanserver) cnt On tblAssets.AssetName = cnt.Scanserver
Where tblAssetCustom.State = 1
Order By tblAssets.AssetName
3 REPLIES 3
JacobH
Champion Sweeper III
you two should post an LSAgent readiness report along the same lines 🙂
Hendrik_VE
Champion Sweeper III
Thanks for adding the reg key, Esben.
I use HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\NET Framework Setup\NDP\v4\Full\1033 but it seems that both locations hold the same RegValue.
Esben_D
Lansweeper Employee
Lansweeper Employee
I trust you Hendrik 😉

I assume you scanned the following registry key scanned before running the report:

Regpath: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\NET Framework Setup\NDP\v4\Full
Regvalue: Release

Added it to the original post.