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 Duplicate Users On report
by  RC62N   Go to last post Go to first unread
Last post: Today at 3:51:07 PM(UTC)
Lansweeper Local Admin Group Members
by  ggbce  
Go to last post Go to first unread
Last post: Today at 2:28:50 PM(UTC)
Lansweeper Last used system of users in a specific OU
by  chriscornelis   Go to last post Go to first unread
Last post: Yesterday at 11:11:35 AM(UTC)
Lansweeper Trying to display different versions of software
by  TimHolmes1973  
Go to last post Go to first unread
Last post: 10/28/2020 8:54:04 PM(UTC)
Lansweeper Switch & Port reports - SNMPInfo tables missing info
by  Maxlieb   Go to last post Go to first unread
Last post: 10/28/2020 1:02:24 PM(UTC)
Lansweeper Last Patch Date
by  Dan S   Go to last post Go to first unread
Last post: 10/26/2020 2:27:47 PM(UTC)
Lansweeper Webcam report, the wrong way
by  TimHolmes1973  
Go to last post Go to first unread
Last post: 10/23/2020 4:38:45 PM(UTC)