Lansweeper 7.1 Readiness Report

[Hendrik_VE]

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

[JacobH]

you two should post an LSAgent readiness report along the same lines 🙂

[Hendrik_VE]

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]

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.