Lansweeper Windows EOL olan makineleri tespit etmek

Windows 7 ve 8 serisi artık kullanılamıyor bunu hepimiz biliyoruz microsoft bunlara destek sunmamamkta. Windows 10 Eol listesinede bu siteden erişebilirsiniz. 

https://docs.microsoft.com/tr-tr/lifecycle/products/windows-10-home-and-pro

Lansweeper envanter programını kullanan arkadaşlar için bir sql sorgusu hazırladım buradan eol olan windows sürümlerinizi ve işlemci yaş takibini yapabilirsiniz.

Select Top 1000000 tblAssets.AssetID,
  tblAssets.AssetUnique,
  tsysOS.OSname,
  tblOperatingsystem.Lastchanged,
  tsysOS.Image As icon,
  tblOperatingsystem.Version As Build,
  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.18363' Then '2004'
    When '10.0.18363' Then '2009'
    When '10.0.19041' Then '2004'
    When '10.0.19042' Then '20H2'
    When '10.0.19043' Then '2021'
    When '10.0.22000' Then '21H2'
    When '10.0.19044' Then '2022'
    Else '?'
  End As Version,
  tblAssets.IPAddress,
  tblAssets.Description,
  tblAssets.Lastseen,
  tblAssets.Memory,
  tblAssets.Processor,
  tblAssets.BuildNumber,
  tblAssets.Version As Version1,
  tblAssetCustom.Manufacturer,
  tblAssetCustom.Model,
  tblAssetCustom.Serialnumber
From tblAssets
  Inner Join tblOperatingsystem On
    tblAssets.AssetID = tblOperatingsystem.AssetID
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
Where (tsysOS.OSname Like 'Win 10' Or tsysOS.OSname Like 'Win 7' Or
    tsysOS.OSname Like 'Win 8' Or tsysOS.OSname Like 'Win 8.1') And
  tblAssetCustom.State = 1
Order By Build,
  tblAssets.AssetUnique