Notification

Icon
Error

End of Life Asset Report - Clarification of Feature Update Versions

Posted: Monday, May 10, 2021 7:26:26 PM(UTC)
DJ Bradley

DJ Bradley

Member Original PosterPosts: 3
0
Like
Hello - the Lansweeper article at https://www.lansweeper.c...r-windows-10-end-of-life states that Feature Update 1909 for Enterprise version goes EOL on May 11, 2021 (tomorrow).

However, if I read this article correctly - https://docs.microsoft.c...alth/release-information
It says that Feature Update 1909 Enterprise and Education versions goes EOL on May 10, 2022 which is one year from now.

Which one is correct? I would tend to think the article for Microsoft is correct.
Hendrik.VE
#1Hendrik.VE Member Posts: 82  
posted: 5/11/2021 1:38:01 PM(UTC)
Correct. 1909 Enterprise is supported until May 10th, 2022.
So the Lansweeper article is wrong.
DJ Bradley
#2DJ Bradley Member Original PosterPosts: 3  
posted: 5/11/2021 1:46:14 PM(UTC)
Thank you
Hendrik.VE
#3Hendrik.VE Member Posts: 82  
posted: 5/11/2021 2:18:23 PM(UTC)
Btw, this report should give you a quite accurate overview of the Windows Lifecycle (for most common versions).
Should you find any mistakes in this report, please let me know :-)

