Notification

Icon
Error

Lansweeper 7.1 Readiness Report

Posted: Friday, June 28, 2019 9:03:59 AM(UTC)
Hendrik.VE

Hendrik.VE

Member Original PosterPosts: 45
0
Like
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

Code:
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
Esben.D
#1Esben.D Member Administration Posts: 1,982  
posted: 7/1/2019 3:21:17 PM(UTC)
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.
Hendrik.VE
#2Hendrik.VE Member Original PosterPosts: 45  
posted: 7/2/2019 8:09:06 AM(UTC)
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.
JacobH
#3JacobH Member Posts: 176  
posted: 7/2/2019 1:01:45 PM(UTC)
you two should post an LSAgent readiness report along the same lines :)

Active Discussions

Lansweeper Is there a limit to the number of incoming mail domains?
by  DrewT   Go to last post Go to first unread
Last post: Today at 1:33:44 PM(UTC)
Lansweeper License renewal - but why
by  mrusso  
Go to last post Go to first unread
Last post: Yesterday at 5:01:47 PM(UTC)
Lansweeper Deployment Package Error Message
by  Brandon   Go to last post Go to first unread
Last post: Yesterday at 2:04:25 PM(UTC)
Lansweeper Asset Type Mail Server
by  MarkPayton  
Go to last post Go to first unread
Last post: Yesterday at 1:03:54 PM(UTC)
Lansweeper Upgrade Win 10 build to version 2004
by  Jean-FB   Go to last post Go to first unread
Last post: 10/28/2020 7:34:29 PM(UTC)
Lansweeper Uptime only shows Standby
by  Gst4r  
Go to last post Go to first unread
Last post: 10/28/2020 4:19:33 PM(UTC)
Lansweeper Excepciones
by  Pablo   Go to last post Go to first unread
Last post: 10/27/2020 7:35:21 PM(UTC)
Lansweeper Help desk API
by  Skylar@Hennig  
Go to last post Go to first unread
Last post: 10/27/2020 5:01:18 PM(UTC)