Code:
Select Top 1000000 tblAssets.AssetID,
  tblAssets.AssetName,
  tblAssets.Domain,
  Coalesce(tsysOS.Image, tsysAssetTypes.AssetTypeIcon10) As icon,
  tblAssets.IPAddress,
  tsysIPLocations.IPLocation,
  tblOperatingsystem.Caption As OS,
  tblOperatingsystem.Version,
  Case tblOperatingsystem.Version
    When '10.0.10240' Then '1507'
    When '10.0.10586' Then '1511'
    When '10.0.14393' Then '1607'
    When '10.0.15063' Then '1703'
    When '10.0.16299' Then '1709'
    When '10.0.17134' Then '1803'
    When '10.0.17763' Then '1809'
    When '10.0.18362' Then '1903'
    When '10.0.18363' Then '1909'
    When '10.0.19041' Then '2004'
    When '10.0.19042' Then '20H2'
    Else ''
  End As 'Win 10 Release',
  Case
    When tblOperatingsystem.Caption Like '%2000%' Then 'EOL'
    When tblOperatingsystem.Version = '10.0.10240' And
      tblOperatingsystem.Caption Not Like '%LTS%' Then 'EOL'
    When tblOperatingsystem.Version = '10.0.10586' Then 'EOL'
    When tblOperatingsystem.Version = '10.0.14393' And
      tblOperatingsystem.Caption Not Like '%LTS%' And
      tblOperatingsystem.Caption Not Like '%2016%' Then 'EOL'
    When tblOperatingsystem.Version = '10.0.15063' Then 'EOL'
    When GetDate() >= '2019-04-09' And tblOperatingsystem.Version = '10.0.16299'
      And (tblOperatingsystem.Caption Like '%Home%' Or
      tblOperatingsystem.Caption Like '%Pro%') Then 'EOL'
    When GetDate() >= '2020-10-13' And tblOperatingsystem.Version = '10.0.16299'
      And (tblOperatingsystem.Caption Like '%Enterprise%' Or
      tblOperatingsystem.Caption Like '%Education%') And
      tblOperatingsystem.Caption Not Like '%LTS%' Then 'EOL'
    When GetDate() >= '2019-11-12' And tblOperatingsystem.Version = '10.0.17134'
      And (tblOperatingsystem.Caption Like '%Home%' Or
      tblOperatingsystem.Caption Like '%Pro%') Then 'EOL'
    When GetDate() >= '2021-05-11' And tblOperatingsystem.Version = '10.0.17134'
      And (tblOperatingsystem.Caption Like '%Enterprise%' Or
      tblOperatingsystem.Caption Like '%Education%') And
      tblOperatingsystem.Caption Not Like '%LTS%' Then 'EOL'
    When GetDate() >= '2020-11-10' And tblOperatingsystem.Version = '10.0.17763'
      And (tblOperatingsystem.Caption Like '%Home%' Or
      tblOperatingsystem.Caption Like '%Pro%') Then 'EOL'
    When GetDate() >= '2021-05-11' And tblOperatingsystem.Version = '10.0.17763'
      And (tblOperatingsystem.Caption Like '%Enterprise%' Or
      tblOperatingsystem.Caption Like '%Education%') And
      tblOperatingsystem.Caption Not Like '%LTS%' Then 'EOL'
    When GetDate() >= '2020-12-08' And tblOperatingsystem.Version = '10.0.18362'
    Then 'EOL'
    When GetDate() >= '2021-05-11' And tblOperatingsystem.Version = '10.0.18363'
      And (tblOperatingsystem.Caption Like '%Home%' Or
      tblOperatingsystem.Caption Like '%Pro%') Then 'EOL'
    When GetDate() >= '2022-05-10' And tblOperatingsystem.Version = '10.0.18363'
      And (tblOperatingsystem.Caption Like '%Enterprise%' Or
      tblOperatingsystem.Caption Like '%Education%') And
      tblOperatingsystem.Caption Not Like '%LTS%' Then 'EOL'
    When GetDate() >= '2021-12-14' And tblOperatingsystem.Version = '10.0.19041'
      And (tblOperatingsystem.Caption Like '%Enterprise%' Or
      tblOperatingsystem.Caption Like '%Education%' Or
      tblOperatingsystem.Caption Like '%Home%' Or
      tblOperatingsystem.Caption Like '%Pro%') And
      tblOperatingsystem.Caption Not Like '%LTS%' Then 'EOL'
    When GetDate() >= '2022-05-10' And tblOperatingsystem.Version = '10.0.19042'
      And (tblOperatingsystem.Caption Like '%Home%' Or
      tblOperatingsystem.Caption Like '%Pro%') Then 'EOL'
    When GetDate() >= '2023-05-09' And tblOperatingsystem.Version = '10.0.19042'
      And (tblOperatingsystem.Caption Like '%Enterprise%' Or
      tblOperatingsystem.Caption Like '%Education%') And
      tblOperatingsystem.Caption Not Like '%LTS%' Then 'EOL'
    When GetDate() >= '2020-01-14' And (tblOperatingsystem.Caption Like '%2008%'
      Or tblOperatingsystem.Caption Like '%Windows 7%') Then 'EOL'
    When GetDate() >= '2029-01-09' And tblOperatingsystem.Caption Like
      '%Server 2019%' Then 'EOL'
    When GetDate() >= '2027-01-12' And tblOperatingsystem.Caption Like
      '%Server 2016%' Then 'EOL'
    When GetDate() >= '2023-10-10' And tblOperatingsystem.Caption Like
      '%Server 2012%' Then 'EOL'
    When GetDate() >= '2023-01-10' And tblOperatingsystem.Caption Like
      '%Windows 8%' Then 'EOL'
    When GetDate() >= '2025-10-14' And tblOperatingsystem.Version = '10.0.10240'
      And tblOperatingsystem.Caption Like '%LTS%' Then 'EOL'
    When GetDate() >= '2026-10-13' And tblOperatingsystem.Version = '10.0.14393'
      And tblOperatingsystem.Caption Like '%LTS%' Then 'EOL'
    When GetDate() >= '2029-01-09' And tblOperatingsystem.Version = '10.0.17763'
      And tblOperatingsystem.Caption Like '%LTS%' Then 'EOL'
    When GetDate() >= '2020-10-13' And tblOperatingsystem.Version = '6.1.7601'
      And tblOperatingsystem.Caption Like '%Embedded%' Then 'EOL'
    When tblOperatingsystem.Caption Is Null Then 'Rescan Asset'
    Else 'Supported'
  End As Status,
  Case
    When GetDate() > '2019-01-01' And GetDate() < '2025-10-14' And
      tblOperatingsystem.Version = '10.0.10240' And
      tblOperatingsystem.Caption Like '%LTS%' Then
      'EOL in ' + Cast(DateDiff(DAY, GetDate(), '2025-10-14') As nvarchar) +
      ' days'
    When GetDate() > '2019-01-01' And GetDate() < '2026-10-13' And
      tblOperatingsystem.Version = '10.0.14393' And
      tblOperatingsystem.Caption Like '%LTS%' Then
      'EOL in ' + Cast(DateDiff(DAY, GetDate(), '2026-10-13') As nvarchar) +
      ' days'
    When GetDate() > '2019-01-01' And GetDate() < '2029-01-09' And
      tblOperatingsystem.Version = '10.0.17763' And
      tblOperatingsystem.Caption Like '%LTS%' Then
      'EOL in ' + Cast(DateDiff(DAY, GetDate(), '2029-01-09') As nvarchar) +
      ' days'
    When GetDate() > '2019-01-01' And GetDate() < '2019-10-08' And
      tblOperatingsystem.Version = '10.0.15063' And
      (tblOperatingsystem.Caption Like '%Enterprise%' Or
      tblOperatingsystem.Caption Like '%Education%') And
      tblOperatingsystem.Caption Not Like '%LTS%' Then
      'EOL in ' + Cast(DateDiff(DAY, GetDate(), '2019-10-08') As nvarchar) +
      ' days'
    When GetDate() > '2019-01-01' And GetDate() < '2020-10-13' And
      tblOperatingsystem.Version = '10.0.16299' And
      (tblOperatingsystem.Caption Like '%Enterprise%' Or
      tblOperatingsystem.Caption Like '%Education%') And
      tblOperatingsystem.Caption Not Like '%LTS%' Then
      'EOL in ' + Cast(DateDiff(DAY, GetDate(), '2020-10-13') As nvarchar) +
      ' days'
    When GetDate() > '2019-01-01' And GetDate() < '2019-11-12' And
      tblOperatingsystem.Version = '10.0.17134' And
      (tblOperatingsystem.Caption Like '%Home%' Or
      tblOperatingsystem.Caption Like '%Pro%') Then
      'EOL in ' + Cast(DateDiff(DAY, GetDate(), '2019-11-12') As nvarchar) +
      ' days'
    When GetDate() > '2019-01-01' And GetDate() < '2021-05-11' And
      tblOperatingsystem.Version = '10.0.17134' And
      (tblOperatingsystem.Caption Like '%Enterprise%' Or
      tblOperatingsystem.Caption Like '%Education%') And
      tblOperatingsystem.Caption Not Like '%LTS%' Then
      'EOL in ' + Cast(DateDiff(DAY, GetDate(), '2021-05-11') As nvarchar) +
      ' days'
    When GetDate() > '2019-01-01' And GetDate() < '2020-11-10' And
      tblOperatingsystem.Version = '10.0.17763' And
      (tblOperatingsystem.Caption Like '%Home%' Or
      tblOperatingsystem.Caption Like '%Pro%') Then
      'EOL in ' + Cast(DateDiff(DAY, GetDate(), '2020-11-10') As nvarchar) +
      ' days'
    When GetDate() > '2019-01-01' And GetDate() < '2021-05-11' And
      tblOperatingsystem.Version = '10.0.17763' And
      (tblOperatingsystem.Caption Like '%Enterprise%' Or
      tblOperatingsystem.Caption Like '%Education%') And
      tblOperatingsystem.Caption Not Like '%LTS%' Then
      'EOL in ' + Cast(DateDiff(DAY, GetDate(), '2021-05-11') As nvarchar) +
      ' days'
    When GetDate() > '2019-01-01' And GetDate() < '2020-12-08' And
      tblOperatingsystem.Version = '10.0.18362' Then
      'EOL in ' + Cast(DateDiff(DAY, GetDate(), '2020-12-08') As nvarchar) +
      ' days'
    When GetDate() > '2019-01-01' And GetDate() < '2021-05-11' And
      tblOperatingsystem.Version = '10.0.18363' And
      (tblOperatingsystem.Caption Like '%Home%' Or
      tblOperatingsystem.Caption Like '%Pro%') Then
      'EOL in ' + Cast(DateDiff(DAY, GetDate(), '2021-05-11') As nvarchar) +
      ' days'
    When GetDate() > '2019-01-01' And GetDate() < '2022-05-10' And
      tblOperatingsystem.Version = '10.0.18363' And
      (tblOperatingsystem.Caption Like '%Enterprise%' Or
      tblOperatingsystem.Caption Like '%Education%') And
      tblOperatingsystem.Caption Not Like '%LTS%' Then
      'EOL in ' + Cast(DateDiff(DAY, GetDate(), '2022-05-10') As nvarchar) +
      ' days'
    When GetDate() > '2019-01-01' And GetDate() < '2021-12-14' And
      tblOperatingsystem.Version = '10.0.19041' And
      (tblOperatingsystem.Caption Like '%Enterprise%' Or
      tblOperatingsystem.Caption Like '%Education%' Or
      tblOperatingsystem.Caption Like '%Home%' Or
      tblOperatingsystem.Caption Like '%Pro%') And
      tblOperatingsystem.Caption Not Like '%LTS%' Then
      'EOL in ' + Cast(DateDiff(DAY, GetDate(), '2021-12-14') As nvarchar) +
      ' days'
    When GetDate() > '2019-01-01' And GetDate() < '2022-05-10' And
      tblOperatingsystem.Version = '10.0.19042' And
      (tblOperatingsystem.Caption Like '%Home%' Or
      tblOperatingsystem.Caption Like '%Pro%') Then
      'EOL in ' + Cast(DateDiff(DAY, GetDate(), '2022-05-10') As nvarchar) +
      ' days'
    When GetDate() > '2019-01-01' And GetDate() < '2023-05-09' And
      tblOperatingsystem.Version = '10.0.19042' And
      (tblOperatingsystem.Caption Like '%Enterprise%' Or
      tblOperatingsystem.Caption Like '%Education%') And
      tblOperatingsystem.Caption Not Like '%LTS%' Then
      'EOL in ' + Cast(DateDiff(DAY, GetDate(), '2023-05-09') As nvarchar) +
      ' days'
    When GetDate() > '2019-01-01' And GetDate() < '2020-01-14' And
      (tblOperatingsystem.Caption Like '%2008%' Or
      tblOperatingsystem.Caption Like '%Windows 7%') Then 'EOL in ' +
      Cast(DateDiff(DAY, GetDate(), '2020-01-14') As nvarchar) + ' days'
    When GetDate() > '2019-01-01' And GetDate() < '2027-01-12' And
      tblOperatingsystem.Caption Like '%Server 2016%' Then 'EOL in ' +
      Cast(DateDiff(DAY, GetDate(), '2027-01-12') As nvarchar) + ' days'
    When GetDate() > '2019-01-01' And GetDate() < '2029-01-09' And
      tblOperatingsystem.Caption Like '%Server 2019%' Then 'EOL in ' +
      Cast(DateDiff(DAY, GetDate(), '2029-01-09') As nvarchar) + ' days'
    When GetDate() > '2019-01-01' And GetDate() < '2023-10-10' And
      tblOperatingsystem.Caption Like '%Server 2012%' Then 'EOL in ' +
      Cast(DateDiff(DAY, GetDate(), '2023-10-10') As nvarchar) + ' days'
    When GetDate() > '2019-01-01' And GetDate() < '2023-01-10' And
      tblOperatingsystem.Caption Like '%Windows 8%' Then 'EOL in ' +
      Cast(DateDiff(DAY, GetDate(), '2023-01-10') As nvarchar) + ' days'
    When GetDate() > '2019-01-01' And GetDate() < '2020-10-13' And
      tblOperatingsystem.Caption Like '%Embedded%' And
      tblOperatingsystem.Version = '6.1.7601' Then
      'EOL in ' + Cast(DateDiff(DAY, GetDate(), '2020-10-13') As nvarchar) +
      ' days'
  End As 'Days until EOL',
  Case
    When tblOperatingsystem.Caption Like '%2000%' Then '2010-07-13'
    When tblOperatingsystem.Version = '10.0.10240' And
      (tblOperatingsystem.Caption Like '%Enterprise%' Or
      tblOperatingsystem.Caption Like '%Education%') And
      tblOperatingsystem.Caption Not Like '%LTS%' Then '2017-05-09'
    When tblOperatingsystem.Version = '10.0.10586' Then '2017-10-10'
    When tblOperatingsystem.Version = '10.0.14393' And
      (tblOperatingsystem.Caption Like '%Home%' Or
      tblOperatingsystem.Caption Like '%Pro%') Then '2018-04-10'
    When tblOperatingsystem.Version = '10.0.14393' And
      (tblOperatingsystem.Caption Like '%Enterprise%' Or
      tblOperatingsystem.Caption Like '%Education%') And
      tblOperatingsystem.Caption Not Like '%LTS%' Then '2019-04-09'
    When tblOperatingsystem.Version = '10.0.15063' And
      (tblOperatingsystem.Caption Like '%Home%' Or
      tblOperatingsystem.Caption Like '%Pro%') Then '2018-10-09'
    When tblOperatingsystem.Version = '10.0.15063' And
      (tblOperatingsystem.Caption Like '%Enterprise%' Or
      tblOperatingsystem.Caption Like '%Education%') Then '2019-10-08'
    When tblOperatingsystem.Version = '10.0.16299' And
      (tblOperatingsystem.Caption Like '%Home%' Or
      tblOperatingsystem.Caption Like '%Pro%') Then '2019-04-09'
    When tblOperatingsystem.Version = '10.0.16299' And
      (tblOperatingsystem.Caption Like '%Enterprise%' Or
      tblOperatingsystem.Caption Like '%Education%') Then '2020-10-13'
    When tblOperatingsystem.Version = '10.0.17134' And
      (tblOperatingsystem.Caption Like '%Home%' Or
      tblOperatingsystem.Caption Like '%Pro%') Then '2019-11-12'
    When tblOperatingsystem.Version = '10.0.17134' And
      (tblOperatingsystem.Caption Like '%Enterprise%' Or
      tblOperatingsystem.Caption Like '%Education%') Then '2021-05-11'
    When tblOperatingsystem.Version = '10.0.17763' And
      (tblOperatingsystem.Caption Like '%Home%' Or
      tblOperatingsystem.Caption Like '%Pro%') Then '2020-11-10'
    When tblOperatingsystem.Version = '10.0.17763' And
      (tblOperatingsystem.Caption Like '%Enterprise%' Or
      tblOperatingsystem.Caption Like '%Education%') And
      tblOperatingsystem.Caption Not Like '%LTS%' Then '2021-05-11'
    When tblOperatingsystem.Version = '10.0.18362' And
      (tblOperatingsystem.Caption Like '%Home%' Or
      tblOperatingsystem.Caption Like '%Pro%') Then '2020-12-08'
    When tblOperatingsystem.Version = '10.0.18362' And
      (tblOperatingsystem.Caption Like '%Enterprise%' Or
      tblOperatingsystem.Caption Like '%Education%') Then '2020-12-08'
    When tblOperatingsystem.Version = '10.0.18363' And
      (tblOperatingsystem.Caption Like '%Home%' Or
      tblOperatingsystem.Caption Like '%Pro%') Then '2021-05-11'
    When tblOperatingsystem.Version = '10.0.18363' And
      (tblOperatingsystem.Caption Like '%Enterprise%' Or
      tblOperatingsystem.Caption Like '%Education%') Then '2022-05-10'
    When tblOperatingsystem.Version = '10.0.19041' And
      (tblOperatingsystem.Caption Like '%Enterprise%' Or
      tblOperatingsystem.Caption Like '%Education%' Or
      tblOperatingsystem.Caption Like '%Home%' Or
      tblOperatingsystem.Caption Like '%Pro%') And
      tblOperatingsystem.Caption Not Like '%LTS%' Then '2021-12-14'
    When tblOperatingsystem.Version = '10.0.19042' And
      (tblOperatingsystem.Caption Like '%Home%' Or
      tblOperatingsystem.Caption Like '%Pro%') Then '2022-05-10'
    When tblOperatingsystem.Version = '10.0.19042' And
      (tblOperatingsystem.Caption Like '%Enterprise%' Or
      tblOperatingsystem.Caption Like '%Education%') And
      tblOperatingsystem.Caption Not Like '%LTS%' Then '2023-05-09'
    When tblOperatingsystem.Version = '10.0.10240' And
      (tblOperatingsystem.Caption Like '%LTS%') Then '2025-10-14'
    When tblOperatingsystem.Version = '10.0.14393' And
      (tblOperatingsystem.Caption Like '%LTS%') Then '2026-10-13'
    When tblOperatingsystem.Version = '10.0.17763' And
      (tblOperatingsystem.Caption Like '%LTS%') Then '2029-01-09'
    When tblOperatingsystem.Caption Like '%2008%' Or
      tblOperatingsystem.Caption Like '%Windows 7%' Then '2020-01-14'
    When tblOperatingsystem.Caption Like '%Server 2019%' Then '2029-01-09'
    When tblOperatingsystem.Caption Like '%Server 2016%' Then '2027-01-12'
    When tblOperatingsystem.Caption Like '%Server 2012%' Then '2023-10-10'
    When tblOperatingsystem.Caption Like '%Windows 8%' Then '2023-01-10'
    When tblOperatingsystem.Caption Like '%Embedded%' And
      tblOperatingsystem.Version = '6.1.7601' Then '2020-10-13'
  End As [EOL Date],
  tblAssets.Lastseen,
  tblAssets.Lasttried,
  Case
    When tblOperatingsystem.Caption Like '%2000%' Then '#ffadad'
    When tblOperatingsystem.Version Like '%10240%' And
      tblOperatingsystem.Caption Not Like '%LTS%' Then '#ffadad'
    When tblOperatingsystem.Version Like '%10240%' And
      tblOperatingsystem.Caption Like '%LTS%' Then '#d4f4be'
    When tblOperatingsystem.Version Like '%10586%' Then '#ffadad'
    When tblOperatingsystem.Version = '10.0.14393' And
      tblOperatingsystem.Caption Not Like '%LTS%' And
      tblOperatingsystem.Caption Not Like '%2016%' Then '#ffadad'
    When tblOperatingsystem.Version Like '%14393%' And
      tblOperatingsystem.Caption Like '%LTS%' Then '#d4f4be'
    When tblOperatingsystem.Version Like '%17763%' And
      tblOperatingsystem.Caption Like '%LTS%' Then '#d4f4be'
    When GetDate() >= '2018-10-09' And tblOperatingsystem.Version = '10.0.15063'
      And (tblOperatingsystem.Caption Like '%Home%' Or
      tblOperatingsystem.Caption Like '%Pro%') Then '#ffadad'
    When GetDate() >= '2019-10-08' And tblOperatingsystem.Version = '10.0.15063'
      And (tblOperatingsystem.Caption Like '%Enterprise%' Or
      tblOperatingsystem.Caption Like '%Education%') And
      tblOperatingsystem.Caption Not Like '%LTS%' Then '#ffadad'
    When GetDate() >= '2019-04-09' And tblOperatingsystem.Version = '10.0.16299'
      And (tblOperatingsystem.Caption Like '%Home%' Or
      tblOperatingsystem.Caption Like '%Pro%') Then '#ffadad'
    When GetDate() >= '2020-10-13' And tblOperatingsystem.Version = '10.0.16299'
      And (tblOperatingsystem.Caption Like '%Enterprise%' Or
      tblOperatingsystem.Caption Like '%Education%') And
      tblOperatingsystem.Caption Not Like '%LTS%' Then '#ffadad'
    When GetDate() >= '2019-11-12' And tblOperatingsystem.Version = '10.0.17134'
      And (tblOperatingsystem.Caption Like '%Home%' Or
      tblOperatingsystem.Caption Like '%Pro%') Then '#ffadad'
    When GetDate() >= '2021-05-11' And tblOperatingsystem.Version = '10.0.17134'
      And (tblOperatingsystem.Caption Like '%Enterprise%' Or
      tblOperatingsystem.Caption Like '%Education%') And
      tblOperatingsystem.Caption Not Like '%LTS%' Then '#ffadad'
    When GetDate() >= '2020-11-10' And tblOperatingsystem.Version = '10.0.17763'
      And (tblOperatingsystem.Caption Like '%Home%' Or
      tblOperatingsystem.Caption Like '%Pro%') Then '#ffadad'
    When GetDate() >= '2021-05-11' And tblOperatingsystem.Version = '10.0.17763'
      And (tblOperatingsystem.Caption Like '%Enterprise%' Or
      tblOperatingsystem.Caption Like '%Education%') And
      tblOperatingsystem.Caption Not Like '%LTS%' Then '#ffadad'
    When GetDate() >= '2021-11-10' And tblOperatingsystem.Version = '10.0.18362'
    Then '#ffadad'
    When GetDate() >= '2021-05-11' And tblOperatingsystem.Version = '10.0.18363'
      And (tblOperatingsystem.Caption Like '%Home%' Or
      tblOperatingsystem.Caption Like '%Pro%') Then '#ffadad'
    When GetDate() >= '2022-05-10' And tblOperatingsystem.Version = '10.0.18363'
      And (tblOperatingsystem.Caption Like '%Enterprise%' Or
      tblOperatingsystem.Caption Like '%Education%') And
      tblOperatingsystem.Caption Not Like '%LTS%' Then '#ffadad'
    When GetDate() >= '2021-12-14' And tblOperatingsystem.Version = '10.0.19041'
      And (tblOperatingsystem.Caption Like '%Enterprise%' Or
      tblOperatingsystem.Caption Like '%Education%' Or
      tblOperatingsystem.Caption Like '%Home%' Or
      tblOperatingsystem.Caption Like '%Pro%') And
      tblOperatingsystem.Caption Not Like '%LTS%' Then '#ffadad'
    When GetDate() >= '2022-05-10' And tblOperatingsystem.Version = '10.0.19042'
      And (tblOperatingsystem.Caption Like '%Home%' Or
      tblOperatingsystem.Caption Like '%Pro%') Then '#ffadad'
    When GetDate() >= '2023-05-09' And tblOperatingsystem.Version = '10.0.19042'
      And (tblOperatingsystem.Caption Like '%Enterprise%' Or
      tblOperatingsystem.Caption Like '%Education%') And
      tblOperatingsystem.Caption Not Like '%LTS%' Then '#ffadad'
    When GetDate() >= '2020-01-14' And (tblOperatingsystem.Caption Like '%2008%'
      Or tblOperatingsystem.Caption Like '%Windows 7%') Then '#ffadad'
    When GetDate() >= '2027-01-12' And tblOperatingsystem.Caption Like
      '%Server 2016%' Then '#ffadad'
    When GetDate() >= '2029-01-09' And tblOperatingsystem.Caption Like
      '%Server 2019%' Then '#ffadad'
    When GetDate() >= '2023-10-10' And tblOperatingsystem.Caption Like
      '%Server 2012%' Then '#ffadad'
    When GetDate() >= '2025-10-14' And tblOperatingsystem.Version = '10.0.10240'
      And tblOperatingsystem.Caption Like '%LTS%' Then '#ffadad'
    When GetDate() >= '2026-10-13' And tblOperatingsystem.Version = '10.0.14393'
      And tblOperatingsystem.Caption Like '%LTS%' Then '#ffadad'
    When GetDate() >= '2029-01-09' And tblOperatingsystem.Version = '10.0.17763'
      And tblOperatingsystem.Caption Like '%LTS%' Then '#ffadad'
    When GetDate() >= '2023-01-10' And tblOperatingsystem.Caption Like
      '%Windows 8%' Then '#ffadad'
    When GetDate() >= '2020-10-13' And tblOperatingsystem.Version = '6.1.7601'
      And tblOperatingsystem.Caption Like '%Embedded%' Then '#ffadad'
    When tblOperatingsystem.Caption Is Null Then '#ffadad'
    Else '#d4f4be'
  End As backgroundcolor,
  tblAssetCustom.Manufacturer,
  tblAssetCustom.Model
From tblAssets
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
  Inner Join tsysIPLocations On tsysIPLocations.LocationID =
    tblAssets.LocationID
  Inner Join tblState On tblState.State = tblAssetCustom.State
  Inner Join tblOperatingsystem On tblOperatingsystem.AssetID =
    tblAssets.AssetID
  Left Join tsysOS On tsysOS.OScode = tblAssets.OScode
Where tblAssets.Assettype Like '-1' And tblState.Statename = 'Active'
Order By tblAssets.Domain,
  tblAssets.AssetName
Esben.D
#4Esben.D Member Administration Posts: 2,010  
posted: 5/11/2021 4:06:27 PM(UTC)
The Home & Pro edition of 1909 are the ones going EOL. That's why it is listed in the article. I have updated it since it was indeed not clear from the text in regards to the specific editions.


Originally Posted by: Hendrik.VE Go to Quoted Post
Btw, this report should give you a quite accurate overview of the Windows Lifecycle (for most common versions).
Should you find any mistakes in this report, please let me know :-)


I actually added these type of reports to the library too.

Windows workstation: https://www.lansweeper.c...ws-10-end-of-life-audit/
Windows server: https://www.lansweeper.c...erver-end-of-life-audit/


DJ Bradley
#5DJ Bradley Member Original PosterPosts: 3  
posted: 5/11/2021 4:09:33 PM(UTC)
Thank you and I will definitely use this report.

Active Discussions

Lansweeper Enterprise Options in Menu Bar/Configuration
by  mk@allan   Go to last post Go to first unread
Last post: 6/18/2021 7:38:43 PM(UTC)
Lansweeper No One getting back to me from Lansweeper
by  Kenneth Lindsay  
Go to last post Go to first unread
Last post: 6/18/2021 3:31:06 PM(UTC)
Lansweeper INFO DateTimeService time refresh
by  miharix   Go to last post Go to first unread
Last post: 6/18/2021 10:48:57 AM(UTC)
Lansweeper RPC Unavailable error
by  Greeno  
Go to last post Go to first unread
Last post: 6/17/2021 7:15:07 PM(UTC)
Lansweeper Exclude Search
by  pryan67  
Go to last post Go to first unread
Last post: 6/16/2021 4:01:43 PM(UTC)
Lansweeper Report: All Apple Mac devices with Memory RAM asset
by  gabrielo   Go to last post Go to first unread
Last post: 6/16/2021 3:17:24 PM(UTC)
Lansweeper Does technical support for LS really respond?
by  tosch  
Go to last post Go to first unread
Last post: 6/16/2021 12:48:50 PM(UTC)