Windows 11 compatibility report

[AlexKrietsch]

Lansweeper published this great report template that checks your Windows assets for Windows 11 compatibility. 
Windows 11 Requirements Audit - Lansweeper IT Asset Management

However, there is a flaw in this report in that it is marking an asset as failing the "Disk Space > 64 GB" if it detects that there is less than 64 GB of available free space. The actual Windows 11 requirement is that the disk be 64 GB or larger, and the amount of free space you need is highly dependent on several factors.

Whoever built this report decided to check for free space instead, so that means we have several workstations that are marked as failing the compatibility check when they would otherwise update to Windows 11 just fine. For example, a workstation with a 256 GB drive with 60 GB available free space. Obviously available disk space can be a worry in certain situations, but marking machines that have 30,40,50, or 60 GB of free space as incompatible doesn't seem to be the way to go. 

Is there a version of this report that looks at the disk size instead? Or can anyone provide an edited version that does so? 

[kv-jsmith]

I created a version that highlights assets in yellow if they fail just the available disk space check but would otherwise be compatible and ready to upgrade. The report is sorted, so incompatible assets are on top, followed by devices that fail disk space available, and then all of the assets that are green lit for the upgrade. The duplicate assets for devices with multiple disks are also addressed in my version.

Please see SQL for the revised report in the Spoiler block below:

Spoiler

Select Distinct Top 1000000 tblAssets.AssetID,
  tblAssets.AssetName,
  tblAssets.Domain,
  tblAssets.Username,
  Coalesce(tsysOS.Image, tsysAssetTypes.AssetTypeIcon10) As icon,
  tblAssets.IPAddress,
  tblAssetCustom.Manufacturer,
  tblAssetCustom.Model,
  tsysIPLocations.IPLocation,
  tblProcessor.Name As CPU,
  diskspace.Caption As [Drive Letter],
  diskspace.free As [Free Disk Space(GB)],
  Case
    When diskspace.free >= 64 Then 'Pass'
    Else 'Fail'
  End As [Disk Space Check],
  Case
    When CPU.AssetID = tblAssets.AssetID And (TPM.[TPM Version] Is Not Null And
      TPM.[TPM Version] = 'Pass') And BIOS.[BIOS Type] = 'Pass' And
      RAM.RAM = 'Pass' And tblAssets.AssetID = diskspace.AssetID And
      diskspace.free >= 64 Then 'Yes'
    Else 'No'
  End As [W11 Compatible],
  Case
    When CPU.AssetID = tblAssets.AssetID Then 'Pass'
    Else 'Fail'
  End As [CPU Compatible],
  Case
    When TPM.[TPM Version] Is Null Then 'Fail'
    Else TPM.[TPM Version]
  End As [TPM Version 2.0],
  BIOS.[BIOS Type] As [BIOS Type EUFI],
  Case
    When SecureBoot.Value = 0 Then 'No'
    When SecureBoot.Value = 1 Then 'Yes'
    Else 'RegKey not found'
  End As [Secure Boot Enabled],
  RAM.RAM As [RAM > 4GB],
  Case
    When tblAssets.AssetID = diskspace.AssetID And diskspace.TotalSize > 64 Then
      'Pass'
    Else 'Fail'
  End As [Disk Space > 64GB],
  Screen.Caption As [Video Card],
  Screen.[GPU Output],
  Screen.[Video Card State],
  Screen.Screen As [GPU Output > 720p, 8bit],
  tblOperatingsystem.Caption As OS,
  tblComputersystem.SystemType As [OS Architecture],
  tblAssets.Version,
  tblAssets.SP,
  Case
    When tblErrors.ErrorText Is Not Null Or
      tblErrors.ErrorText != '' Then
      'Scanning Error: ' + tsysasseterrortypes.ErrorMsg
    Else ''
  End As ScanningErrors,
  tblAssets.Lastseen,
  tblAssets.Lasttried,
  Case
    When CPU.AssetID = tblAssets.AssetID And TPM.[TPM Version] Is Not Null And
      BIOS.[BIOS Type] = 'Pass' And RAM.RAM = 'Pass' And tblAssets.AssetID =
      diskspace.AssetID And diskspace.free >= 64 Then '#d4f4be'
    When diskspace.free < 64 Then '#FFFF00'
    Else '#ffadad'
  End As backgroundcolor
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 tblProcessor On tblAssets.AssetID = tblProcessor.AssetID
  Inner Join tblOperatingsystem On
      tblAssets.AssetID = tblOperatingsystem.AssetID
  Left Join (Select Distinct Top 1000000 tblErrors.AssetID As ID,
      Max(tblErrors.Teller) As ErrorID
    From tblErrors
    Group By tblErrors.AssetID) As ScanningError On tblAssets.AssetID =
      ScanningError.ID
  Left Join tblErrors On ScanningError.ErrorID = tblErrors.Teller
  Left Join tsysasseterrortypes On tsysasseterrortypes.Errortype =
      tblErrors.ErrorType
  Left Join tsysOS On tsysOS.OScode = tblAssets.OScode
  Left Join (Select Top 1000000 tblAssets.AssetID,
      tblProcessor.Name
    From tblAssets
      Inner Join tblProcessor On tblAssets.AssetID = tblProcessor.AssetID
    Where ((tblProcessor.name Like '%AMD%3015e%' Or
          tblProcessor.name Like '%AMD%3020e%' Or
          tblProcessor.name Like '%Athlon%3000G%' Or
          tblProcessor.name Like '%Athlon%300GE%' Or
          tblProcessor.name Like '%Athlon%300U%' Or
          tblProcessor.name Like '%Athlon%320GE%' Or
          tblProcessor.name Like '%Athlon%7120e%' Or
          tblProcessor.name Like '%Athlon%7120U%' Or
          tblProcessor.name Like '%Athlon%7220e%' Or
          tblProcessor.name Like '%Athlon%7220U%' Or
          tblProcessor.name Like '%Athlon%Gold%3150C%' Or
          tblProcessor.name Like '%Athlon%Gold%3150G%' Or
          tblProcessor.name Like '%Athlon%Gold%3150GE%' Or
          tblProcessor.name Like '%Athlon%Gold%3150U%' Or
          tblProcessor.name Like '%Athlon%Silver%3050C%' Or
          tblProcessor.name Like '%Athlon%Silver%3050e%' Or
          tblProcessor.name Like '%Athlon%Silver%3050GE%' Or
          tblProcessor.name Like '%Athlon%Silver%3050U%' Or
          tblProcessor.name Like '%Athlon%Gold%3125GE%' Or
          tblProcessor.name Like '%Athlon%Gold%3150G%' Or
          tblProcessor.name Like '%Athlon%Gold%3150GE%' Or
          tblProcessor.name Like '%Athlon%Gold%4150GE%' Or
          tblProcessor.name Like '%Athlon%300GE%' Or
          tblProcessor.name Like '%Athlon%300U%' Or
          tblProcessor.name Like '%Athlon%3045B%' Or
          tblProcessor.name Like '%EPYC%7252%' Or
          tblProcessor.name Like '%EPYC%7262%' Or
          tblProcessor.name Like '%EPYC%7272%' Or
          tblProcessor.name Like '%EPYC%7282%' Or
          tblProcessor.name Like '%EPYC%7302%' Or
          tblProcessor.name Like '%EPYC%7313%' Or
          tblProcessor.name Like '%EPYC%7343%' Or
          tblProcessor.name Like '%EPYC%7352%' Or
          tblProcessor.name Like '%EPYC%7402%' Or
          tblProcessor.name Like '%EPYC%7413%' Or
          tblProcessor.name Like '%EPYC%7443%' Or
          tblProcessor.name Like '%EPYC%7452%' Or
          tblProcessor.name Like '%EPYC%7453%' Or
          tblProcessor.name Like '%EPYC%7502%' Or
          tblProcessor.name Like '%EPYC%7513%' Or
          tblProcessor.name Like '%EPYC%7532%' Or
          tblProcessor.name Like '%EPYC%7542%' Or
          tblProcessor.name Like '%EPYC%7543%' Or
          tblProcessor.name Like '%EPYC%7552%' Or
          tblProcessor.name Like '%EPYC%7642%' Or
          tblProcessor.name Like '%EPYC%7643%' Or
          tblProcessor.name Like '%EPYC%7662%' Or
          tblProcessor.name Like '%EPYC%7663%' Or
          tblProcessor.name Like '%EPYC%7702%' Or
          tblProcessor.name Like '%EPYC%7713%' Or
          tblProcessor.name Like '%EPYC%7742%' Or
          tblProcessor.name Like '%EPYC%7763%' Or
          tblProcessor.name Like '%EPYC%7232P%' Or
          tblProcessor.name Like '%EPYC%72F3%' Or
          tblProcessor.name Like '%EPYC%7302P%' Or
          tblProcessor.name Like '%EPYC%7313P%' Or
          tblProcessor.name Like '%EPYC%73F3%' Or
          tblProcessor.name Like '%EPYC%7402P%' Or
          tblProcessor.name Like '%EPYC%7443P%' Or
          tblProcessor.name Like '%EPYC%74F3%' Or
          tblProcessor.name Like '%EPYC%7502P%' Or
          tblProcessor.name Like '%EPYC%7543P%' Or
          tblProcessor.name Like '%EPYC%75F3%' Or
          tblProcessor.name Like '%EPYC%7702P%' Or
          tblProcessor.name Like '%EPYC%7713P%' Or
          tblProcessor.name Like '%EPYC%7F32%' Or
          tblProcessor.name Like '%EPYC%7F52%' Or
          tblProcessor.name Like '%EPYC%7F72%' Or
          tblProcessor.name Like '%EPYC%7H12%' Or
          tblProcessor.name Like '%Ryzen%%R2312%' Or
          tblProcessor.name Like '%Ryzen%%R2314%' Or
          tblProcessor.name Like '%Ryzen%%R2514%' Or
          tblProcessor.name Like '%Ryzen%%R2544%' Or
          tblProcessor.name Like '%Ryzen%Z1%' Or
          tblProcessor.name Like '%Ryzen%Z1%Extreme%' Or
          tblProcessor.name Like '%Ryzen%3%3100%' Or
          tblProcessor.name Like '%Ryzen%3%4100%' Or
          tblProcessor.name Like '%Ryzen%3%2300X%' Or
          tblProcessor.name Like '%Ryzen%3%3200G%' Or
          tblProcessor.name Like '%Ryzen%3%3200GE%' Or
          tblProcessor.name Like '%Ryzen%3%3200U%' Or
          tblProcessor.name Like '%Ryzen%3%3250C%' Or
          tblProcessor.name Like '%Ryzen%3%3250U%' Or
          tblProcessor.name Like '%Ryzen%3%3300U%' Or
          tblProcessor.name Like '%Ryzen%3%3350U%' Or
          tblProcessor.name Like '%Ryzen%3%4300G%' Or
          tblProcessor.name Like '%Ryzen%3%4300GE%' Or
          tblProcessor.name Like '%Ryzen%3%4300U%' Or
          tblProcessor.name Like '%Ryzen%3%5125C%' Or
          tblProcessor.name Like '%Ryzen%3%5300G%' Or
          tblProcessor.name Like '%Ryzen%3%5300GE%' Or
          tblProcessor.name Like '%Ryzen%3%5300GE%' Or
          tblProcessor.name Like '%Ryzen%3%5300U%' Or
          tblProcessor.name Like '%Ryzen%3%5400U%' Or
          tblProcessor.name Like '%Ryzen%3%5425C%' Or
          tblProcessor.name Like '%Ryzen%3%5425U%' Or
          tblProcessor.name Like '%Ryzen%3%7320e%' Or
          tblProcessor.name Like '%Ryzen%3%7320U%' Or
          tblProcessor.name Like '%Ryzen%3%7330U%' Or
          tblProcessor.name Like '%Ryzen%3%7335U%' Or
          tblProcessor.name Like '%Ryzen%3%7440U%' Or
          tblProcessor.name Like '%Ryzen%3%5380U%' Or
          tblProcessor.name Like '%Ryzen%3%3200G%' Or
          tblProcessor.name Like '%Ryzen%3%3200GE%' Or
          tblProcessor.name Like '%Ryzen%3%3300U%' Or
          tblProcessor.name Like '%Ryzen%3%4350G%' Or
          tblProcessor.name Like '%Ryzen%3%4350GE%' Or
          tblProcessor.name Like '%Ryzen%3%4450U%' Or
          tblProcessor.name Like '%Ryzen%3%5350G%' Or
          tblProcessor.name Like '%Ryzen%3%5350GE%' Or
          tblProcessor.name Like '%Ryzen%3%5450U%' Or
          tblProcessor.name Like '%Ryzen%3%5475U%' Or
          tblProcessor.name Like '%Ryzen%3%7330U%' Or
          tblProcessor.name Like '%Ryzen%3%4355G%' Or
          tblProcessor.name Like '%Ryzen%3%4355GE%' Or
          tblProcessor.name Like '%Ryzen%5%2600%' Or
          tblProcessor.name Like '%Ryzen%5%3600%' Or
          tblProcessor.name Like '%Ryzen%5%4500%' Or
          tblProcessor.name Like '%Ryzen%5%5500%' Or
          tblProcessor.name Like '%Ryzen%5%5600%' Or
          tblProcessor.name Like '%Ryzen%5%7600%' Or
          tblProcessor.name Like '%Ryzen%5%2500X%' Or
          tblProcessor.name Like '%Ryzen%5%2600E%' Or
          tblProcessor.name Like '%Ryzen%5%2600X%' Or
          tblProcessor.name Like '%Ryzen%5%3350G%' Or
          tblProcessor.name Like '%Ryzen%5%3350GE%' Or
          tblProcessor.name Like '%Ryzen%5%3400G%' Or
          tblProcessor.name Like '%Ryzen%5%3400GE%' Or
          tblProcessor.name Like '%Ryzen%5%3450U%' Or
          tblProcessor.name Like '%Ryzen%5%3500%' Or
          tblProcessor.name Like '%Ryzen%5%3500C%' Or
          tblProcessor.name Like '%Ryzen%5%3500U%' Or
          tblProcessor.name Like '%Ryzen%5%3500X%' Or
          tblProcessor.name Like '%Ryzen%5%3550H%' Or
          tblProcessor.name Like '%Ryzen%5%3580U%' Or
          tblProcessor.name Like '%Ryzen%5%3600X%' Or
          tblProcessor.name Like '%Ryzen%5%3600XT%' Or
          tblProcessor.name Like '%Ryzen%5%4500U%' Or
          tblProcessor.name Like '%Ryzen%5%4600G%' Or
          tblProcessor.name Like '%Ryzen%5%4600GE%' Or
          tblProcessor.name Like '%Ryzen%5%4600H%' Or
          tblProcessor.name Like '%Ryzen%5%4600HS%' Or
          tblProcessor.name Like '%Ryzen%5%4600U%' Or
          tblProcessor.name Like '%Ryzen%5%5300G%' Or
          tblProcessor.name Like '%Ryzen%5%5300GE%' Or
          tblProcessor.name Like '%Ryzen%5%5425U%' Or
          tblProcessor.name Like '%Ryzen%5%5500U%' Or
          tblProcessor.name Like '%Ryzen%5%5560U%' Or
          tblProcessor.name Like '%Ryzen%5%5600G%' Or
          tblProcessor.name Like '%Ryzen%5%5600GE%' Or
          tblProcessor.name Like '%Ryzen%5%5600H%' Or
          tblProcessor.name Like '%Ryzen%5%5600HS%' Or
          tblProcessor.name Like '%Ryzen%5%5600U%' Or
          tblProcessor.name Like '%Ryzen%5%5600X%' Or
          tblProcessor.name Like '%Ryzen%5%5625C%' Or
          tblProcessor.name Like '%Ryzen%5%5625U%' Or
          tblProcessor.name Like '%Ryzen%5%6600H%' Or
          tblProcessor.name Like '%Ryzen%5%6600HS%' Or
          tblProcessor.name Like '%Ryzen%5%6600U%' Or
          tblProcessor.name Like '%Ryzen%5%7520U%' Or
          tblProcessor.name Like '%Ryzen%5%7530U%' Or
          tblProcessor.name Like '%Ryzen%5%7535HS%' Or
          tblProcessor.name Like '%Ryzen%5%7535U%' Or
          tblProcessor.name Like '%Ryzen%5%7540U%' Or
          tblProcessor.name Like '%Ryzen%5%7600X%' Or
          tblProcessor.name Like '%Ryzen%5%7640HS%' Or
          tblProcessor.name Like '%Ryzen%5%7640S%' Or
          tblProcessor.name Like '%Ryzen%5%7640U%' Or
          tblProcessor.name Like '%Ryzen%5%7645HX%' Or
          tblProcessor.name Like '%Ryzen%5%7640H%' Or
          tblProcessor.name Like '%Ryzen%5%2600%' Or
          tblProcessor.name Like '%Ryzen%5%3600%' Or
          tblProcessor.name Like '%Ryzen%5%5645%' Or
          tblProcessor.name Like '%Ryzen%5%3350G%' Or
          tblProcessor.name Like '%Ryzen%5%3350GE%' Or
          tblProcessor.name Like '%Ryzen%5%3400G%' Or
          tblProcessor.name Like '%Ryzen%5%3400GE%' Or
          tblProcessor.name Like '%Ryzen%5%3500U%' Or
          tblProcessor.name Like '%Ryzen%5%4650G%' Or
          tblProcessor.name Like '%Ryzen%5%4650GE%' Or
          tblProcessor.name Like '%Ryzen%5%4650U%' Or
          tblProcessor.name Like '%Ryzen%5%5475U%' Or
          tblProcessor.name Like '%Ryzen%5%5650G%' Or
          tblProcessor.name Like '%Ryzen%5%5650GE%' Or
          tblProcessor.name Like '%Ryzen%5%5650HS%' Or
          tblProcessor.name Like '%Ryzen%5%5650HX%' Or
          tblProcessor.name Like '%Ryzen%5%5650U%' Or
          tblProcessor.name Like '%Ryzen%5%5675U%' Or
          tblProcessor.name Like '%Ryzen%5%5750G%' Or
          tblProcessor.name Like '%Ryzen%5%5750GE%' Or
          tblProcessor.name Like '%Ryzen%5%6650H%' Or
          tblProcessor.name Like '%Ryzen%5%6650HS%' Or
          tblProcessor.name Like '%Ryzen%5%6650U%' Or
          tblProcessor.name Like '%Ryzen%5%7530U%' Or
          tblProcessor.name Like '%Ryzen%5%7540U%' Or
          tblProcessor.name Like '%Ryzen%5%7640U%' Or
          tblProcessor.name Like '%Ryzen%5%4655G%' Or
          tblProcessor.name Like '%Ryzen%5%4655GE%' Or
          tblProcessor.name Like '%Ryzen%7%2700%' Or
          tblProcessor.name Like '%Ryzen%7%5800%' Or
          tblProcessor.name Like '%Ryzen%7%7700%' Or
          tblProcessor.name Like '%Ryzen%7%2700E%' Or
          tblProcessor.name Like '%Ryzen%7%2700X%' Or
          tblProcessor.name Like '%Ryzen%7%3700C%' Or
          tblProcessor.name Like '%Ryzen%7%3700U%' Or
          tblProcessor.name Like '%Ryzen%7%3700X%' Or
          tblProcessor.name Like '%Ryzen%7%3750H%' Or
          tblProcessor.name Like '%Ryzen%7%3780U%' Or
          tblProcessor.name Like '%Ryzen%7%3800X%' Or
          tblProcessor.name Like '%Ryzen%7%3800XT%' Or
          tblProcessor.name Like '%Ryzen%7%4700G%' Or
          tblProcessor.name Like '%Ryzen%7%4700GE%' Or
          tblProcessor.name Like '%Ryzen%7%4700U%' Or
          tblProcessor.name Like '%Ryzen%7%4800H%' Or
          tblProcessor.name Like '%Ryzen%7%4800HS%' Or
          tblProcessor.name Like '%Ryzen%7%4800U%' Or
          tblProcessor.name Like '%Ryzen%7%5700G%' Or
          tblProcessor.name Like '%Ryzen%7%5700GE%' Or
          tblProcessor.name Like '%Ryzen%7%5700U%' Or
          tblProcessor.name Like '%Ryzen%7%5700X%' Or
          tblProcessor.name Like '%Ryzen%7%5800H%' Or
          tblProcessor.name Like '%Ryzen%7%5800HS%' Or
          tblProcessor.name Like '%Ryzen%7%5800U%' Or
          tblProcessor.name Like '%Ryzen%7%5800X%' Or
          tblProcessor.name Like '%Ryzen%7%5800X3D%' Or
          tblProcessor.name Like '%Ryzen%7%5825C%' Or
          tblProcessor.name Like '%Ryzen%7%5825U%' Or
          tblProcessor.name Like '%Ryzen%7%6800H%' Or
          tblProcessor.name Like '%Ryzen%7%6800HS%' Or
          tblProcessor.name Like '%Ryzen%7%6800U%' Or
          tblProcessor.name Like '%Ryzen%7%6810U%' Or
          tblProcessor.name Like '%Ryzen%7%7700X%' Or
          tblProcessor.name Like '%Ryzen%7%7730U%' Or
          tblProcessor.name Like '%Ryzen%7%7735HS%' Or
          tblProcessor.name Like '%Ryzen%7%7735U%' Or
          tblProcessor.name Like '%Ryzen%7%7736U%' Or
          tblProcessor.name Like '%Ryzen%7%7745HX%' Or
          tblProcessor.name Like '%Ryzen%7%7800X3D%' Or
          tblProcessor.name Like '%Ryzen%7%7840H%' Or
          tblProcessor.name Like '%Ryzen%7%7840HS%' Or
          tblProcessor.name Like '%Ryzen%7%7840S%' Or
          tblProcessor.name Like '%Ryzen%7%7840U%' Or
          tblProcessor.name Like '%Ryzen%7%2700%' Or
          tblProcessor.name Like '%Ryzen%7%3700%' Or
          tblProcessor.name Like '%Ryzen%7%5845%' Or
          tblProcessor.name Like '%Ryzen%7%2700X%' Or
          tblProcessor.name Like '%Ryzen%7%3700U%' Or
          tblProcessor.name Like '%Ryzen%7%4750G%' Or
          tblProcessor.name Like '%Ryzen%7%4750GE%' Or
          tblProcessor.name Like '%Ryzen%7%4750U%' Or
          tblProcessor.name Like '%Ryzen%7%5850HS%' Or
          tblProcessor.name Like '%Ryzen%7%5850HX%' Or
          tblProcessor.name Like '%Ryzen%7%5850U%' Or
          tblProcessor.name Like '%Ryzen%7%5875U%' Or
          tblProcessor.name Like '%Ryzen%7%6850H%' Or
          tblProcessor.name Like '%Ryzen%7%6850HS%' Or
          tblProcessor.name Like '%Ryzen%7%6850U%' Or
          tblProcessor.name Like '%Ryzen%7%6860Z%' Or
          tblProcessor.name Like '%Ryzen%7%7730U%' Or
          tblProcessor.name Like '%Ryzen%7%7840U%' Or
          tblProcessor.name Like '%Ryzen%9%5900%' Or
          tblProcessor.name Like '%Ryzen%9%7900%' Or
          tblProcessor.name Like '%Ryzen%9%3900%' Or
          tblProcessor.name Like '%Ryzen%9%3900X%' Or
          tblProcessor.name Like '%Ryzen%9%3900XT%' Or
          tblProcessor.name Like '%Ryzen%9%3950X%' Or
          tblProcessor.name Like '%Ryzen%9%4900H%' Or
          tblProcessor.name Like '%Ryzen%9%4900HS%' Or
          tblProcessor.name Like '%Ryzen%9%5900HS%' Or
          tblProcessor.name Like '%Ryzen%9%5900HX%' Or
          tblProcessor.name Like '%Ryzen%9%5900X%' Or
          tblProcessor.name Like '%Ryzen%9%5950X%' Or
          tblProcessor.name Like '%Ryzen%9%5980HS%' Or
          tblProcessor.name Like '%Ryzen%9%5980HX%' Or
          tblProcessor.name Like '%Ryzen%9%6900HS%' Or
          tblProcessor.name Like '%Ryzen%9%6900HX%' Or
          tblProcessor.name Like '%Ryzen%9%6980HS%' Or
          tblProcessor.name Like '%Ryzen%9%6980HX%' Or
          tblProcessor.name Like '%Ryzen%9%7845HX%' Or
          tblProcessor.name Like '%Ryzen%9%7900X%' Or
          tblProcessor.name Like '%Ryzen%9%7900X3D%' Or
          tblProcessor.name Like '%Ryzen%9%7940H%' Or
          tblProcessor.name Like '%Ryzen%9%7940HS%' Or
          tblProcessor.name Like '%Ryzen%9%7945HX%' Or
          tblProcessor.name Like '%Ryzen%9%7950X%' Or
          tblProcessor.name Like '%Ryzen%9%7950X3D%' Or
          tblProcessor.name Like '%Ryzen%9%3900%' Or
          tblProcessor.name Like '%Ryzen%9%5945%' Or
          tblProcessor.name Like '%Ryzen%9%6950H%' Or
          tblProcessor.name Like '%Ryzen%9%6950HS%' Or
          tblProcessor.name Like '%Ryzen%V2516%' Or
          tblProcessor.name Like '%Ryzen%V2546%' Or
          tblProcessor.name Like '%Ryzen%V2718%' Or
          tblProcessor.name Like '%Ryzen%V2748%' Or
          tblProcessor.name Like '%Ryzen%3945WX%' Or
          tblProcessor.name Like '%Ryzen%3955WX%' Or
          tblProcessor.name Like '%Ryzen%3975WX%' Or
          tblProcessor.name Like '%Ryzen%3995WX%' Or
          tblProcessor.name Like '%Ryzen%5945WX%' Or
          tblProcessor.name Like '%Ryzen%5955WX%' Or
          tblProcessor.name Like '%Ryzen%5965WX%' Or
          tblProcessor.name Like '%Ryzen%5975WX%' Or
          tblProcessor.name Like '%Ryzen%5995WX%') And
        (tblProcessor.Manufacturer Like '%' Or tblProcessor.Manufacturer Like
          '%Advanced%')) Or
      ((tblProcessor.name Like '%Atom%x6200FE%' Or
          tblProcessor.name Like '%Atom%x6211E%' Or
          tblProcessor.name Like '%Atom%x6212RE%' Or
          tblProcessor.name Like '%Atom%x6413E%' Or
          tblProcessor.name Like '%Atom%x6414RE%' Or
          tblProcessor.name Like '%Atom%x6425E%' Or
          tblProcessor.name Like '%Atom%x6425RE%' Or
          tblProcessor.name Like '%Atom%x6427FE%' Or
          tblProcessor.name Like '%Celeron%6305%' Or
          tblProcessor.name Like '%Celeron%7300%' Or
          tblProcessor.name Like '%Celeron%7305%' Or
          tblProcessor.name Like '%Celeron%3867U%' Or
          tblProcessor.name Like '%Celeron%4205U%' Or
          tblProcessor.name Like '%Celeron%4305U%' Or
          tblProcessor.name Like '%Celeron%4305UE%' Or
          tblProcessor.name Like '%Celeron%5205U%' Or
          tblProcessor.name Like '%Celeron%5305U%' Or
          tblProcessor.name Like '%Celeron%6305E%' Or
          tblProcessor.name Like '%Celeron%6600HE%' Or
          tblProcessor.name Like '%Celeron%7305E%' Or
          tblProcessor.name Like '%Celeron%7305L%' Or
          tblProcessor.name Like '%Celeron%G4900%' Or
          tblProcessor.name Like '%Celeron%G4900T%' Or
          tblProcessor.name Like '%Celeron%G4920%' Or
          tblProcessor.name Like '%Celeron%G4930%' Or
          tblProcessor.name Like '%Celeron%G4930E%' Or
          tblProcessor.name Like '%Celeron%G4930T%' Or
          tblProcessor.name Like '%Celeron%G4932E%' Or
          tblProcessor.name Like '%Celeron%G4950%' Or
          tblProcessor.name Like '%Celeron%G5900%' Or
          tblProcessor.name Like '%Celeron%G5900E%' Or
          tblProcessor.name Like '%Celeron%G5900T%' Or
          tblProcessor.name Like '%Celeron%G5900TE%' Or
          tblProcessor.name Like '%Celeron%G5905%' Or
          tblProcessor.name Like '%Celeron%G5905T%' Or
          tblProcessor.name Like '%Celeron%G5920%' Or
          tblProcessor.name Like '%Celeron%G5925%' Or
          tblProcessor.name Like '%Celeron%G6900%' Or
          tblProcessor.name Like '%Celeron%G6900E%' Or
          tblProcessor.name Like '%Celeron%G6900T%' Or
          tblProcessor.name Like '%Celeron%G6900TE%' Or
          tblProcessor.name Like '%Celeron%J4005%' Or
          tblProcessor.name Like '%Celeron%J4025%' Or
          tblProcessor.name Like '%Celeron%J4105%' Or
          tblProcessor.name Like '%Celeron%J4115%' Or
          tblProcessor.name Like '%Celeron%J4125%' Or
          tblProcessor.name Like '%Celeron%J6412%' Or
          tblProcessor.name Like '%Celeron%J6413%' Or
          tblProcessor.name Like '%Celeron%N4000%' Or
          tblProcessor.name Like '%Celeron%N4020%' Or
          tblProcessor.name Like '%Celeron%N4100%' Or
          tblProcessor.name Like '%Celeron%N4120%' Or
          tblProcessor.name Like '%Celeron%N4500%' Or
          tblProcessor.name Like '%Celeron%N4505%' Or
          tblProcessor.name Like '%Celeron%N5100%' Or
          tblProcessor.name Like '%Celeron%N5105%' Or
          tblProcessor.name Like '%Celeron%N6210%' Or
          tblProcessor.name Like '%Celeron%N6211%' Or
          tblProcessor.name Like '%13th gen%' Or
          tblProcessor.name Like '%Core%i3%1000G1%' Or
          tblProcessor.name Like '%Core%i3%1000G4%' Or
          tblProcessor.name Like '%Core%i3%1005G1%' Or
          tblProcessor.name Like '%Core%i3%10100%' Or
          tblProcessor.name Like '%Core%i3%10100E%' Or
          tblProcessor.name Like '%Core%i3%10100F%' Or
          tblProcessor.name Like '%Core%i3%10100T%' Or
          tblProcessor.name Like '%Core%i3%10100TE%' Or
          tblProcessor.name Like '%Core%i3%10100Y%' Or
          tblProcessor.name Like '%Core%i3%10105%' Or
          tblProcessor.name Like '%Core%i3%10105F%' Or
          tblProcessor.name Like '%Core%i3%10105T%' Or
          tblProcessor.name Like '%Core%i3%10110U%' Or
          tblProcessor.name Like '%Core%i3%10110Y%' Or
          tblProcessor.name Like '%Core%i3%10300%' Or
          tblProcessor.name Like '%Core%i3%10300T%' Or
          tblProcessor.name Like '%Core%i3%10305%' Or
          tblProcessor.name Like '%Core%i3%10305T%' Or
          tblProcessor.name Like '%Core%i3%10320%' Or
          tblProcessor.name Like '%Core%i3%10325%' Or
          tblProcessor.name Like '%Core%i3%11100HE%' Or
          tblProcessor.name Like '%Core%i3%1110G4%' Or
          tblProcessor.name Like '%Core%i3%1115G4%' Or
          tblProcessor.name Like '%Core%i3%1115G4E%' Or
          tblProcessor.name Like '%Core%i3%1115GRE%' Or
          tblProcessor.name Like '%Core%i3%1120G4%' Or
          tblProcessor.name Like '%Core%i3%1125G4%' Or
          tblProcessor.name Like '%Core%i3%12100%' Or
          tblProcessor.name Like '%Core%i3%12100E%' Or
          tblProcessor.name Like '%Core%i3%12100F%' Or
          tblProcessor.name Like '%Core%i3%12100T%' Or
          tblProcessor.name Like '%Core%i3%12100TE%' Or
          tblProcessor.name Like '%Core%i3%1210U%' Or
          tblProcessor.name Like '%Core%i3%1215U%' Or
          tblProcessor.name Like '%Core%i3%1215UE%' Or
          tblProcessor.name Like '%Core%i3%1215UL%' Or
          tblProcessor.name Like '%Core%i3%1220P%' Or
          tblProcessor.name Like '%Core%i3%1220PE%' Or
          tblProcessor.name Like '%Core%i3%12300%' Or
          tblProcessor.name Like '%Core%i3%12300HE%' Or
          tblProcessor.name Like '%Core%i3%12300HL%' Or
          tblProcessor.name Like '%Core%i3%12300T%' Or
          tblProcessor.name Like '%Core%i3%1305U%' Or
          tblProcessor.name Like '%Core%i3%13100%' Or
          tblProcessor.name Like '%Core%i3%13100E%' Or
          tblProcessor.name Like '%Core%i3%13100F%' Or
          tblProcessor.name Like '%Core%i3%13100T%' Or
          tblProcessor.name Like '%Core%i3%13100TE%' Or
          tblProcessor.name Like '%Core%i3%1315U%' Or
          tblProcessor.name Like '%Core%i3%1315UE%' Or
          tblProcessor.name Like '%Core%i3%1320PE%' Or
          tblProcessor.name Like '%Core%i3%13300HE%' Or
          tblProcessor.name Like '%Core%i3%8100%' Or
          tblProcessor.name Like '%Core%i3%8100B%' Or
          tblProcessor.name Like '%Core%i3%8100H%' Or
          tblProcessor.name Like '%Core%i3%8100T%' Or
          tblProcessor.name Like '%Core%i3%8109U%' Or
          tblProcessor.name Like '%Core%i3%8130U%' Or
          tblProcessor.name Like '%Core%i3%8140U%' Or
          tblProcessor.name Like '%Core%i3%8145U%' Or
          tblProcessor.name Like '%Core%i3%8145UE%' Or
          tblProcessor.name Like '%Core%i3%8300%' Or
          tblProcessor.name Like '%Core%i3%8300T%' Or
          tblProcessor.name Like '%Core%i3%8350K%' Or
          tblProcessor.name Like '%Core%i3%9100%' Or
          tblProcessor.name Like '%Core%i3%9100E%' Or
          tblProcessor.name Like '%Core%i3%9100F%' Or
          tblProcessor.name Like '%Core%i3%9100HL%' Or
          tblProcessor.name Like '%Core%i3%9100T%' Or
          tblProcessor.name Like '%Core%i3%9100TE%' Or
          tblProcessor.name Like '%Core%i3%9300%' Or
          tblProcessor.name Like '%Core%i3%9300T%' Or
          tblProcessor.name Like '%Core%i3%9320%' Or
          tblProcessor.name Like '%Core%i3%9350K%' Or
          tblProcessor.name Like '%Core%i3%9350KF%' Or
          tblProcessor.name Like '%Core%i3%N300%' Or
          tblProcessor.name Like '%Core%i3%N305%' Or
          tblProcessor.name Like '%Core%i5%10200H%' Or
          tblProcessor.name Like '%Core%i5%10210U%' Or
          tblProcessor.name Like '%Core%i5%10210Y%' Or
          tblProcessor.name Like '%Core%i5%10300H%' Or
          tblProcessor.name Like '%Core%i5%1030G4%' Or
          tblProcessor.name Like '%Core%i5%1030G7%' Or
          tblProcessor.name Like '%Core%i5%10310U%' Or
          tblProcessor.name Like '%Core%i5%10310Y%' Or
          tblProcessor.name Like '%Core%i5%1035G1%' Or
          tblProcessor.name Like '%Core%i5%1035G4%' Or
          tblProcessor.name Like '%Core%i5%1035G7%' Or
          tblProcessor.name Like '%Core%i5%1038NG7%' Or
          tblProcessor.name Like '%Core%i5%10400%' Or
          tblProcessor.name Like '%Core%i5%10400F%' Or
          tblProcessor.name Like '%Core%i5%10400H%' Or
          tblProcessor.name Like '%Core%i5%10400T%' Or
          tblProcessor.name Like '%Core%i5%10500%' Or
          tblProcessor.name Like '%Core%i5%10500E%' Or
          tblProcessor.name Like '%Core%i5%10500H%' Or
          tblProcessor.name Like '%Core%i5%10500T%' Or
          tblProcessor.name Like '%Core%i5%10500TE%' Or
          tblProcessor.name Like '%Core%i5%10505%' Or
          tblProcessor.name Like '%Core%i5%10600%' Or
          tblProcessor.name Like '%Core%i5%10600K%' Or
          tblProcessor.name Like '%Core%i5%10600KF%' Or
          tblProcessor.name Like '%Core%i5%10600T%' Or
          tblProcessor.name Like '%Core%i5%11260H%' Or
          tblProcessor.name Like '%Core%i5%11300H%' Or
          tblProcessor.name Like '%Core%i5%1130G7%' Or
          tblProcessor.name Like '%Core%i5%11320H%' Or
          tblProcessor.name Like '%Core%i5%1135G7%' Or
          tblProcessor.name Like '%Core%i5%11400%' Or
          tblProcessor.name Like '%Core%i5%11400F%' Or
          tblProcessor.name Like '%Core%i5%11400H%' Or
          tblProcessor.name Like '%Core%i5%11400T%' Or
          tblProcessor.name Like '%Core%i5%1140G7%' Or
          tblProcessor.name Like '%Core%i5%1145G7%' Or
          tblProcessor.name Like '%Core%i5%1145G7E%' Or
          tblProcessor.name Like '%Core%i5%1145GRE%' Or
          tblProcessor.name Like '%Core%i5%11500%' Or
          tblProcessor.name Like '%Core%i5%11500H%' Or
          tblProcessor.name Like '%Core%i5%11500HE%' Or
          tblProcessor.name Like '%Core%i5%11500T%' Or
          tblProcessor.name Like '%Core%i5%1155G7%' Or
          tblProcessor.name Like '%Core%i5%11600%' Or
          tblProcessor.name Like '%Core%i5%11600K%' Or
          tblProcessor.name Like '%Core%i5%11600KF%' Or
          tblProcessor.name Like '%Core%i5%11600T%' Or
          tblProcessor.name Like '%Core%i5%1230U%' Or
          tblProcessor.name Like '%Core%i5%1235U%' Or
          tblProcessor.name Like '%Core%i5%1235UL%' Or
          tblProcessor.name Like '%Core%i5%12400%' Or
          tblProcessor.name Like '%Core%i5%12400F%' Or
          tblProcessor.name Like '%Core%i5%12400T%' Or
          tblProcessor.name Like '%Core%i5%1240P%' Or
          tblProcessor.name Like '%Core%i5%1240U%' Or
          tblProcessor.name Like '%Core%i5%12450H%' Or
          tblProcessor.name Like '%Core%i5%12450HX%' Or
          tblProcessor.name Like '%Core%i5%1245U%' Or
          tblProcessor.name Like '%Core%i5%1245UE%' Or
          tblProcessor.name Like '%Core%i5%1245UL%' Or
          tblProcessor.name Like '%Core%i5%12500%' Or
          tblProcessor.name Like '%Core%i5%12500E%' Or
          tblProcessor.name Like '%Core%i5%12500H%' Or
          tblProcessor.name Like '%Core%i5%12500HL%' Or
          tblProcessor.name Like '%Core%i5%12500T%' Or
          tblProcessor.name Like '%Core%i5%12500TE%' Or
          tblProcessor.name Like '%Core%i5%1250P%' Or
          tblProcessor.name Like '%Core%i5%1250PE%' Or
          tblProcessor.name Like '%Core%i5%12600%' Or
          tblProcessor.name Like '%Core%i5%12600H%' Or
          tblProcessor.name Like '%Core%i5%12600HE%' Or
          tblProcessor.name Like '%Core%i5%12600HL%' Or
          tblProcessor.name Like '%Core%i5%12600HX%' Or
          tblProcessor.name Like '%Core%i5%12600K%' Or
          tblProcessor.name Like '%Core%i5%12600KF%' Or
          tblProcessor.name Like '%Core%i5%12600T%' Or
          tblProcessor.name Like '%Core%i5%1334U%' Or
          tblProcessor.name Like '%Core%i5%1335U%' Or
          tblProcessor.name Like '%Core%i5%1335UE%' Or
          tblProcessor.name Like '%Core%i5%13400%' Or
          tblProcessor.name Like '%Core%i5%13400E%' Or
          tblProcessor.name Like '%Core%i5%13400F%' Or
          tblProcessor.name Like '%Core%i5%13400T%' Or
          tblProcessor.name Like '%Core%i5%1340P%' Or
          tblProcessor.name Like '%Core%i5%1340PE%' Or
          tblProcessor.name Like '%Core%i5%13420H%' Or
          tblProcessor.name Like '%Core%i5%13450HX%' Or
          tblProcessor.name Like '%Core%i5%1345U%' Or
          tblProcessor.name Like '%Core%i5%1345UE%' Or
          tblProcessor.name Like '%Core%i5%13490F%' Or
          tblProcessor.name Like '%Core%i5%13500%' Or
          tblProcessor.name Like '%Core%i5%13500E%' Or
          tblProcessor.name Like '%Core%i5%13500H%' Or
          tblProcessor.name Like '%Core%i5%13500HX%' Or
          tblProcessor.name Like '%Core%i5%13500T%' Or
          tblProcessor.name Like '%Core%i5%13500TE%' Or
          tblProcessor.name Like '%Core%i5%13505H%' Or
          tblProcessor.name Like '%Core%i5%1350P%' Or
          tblProcessor.name Like '%Core%i5%1350PE%' Or
          tblProcessor.name Like '%Core%i5%13600%' Or
          tblProcessor.name Like '%Core%i5%13600H%' Or
          tblProcessor.name Like '%Core%i5%13600HE%' Or
          tblProcessor.name Like '%Core%i5%13600HX%' Or
          tblProcessor.name Like '%Core%i5%13600K%' Or
          tblProcessor.name Like '%Core%i5%13600KF%' Or
          tblProcessor.name Like '%Core%i5%13600T%' Or
          tblProcessor.name Like '%Core%i5%8200Y%' Or
          tblProcessor.name Like '%Core%i5%8210Y%' Or
          tblProcessor.name Like '%Core%i5%8250U%' Or
          tblProcessor.name Like '%Core%i5%8257U%' Or
          tblProcessor.name Like '%Core%i5%8259U%' Or
          tblProcessor.name Like '%Core%i5%8260U%' Or
          tblProcessor.name Like '%Core%i5%8265U%' Or
          tblProcessor.name Like '%Core%i5%8269U%' Or
          tblProcessor.name Like '%Core%i5%8279U%' Or
          tblProcessor.name Like '%Core%i5%8300H%' Or
          tblProcessor.name Like '%Core%i5%8305G%' Or
          tblProcessor.name Like '%Core%i5%8310Y%' Or
          tblProcessor.name Like '%Core%i5%8350U%' Or
          tblProcessor.name Like '%Core%i5%8365U%' Or
          tblProcessor.name Like '%Core%i5%8365UE%' Or
          tblProcessor.name Like '%Core%i5%8400%' Or
          tblProcessor.name Like '%Core%i5%8400B%' Or
          tblProcessor.name Like '%Core%i5%8400H%' Or
          tblProcessor.name Like '%Core%i5%8400T%' Or
          tblProcessor.name Like '%Core%i5%8500%' Or
          tblProcessor.name Like '%Core%i5%8500B%' Or
          tblProcessor.name Like '%Core%i5%8500T%' Or
          tblProcessor.name Like '%Core%i5%8600%' Or
          tblProcessor.name Like '%Core%i5%8600K%' Or
          tblProcessor.name Like '%Core%i5%8600T%' Or
          tblProcessor.name Like '%Core%i5%9300H%' Or
          tblProcessor.name Like '%Core%i5%9300HF%' Or
          tblProcessor.name Like '%Core%i5%9400%' Or
          tblProcessor.name Like '%Core%i5%9400F%' Or
          tblProcessor.name Like '%Core%i5%9400H%' Or
          tblProcessor.name Like '%Core%i5%9400T%' Or
          tblProcessor.name Like '%Core%i5%9500%' Or
          tblProcessor.name Like '%Core%i5%9500E%' Or
          tblProcessor.name Like '%Core%i5%9500F%' Or
          tblProcessor.name Like '%Core%i5%9500T%' Or
          tblProcessor.name Like '%Core%i5%9500TE%' Or
          tblProcessor.name Like '%Core%i5%9600%' Or
          tblProcessor.name Like '%Core%i5%9600K%' Or
          tblProcessor.name Like '%Core%i5%9600KF%' Or
          tblProcessor.name Like '%Core%i5%9600T%' Or
          tblProcessor.name Like '%Core%i7%10510U%' Or
          tblProcessor.name Like '%Core%i7%10510Y%' Or
          tblProcessor.name Like '%Core%i7%1060G7%' Or
          tblProcessor.name Like '%Core%i7%10610U%' Or
          tblProcessor.name Like '%Core%i7%1065G7%' Or
          tblProcessor.name Like '%Core%i7%1068G7%' Or
          tblProcessor.name Like '%Core%i7%1068NG7%' Or
          tblProcessor.name Like '%Core%i7%10700%' Or
          tblProcessor.name Like '%Core%i7%10700E%' Or
          tblProcessor.name Like '%Core%i7%10700F%' Or
          tblProcessor.name Like '%Core%i7%10700K%' Or
          tblProcessor.name Like '%Core%i7%10700KF%' Or
          tblProcessor.name Like '%Core%i7%10700T%' Or
          tblProcessor.name Like '%Core%i7%10700TE%' Or
          tblProcessor.name Like '%Core%i7%10710U%' Or
          tblProcessor.name Like '%Core%i7%10750H%' Or
          tblProcessor.name Like '%Core%i7%10810U%' Or
          tblProcessor.name Like '%Core%i7%10850H%' Or
          tblProcessor.name Like '%Core%i7%10870H%' Or
          tblProcessor.name Like '%Core%i7%10875H%' Or
          tblProcessor.name Like '%Core%i7%11370H%' Or
          tblProcessor.name Like '%Core%i7%11375H%' Or
          tblProcessor.name Like '%Core%i7%11390H%' Or
          tblProcessor.name Like '%Core%i7%11600H%' Or
          tblProcessor.name Like '%Core%i7%1160G7%' Or
          tblProcessor.name Like '%Core%i7%1165G7%' Or
          tblProcessor.name Like '%Core%i7%11700%' Or
          tblProcessor.name Like '%Core%i7%11700F%' Or
          tblProcessor.name Like '%Core%i7%11700K%' Or
          tblProcessor.name Like '%Core%i7%11700KF%' Or
          tblProcessor.name Like '%Core%i7%11700T%' Or
          tblProcessor.name Like '%Core%i7%11800H%' Or
          tblProcessor.name Like '%Core%i7%1180G7%' Or
          tblProcessor.name Like '%Core%i7%11850H%' Or
          tblProcessor.name Like '%Core%i7%11850HE%' Or
          tblProcessor.name Like '%Core%i7%1185G7%' Or
          tblProcessor.name Like '%Core%i7%1185G7E%' Or
          tblProcessor.name Like '%Core%i7%1185GRE%' Or
          tblProcessor.name Like '%Core%i7%1195G7%' Or
          tblProcessor.name Like '%Core%i7%1250U%' Or
          tblProcessor.name Like '%Core%i7%1255U%' Or
          tblProcessor.name Like '%Core%i7%1255UL%' Or
          tblProcessor.name Like '%Core%i7%1260P%' Or
          tblProcessor.name Like '%Core%i7%1260U%' Or
          tblProcessor.name Like '%Core%i7%12650H%' Or
          tblProcessor.name Like '%Core%i7%12650HX%' Or
          tblProcessor.name Like '%Core%i7%1265U%' Or
          tblProcessor.name Like '%Core%i7%1265UE%' Or
          tblProcessor.name Like '%Core%i7%1265UL%' Or
          tblProcessor.name Like '%Core%i7%12700%' Or
          tblProcessor.name Like '%Core%i7%12700E%' Or
          tblProcessor.name Like '%Core%i7%12700F%' Or
          tblProcessor.name Like '%Core%i7%12700H%' Or
          tblProcessor.name Like '%Core%i7%12700HL%' Or
          tblProcessor.name Like '%Core%i7%12700K%' Or
          tblProcessor.name Like '%Core%i7%12700KF%' Or
          tblProcessor.name Like '%Core%i7%12700T%' Or
          tblProcessor.name Like '%Core%i7%12700TE%' Or
          tblProcessor.name Like '%Core%i7%1270P%' Or
          tblProcessor.name Like '%Core%i7%1270PE%' Or
          tblProcessor.name Like '%Core%i7%12800H%' Or
          tblProcessor.name Like '%Core%i7%12800HE%' Or
          tblProcessor.name Like '%Core%i7%12800HL%' Or
          tblProcessor.name Like '%Core%i7%12800HX%' Or
          tblProcessor.name Like '%Core%i7%1280P%' Or
          tblProcessor.name Like '%Core%i7%12850HX%' Or
          tblProcessor.name Like '%Core%i7%1355U%' Or
          tblProcessor.name Like '%Core%i7%1360P%' Or
          tblProcessor.name Like '%Core%i7%13620H%' Or
          tblProcessor.name Like '%Core%i7%13650HX%' Or
          tblProcessor.name Like '%Core%i7%1365U%' Or
          tblProcessor.name Like '%Core%i7%1365UE%' Or
          tblProcessor.name Like '%Core%i7%13700%' Or
          tblProcessor.name Like '%Core%i7%13700E%' Or
          tblProcessor.name Like '%Core%i7%13700F%' Or
          tblProcessor.name Like '%Core%i7%13700H%' Or
          tblProcessor.name Like '%Core%i7%13700HX%' Or
          tblProcessor.name Like '%Core%i7%13700K%' Or
          tblProcessor.name Like '%Core%i7%13700KF%' Or
          tblProcessor.name Like '%Core%i7%13700T%' Or
          tblProcessor.name Like '%Core%i7%13700TE%' Or
          tblProcessor.name Like '%Core%i7%13705H%' Or
          tblProcessor.name Like '%Core%i7%1370P%' Or
          tblProcessor.name Like '%Core%i7%1370PE%' Or
          tblProcessor.name Like '%Core%i7%13790F%' Or
          tblProcessor.name Like '%Core%i7%13800H%' Or
          tblProcessor.name Like '%Core%i7%13800HE%' Or
          tblProcessor.name Like '%Core%i7%13850HX%' Or
          tblProcessor.name Like '%Core%i7%7800X%' Or
          tblProcessor.name Like '%Core%i7%7820HQ%' Or
          tblProcessor.name Like '%Core%i7%7820X%' Or
          tblProcessor.name Like '%Core%i7%8086K%' Or
          tblProcessor.name Like '%Core%i7%8500Y%' Or
          tblProcessor.name Like '%Core%i7%8550U%' Or
          tblProcessor.name Like '%Core%i7%8557U%' Or
          tblProcessor.name Like '%Core%i7%8559U%' Or
          tblProcessor.name Like '%Core%i7%8565U%' Or
          tblProcessor.name Like '%Core%i7%8569U%' Or
          tblProcessor.name Like '%Core%i7%8650U%' Or
          tblProcessor.name Like '%Core%i7%8665U%' Or
          tblProcessor.name Like '%Core%i7%8665UE%' Or
          tblProcessor.name Like '%Core%i7%8700%' Or
          tblProcessor.name Like '%Core%i7%8700B%' Or
          tblProcessor.name Like '%Core%i7%8700K%' Or
          tblProcessor.name Like '%Core%i7%8700T%' Or
          tblProcessor.name Like '%Core%i7%8705G%' Or
          tblProcessor.name Like '%Core%i7%8706G%' Or
          tblProcessor.name Like '%Core%i7%8709G%' Or
          tblProcessor.name Like '%Core%i7%8750H%' Or
          tblProcessor.name Like '%Core%i7%8809G%' Or
          tblProcessor.name Like '%Core%i7%8850H%' Or
          tblProcessor.name Like '%Core%i7%9700%' Or
          tblProcessor.name Like '%Core%i7%9700E%' Or
          tblProcessor.name Like '%Core%i7%9700F%' Or
          tblProcessor.name Like '%Core%i7%9700K%' Or
          tblProcessor.name Like '%Core%i7%9700KF%' Or
          tblProcessor.name Like '%Core%i7%9700T%' Or
          tblProcessor.name Like '%Core%i7%9700TE%' Or
          tblProcessor.name Like '%Core%i7%9750H%' Or
          tblProcessor.name Like '%Core%i7%9750HF%' Or
          tblProcessor.name Like '%Core%i7%9800X%' Or
          tblProcessor.name Like '%Core%i7%9850H%' Or
          tblProcessor.name Like '%Core%i7%9850HE%' Or
          tblProcessor.name Like '%Core%i7%9850HL%' Or
          tblProcessor.name Like '%Core%i9%10850K%' Or
          tblProcessor.name Like '%Core%i9%10885H%' Or
          tblProcessor.name Like '%Core%i9%10900%' Or
          tblProcessor.name Like '%Core%i9%10900E%' Or
          tblProcessor.name Like '%Core%i9%10900F%' Or
          tblProcessor.name Like '%Core%i9%10900K%' Or
          tblProcessor.name Like '%Core%i9%10900KF%' Or
          tblProcessor.name Like '%Core%i9%10900T%' Or
          tblProcessor.name Like '%Core%i9%10900TE%' Or
          tblProcessor.name Like '%Core%i9%10900X%' Or
          tblProcessor.name Like '%Core%i9%10920X%' Or
          tblProcessor.name Like '%Core%i9%10940X%' Or
          tblProcessor.name Like '%Core%i9%10980HK%' Or
          tblProcessor.name Like '%Core%i9%10980XE%' Or
          tblProcessor.name Like '%Core%i9%11900%' Or
          tblProcessor.name Like '%Core%i9%11900F%' Or
          tblProcessor.name Like '%Core%i9%11900H%' Or
          tblProcessor.name Like '%Core%i9%11900K%' Or
          tblProcessor.name Like '%Core%i9%11900KF%' Or
          tblProcessor.name Like '%Core%i9%11900T%' Or
          tblProcessor.name Like '%Core%i9%11950H%' Or
          tblProcessor.name Like '%Core%i9%11980HK%' Or
          tblProcessor.name Like '%Core%i9%12900%' Or
          tblProcessor.name Like '%Core%i9%12900E%' Or
          tblProcessor.name Like '%Core%i9%12900F%' Or
          tblProcessor.name Like '%Core%i9%12900H%' Or
          tblProcessor.name Like '%Core%i9%12900HK%' Or
          tblProcessor.name Like '%Core%i9%12900HX%' Or
          tblProcessor.name Like '%Core%i9%12900K%' Or
          tblProcessor.name Like '%Core%i9%12900KF%' Or
          tblProcessor.name Like '%Core%i9%12900KS%' Or
          tblProcessor.name Like '%Core%i9%12900T%' Or
          tblProcessor.name Like '%Core%i9%12900TE%' Or
          tblProcessor.name Like '%Core%i9%12950HX%' Or
          tblProcessor.name Like '%Core%i9%13900%' Or
          tblProcessor.name Like '%Core%i9%13900E%' Or
          tblProcessor.name Like '%Core%i9%13900F%' Or
          tblProcessor.name Like '%Core%i9%13900H%' Or
          tblProcessor.name Like '%Core%i9%13900HK%' Or
          tblProcessor.name Like '%Core%i9%13900HX%' Or
          tblProcessor.name Like '%Core%i9%13900K%' Or
          tblProcessor.name Like '%Core%i9%13900KF%' Or
          tblProcessor.name Like '%Core%i9%13900KS%' Or
          tblProcessor.name Like '%Core%i9%13900T%' Or
          tblProcessor.name Like '%Core%i9%13900TE%' Or
          tblProcessor.name Like '%Core%i9%13905H%' Or
          tblProcessor.name Like '%Core%i9%13950HX%' Or
          tblProcessor.name Like '%Core%i9%13980HX%' Or
          tblProcessor.name Like '%Core%i9%7900X%' Or
          tblProcessor.name Like '%Core%i9%7920X%' Or
          tblProcessor.name Like '%Core%i9%7940X%' Or
          tblProcessor.name Like '%Core%i9%7960X%' Or
          tblProcessor.name Like '%Core%i9%7980XE%' Or
          tblProcessor.name Like '%Core%i9%8950HK%' Or
          tblProcessor.name Like '%Core%i9%9820X%' Or
          tblProcessor.name Like '%Core%i9%9880H%' Or
          tblProcessor.name Like '%Core%i9%9900%' Or
          tblProcessor.name Like '%Core%i9%9900K%' Or
          tblProcessor.name Like '%Core%i9%9900KF%' Or
          tblProcessor.name Like '%Core%i9%9900KS%' Or
          tblProcessor.name Like '%Core%i9%9900T%' Or
          tblProcessor.name Like '%Core%i9%9900X%' Or
          tblProcessor.name Like '%Core%i9%9920X%' Or
          tblProcessor.name Like '%Core%i9%9940X%' Or
          tblProcessor.name Like '%Core%i9%9960X%' Or
          tblProcessor.name Like '%Core%i9%9980HK%' Or
          tblProcessor.name Like '%Core%i9%9980XE%' Or
          tblProcessor.name Like '%Core%m3%8100Y%' Or
          tblProcessor.name Like '%Pentium%Gold%4417U%' Or
          tblProcessor.name Like '%Pentium%Gold%4425Y%' Or
          tblProcessor.name Like '%Pentium%Gold%5405U%' Or
          tblProcessor.name Like '%Pentium%Gold%6405U%' Or
          tblProcessor.name Like '%Pentium%Gold%6500Y%' Or
          tblProcessor.name Like '%Pentium%Gold%6805%' Or
          tblProcessor.name Like '%Pentium%Gold%7505%' Or
          tblProcessor.name Like '%Pentium%Gold%8500%' Or
          tblProcessor.name Like '%Pentium%Gold%8505%' Or
          tblProcessor.name Like '%Pentium%Gold%G5400%' Or
          tblProcessor.name Like '%Pentium%Gold%G5400T%' Or
          tblProcessor.name Like '%Pentium%Gold%G5420%' Or
          tblProcessor.name Like '%Pentium%Gold%G5420T%' Or
          tblProcessor.name Like '%Pentium%Gold%G5500%' Or
          tblProcessor.name Like '%Pentium%Gold%G5500T%' Or
          tblProcessor.name Like '%Pentium%Gold%G5600%' Or
          tblProcessor.name Like '%Pentium%Gold%G5600E%' Or
          tblProcessor.name Like '%Pentium%Gold%G5600T%' Or
          tblProcessor.name Like '%Pentium%Gold%G5620%' Or
          tblProcessor.name Like '%Pentium%Gold%G6400%' Or
          tblProcessor.name Like '%Pentium%Gold%G6400E%' Or
          tblProcessor.name Like '%Pentium%Gold%G6400T%' Or
          tblProcessor.name Like '%Pentium%Gold%G6400TE%' Or
          tblProcessor.name Like '%Pentium%Gold%G6405%' Or
          tblProcessor.name Like '%Pentium%Gold%G6405T%' Or
          tblProcessor.name Like '%Pentium%Gold%G6500%' Or
          tblProcessor.name Like '%Pentium%Gold%G6500T%' Or
          tblProcessor.name Like '%Pentium%Gold%G6505%' Or
          tblProcessor.name Like '%Pentium%Gold%G6505T%' Or
          tblProcessor.name Like '%Pentium%Gold%G6600%' Or
          tblProcessor.name Like '%Pentium%Gold%G6605%' Or
          tblProcessor.name Like '%Pentium%Gold%G7400%' Or
          tblProcessor.name Like '%Pentium%Gold%G7400E%' Or
          tblProcessor.name Like '%Pentium%Gold%G7400T%' Or
          tblProcessor.name Like '%Pentium%Gold%G7400TE%' Or
          tblProcessor.name Like '%Pentium%J6426%' Or
          tblProcessor.name Like '%Pentium%N6415%' Or
          tblProcessor.name Like '%Pentium%Silver%J5005%' Or
          tblProcessor.name Like '%Pentium%Silver%J5040%' Or
          tblProcessor.name Like '%Pentium%Silver%N5000%' Or
          tblProcessor.name Like '%Pentium%Silver%N5030%' Or
          tblProcessor.name Like '%Pentium%Silver%N6000%' Or
          tblProcessor.name Like '%Pentium%Silver%N6005%' Or
          tblProcessor.name Like '%N100%' Or tblProcessor.name Like '%N200%' Or
          tblProcessor.name Like '%N50%' Or tblProcessor.name Like '%N95%' Or
          tblProcessor.name Like '%N97%' Or tblProcessor.name Like '%U300%' Or
          tblProcessor.name Like '%U300E%' Or
          tblProcessor.name Like '%Xeon%Bronze%3104%' Or
          tblProcessor.name Like '%Xeon%Bronze%3106%' Or
          tblProcessor.name Like '%Xeon%Bronze%3204%' Or
          tblProcessor.name Like '%Xeon%Bronze%3206R%' Or
          tblProcessor.name Like '%Xeon%D-1702%' Or
          tblProcessor.name Like '%Xeon%D-1712TR%' Or
          tblProcessor.name Like '%Xeon%D-1713NT%' Or
          tblProcessor.name Like '%Xeon%D-1713NTE%' Or
          tblProcessor.name Like '%Xeon%D-1714%' Or
          tblProcessor.name Like '%Xeon%D-1715TER%' Or
          tblProcessor.name Like '%Xeon%D-1718T%' Or
          tblProcessor.name Like '%Xeon%D-1722NE%' Or
          tblProcessor.name Like '%Xeon%D-1726%' Or
          tblProcessor.name Like '%Xeon%D-1732TE%' Or
          tblProcessor.name Like '%Xeon%D-1733NT%' Or
          tblProcessor.name Like '%Xeon%D-1735TR%' Or
          tblProcessor.name Like '%Xeon%D-1736%' Or
          tblProcessor.name Like '%Xeon%D-1736NT%' Or
          tblProcessor.name Like '%Xeon%D-1739%' Or
          tblProcessor.name Like '%Xeon%D-1746TER%' Or
          tblProcessor.name Like '%Xeon%D-1747NTE%' Or
          tblProcessor.name Like '%Xeon%D-1748TE%' Or
          tblProcessor.name Like '%Xeon%D-1749NT%' Or
          tblProcessor.name Like '%Xeon%D-2712T%' Or
          tblProcessor.name Like '%Xeon%D-2733NT%' Or
          tblProcessor.name Like '%Xeon%D-2738%' Or
          tblProcessor.name Like '%Xeon%D-2752NTE%' Or
          tblProcessor.name Like '%Xeon%D-2752TER%' Or
          tblProcessor.name Like '%Xeon%D-2753NT%' Or
          tblProcessor.name Like '%Xeon%D-2766NT%' Or
          tblProcessor.name Like '%Xeon%D-2775TE%' Or
          tblProcessor.name Like '%Xeon%D-2776NT%' Or
          tblProcessor.name Like '%Xeon%D-2779%' Or
          tblProcessor.name Like '%Xeon%D-2786NTE%' Or
          tblProcessor.name Like '%Xeon%D-2795NT%' Or
          tblProcessor.name Like '%Xeon%D-2796NT%' Or
          tblProcessor.name Like '%Xeon%D-2796TE%' Or
          tblProcessor.name Like '%Xeon%D-2798NT%' Or
          tblProcessor.name Like '%Xeon%D-2799%' Or
          tblProcessor.name Like '%Xeon%E-2104G%' Or
          tblProcessor.name Like '%Xeon%E-2124%' Or
          tblProcessor.name Like '%Xeon%E-2124G%' Or
          tblProcessor.name Like '%Xeon%E-2126G%' Or
          tblProcessor.name Like '%Xeon%E-2134%' Or
          tblProcessor.name Like '%Xeon%E-2136%' Or
          tblProcessor.name Like '%Xeon%E-2144G%' Or
          tblProcessor.name Like '%Xeon%E-2146G%' Or
          tblProcessor.name Like '%Xeon%E-2174G%' Or
          tblProcessor.name Like '%Xeon%E-2176G%' Or
          tblProcessor.name Like '%Xeon%E-2176M%' Or
          tblProcessor.name Like '%Xeon%E-2186G%' Or
          tblProcessor.name Like '%Xeon%E-2186M%' Or
          tblProcessor.name Like '%Xeon%E-2224%' Or
          tblProcessor.name Like '%Xeon%E-2224G%' Or
          tblProcessor.name Like '%Xeon%E-2226G%' Or
          tblProcessor.name Like '%Xeon%E-2226GE%' Or
          tblProcessor.name Like '%Xeon%E-2234%' Or
          tblProcessor.name Like '%Xeon%E-2236%' Or
          tblProcessor.name Like '%Xeon%E-2244G%' Or
          tblProcessor.name Like '%Xeon%E-2246G%' Or
          tblProcessor.name Like '%Xeon%E-2254ME%' Or
          tblProcessor.name Like '%Xeon%E-2254ML%' Or
          tblProcessor.name Like '%Xeon%E-2274G%' Or
          tblProcessor.name Like '%Xeon%E-2276G%' Or
          tblProcessor.name Like '%Xeon%E-2276M%' Or
          tblProcessor.name Like '%Xeon%E-2276ME%' Or
          tblProcessor.name Like '%Xeon%E-2276ML%' Or
          tblProcessor.name Like '%Xeon%E-2278G%' Or
          tblProcessor.name Like '%Xeon%E-2278GE%' Or
          tblProcessor.name Like '%Xeon%E-2278GEL%' Or
          tblProcessor.name Like '%Xeon%E-2286G%' Or
          tblProcessor.name Like '%Xeon%E-2286M%' Or
          tblProcessor.name Like '%Xeon%E-2288G%' Or
          tblProcessor.name Like '%Xeon%Gold%5115%' Or
          tblProcessor.name Like '%Xeon%Gold%5118%' Or
          tblProcessor.name Like '%Xeon%Gold%5119T%' Or
          tblProcessor.name Like '%Xeon%Gold%5120%' Or
          tblProcessor.name Like '%Xeon%Gold%5120T%' Or
          tblProcessor.name Like '%Xeon%Gold%5122%' Or
          tblProcessor.name Like '%Xeon%Gold%5215%' Or
          tblProcessor.name Like '%Xeon%Gold%5215L%' Or
          tblProcessor.name Like '%Xeon%Gold%5215M%' Or
          tblProcessor.name Like '%Xeon%Gold%5217%' Or
          tblProcessor.name Like '%Xeon%Gold%5218%' Or
          tblProcessor.name Like '%Xeon%Gold%5218B%' Or
          tblProcessor.name Like '%Xeon%Gold%5218N%' Or
          tblProcessor.name Like '%Xeon%Gold%5218R%' Or
          tblProcessor.name Like '%Xeon%Gold%5218T%' Or
          tblProcessor.name Like '%Xeon%Gold%5220%' Or
          tblProcessor.name Like '%Xeon%Gold%5220R%' Or
          tblProcessor.name Like '%Xeon%Gold%5220S%' Or
          tblProcessor.name Like '%Xeon%Gold%5220T%' Or
          tblProcessor.name Like '%Xeon%Gold%5222%' Or
          tblProcessor.name Like '%Xeon%Gold%5315Y%' Or
          tblProcessor.name Like '%Xeon%Gold%5317%' Or
          tblProcessor.name Like '%Xeon%Gold%5318N%' Or
          tblProcessor.name Like '%Xeon%Gold%5318S%' Or
          tblProcessor.name Like '%Xeon%Gold%5318Y%' Or
          tblProcessor.name Like '%Xeon%Gold%5320%' Or
          tblProcessor.name Like '%Xeon%Gold%5320T%' Or
          tblProcessor.name Like '%Xeon%Gold%5415+%' Or
          tblProcessor.name Like '%Xeon%Gold%5416S%' Or
          tblProcessor.name Like '%Xeon%Gold%5418Y%' Or
          tblProcessor.name Like '%Xeon%Gold%5420+%' Or
          tblProcessor.name Like '%Xeon%Gold%6126%' Or
          tblProcessor.name Like '%Xeon%Gold%6126F%' Or
          tblProcessor.name Like '%Xeon%Gold%6126T%' Or
          tblProcessor.name Like '%Xeon%Gold%6128%' Or
          tblProcessor.name Like '%Xeon%Gold%6130%' Or
          tblProcessor.name Like '%Xeon%Gold%6130F%' Or
          tblProcessor.name Like '%Xeon%Gold%6130T%' Or
          tblProcessor.name Like '%Xeon%Gold%6132%' Or
          tblProcessor.name Like '%Xeon%Gold%6134%' Or
          tblProcessor.name Like '%Xeon%Gold%6136%' Or
          tblProcessor.name Like '%Xeon%Gold%6138%' Or
          tblProcessor.name Like '%Xeon%Gold%6138F%' Or
          tblProcessor.name Like '%Xeon%Gold%6138P%' Or
          tblProcessor.name Like '%Xeon%Gold%6138T%' Or
          tblProcessor.name Like '%Xeon%Gold%6140%' Or
          tblProcessor.name Like '%Xeon%Gold%6142%' Or
          tblProcessor.name Like '%Xeon%Gold%6142F%' Or
          tblProcessor.name Like '%Xeon%Gold%6144%' Or
          tblProcessor.name Like '%Xeon%Gold%6146%' Or
          tblProcessor.name Like '%Xeon%Gold%6148%' Or
          tblProcessor.name Like '%Xeon%Gold%6148F%' Or
          tblProcessor.name Like '%Xeon%Gold%6150%' Or
          tblProcessor.name Like '%Xeon%Gold%6152%' Or
          tblProcessor.name Like '%Xeon%Gold%6154%' Or
          tblProcessor.name Like '%Xeon%Gold%6208U%' Or
          tblProcessor.name Like '%Xeon%Gold%6209U%' Or
          tblProcessor.name Like '%Xeon%Gold%6210U%' Or
          tblProcessor.name Like '%Xeon%Gold%6212U%' Or
          tblProcessor.name Like '%Xeon%Gold%6222V%' Or
          tblProcessor.name Like '%Xeon%Gold%6226%' Or
          tblProcessor.name Like '%Xeon%Gold%6226R%' Or
          tblProcessor.name Like '%Xeon%Gold%6230%' Or
          tblProcessor.name Like '%Xeon%Gold%6230N%' Or
          tblProcessor.name Like '%Xeon%Gold%6230R%' Or
          tblProcessor.name Like '%Xeon%Gold%6230T%' Or
          tblProcessor.name Like '%Xeon%Gold%6234%' Or
          tblProcessor.name Like '%Xeon%Gold%6238%' Or
          tblProcessor.name Like '%Xeon%Gold%6238L%' Or
          tblProcessor.name Like '%Xeon%Gold%6238M%' Or
          tblProcessor.name Like '%Xeon%Gold%6238R%' Or
          tblProcessor.name Like '%Xeon%Gold%6238T%' Or
          tblProcessor.name Like '%Xeon%Gold%6240%' Or
          tblProcessor.name Like '%Xeon%Gold%6240L%' Or
          tblProcessor.name Like '%Xeon%Gold%6240M%' Or
          tblProcessor.name Like '%Xeon%Gold%6240R%' Or
          tblProcessor.name Like '%Xeon%Gold%6240Y%' Or
          tblProcessor.name Like '%Xeon%Gold%6242%' Or
          tblProcessor.name Like '%Xeon%Gold%6242R%' Or
          tblProcessor.name Like '%Xeon%Gold%6244%' Or
          tblProcessor.name Like '%Xeon%Gold%6246%' Or
          tblProcessor.name Like '%Xeon%Gold%6246R%' Or
          tblProcessor.name Like '%Xeon%Gold%6248%' Or
          tblProcessor.name Like '%Xeon%Gold%6248R%' Or
          tblProcessor.name Like '%Xeon%Gold%6250%' Or
          tblProcessor.name Like '%Xeon%Gold%6250L%' Or
          tblProcessor.name Like '%Xeon%Gold%6252%' Or
          tblProcessor.name Like '%Xeon%Gold%6252N%' Or
          tblProcessor.name Like '%Xeon%Gold%6254%' Or
          tblProcessor.name Like '%Xeon%Gold%6256%' Or
          tblProcessor.name Like '%Xeon%Gold%6258R%' Or
          tblProcessor.name Like '%Xeon%Gold%6262V%' Or
          tblProcessor.name Like '%Xeon%Gold%6312U%' Or
          tblProcessor.name Like '%Xeon%Gold%6314U%' Or
          tblProcessor.name Like '%Xeon%Gold%6326%' Or
          tblProcessor.name Like '%Xeon%Gold%6330%' Or
          tblProcessor.name Like '%Xeon%Gold%6330N%' Or
          tblProcessor.name Like '%Xeon%Gold%6334%' Or
          tblProcessor.name Like '%Xeon%Gold%6336Y%' Or
          tblProcessor.name Like '%Xeon%Gold%6338%' Or
          tblProcessor.name Like '%Xeon%Gold%6338N%' Or
          tblProcessor.name Like '%Xeon%Gold%6338T%' Or
          tblProcessor.name Like '%Xeon%Gold%6342%' Or
          tblProcessor.name Like '%Xeon%Gold%6346%' Or
          tblProcessor.name Like '%Xeon%Gold%6348%' Or
          tblProcessor.name Like '%Xeon%Gold%6354%' Or
          tblProcessor.name Like '%Xeon%Gold%6416H%' Or
          tblProcessor.name Like '%Xeon%Gold%6418H%' Or
          tblProcessor.name Like '%Xeon%Gold%6430%' Or
          tblProcessor.name Like '%Xeon%Gold%6438Y%' Or
          tblProcessor.name Like '%Xeon%Gold%6442Y%' Or
          tblProcessor.name Like '%Xeon%Platinum%8153%' Or
          tblProcessor.name Like '%Xeon%Platinum%8156%' Or
          tblProcessor.name Like '%Xeon%Platinum%8158%' Or
          tblProcessor.name Like '%Xeon%Platinum%8160%' Or
          tblProcessor.name Like '%Xeon%Platinum%8160F%' Or
          tblProcessor.name Like '%Xeon%Platinum%8160T%' Or
          tblProcessor.name Like '%Xeon%Platinum%8164%' Or
          tblProcessor.name Like '%Xeon%Platinum%8168%' Or
          tblProcessor.name Like '%Xeon%Platinum%8170%' Or
          tblProcessor.name Like '%Xeon%Platinum%8171M%' Or
          tblProcessor.name Like '%Xeon%Platinum%8176%' Or
          tblProcessor.name Like '%Xeon%Platinum%8176F%' Or
          tblProcessor.name Like '%Xeon%Platinum%8180%' Or
          tblProcessor.name Like '%Xeon%Platinum%8253%' Or
          tblProcessor.name Like '%Xeon%Platinum%8256%' Or
          tblProcessor.name Like '%Xeon%Platinum%8260%' Or
          tblProcessor.name Like '%Xeon%Platinum%8260L%' Or
          tblProcessor.name Like '%Xeon%Platinum%8260M%' Or
          tblProcessor.name Like '%Xeon%Platinum%8260Y%' Or
          tblProcessor.name Like '%Xeon%Platinum%8268%' Or
          tblProcessor.name Like '%Xeon%Platinum%8270%' Or
          tblProcessor.name Like '%Xeon%Platinum%8272CL%' Or
          tblProcessor.name Like '%Xeon%Platinum%8276%' Or
          tblProcessor.name Like '%Xeon%Platinum%8276L%' Or
          tblProcessor.name Like '%Xeon%Platinum%8276M%' Or
          tblProcessor.name Like '%Xeon%Platinum%8280%' Or
          tblProcessor.name Like '%Xeon%Platinum%8280L%' Or
          tblProcessor.name Like '%Xeon%Platinum%8280M%' Or
          tblProcessor.name Like '%Xeon%Platinum%8351N%' Or
          tblProcessor.name Like '%Xeon%Platinum%8352M%' Or
          tblProcessor.name Like '%Xeon%Platinum%8352S%' Or
          tblProcessor.name Like '%Xeon%Platinum%8352V%' Or
          tblProcessor.name Like '%Xeon%Platinum%8352Y%' Or
          tblProcessor.name Like '%Xeon%Platinum%8358%' Or
          tblProcessor.name Like '%Xeon%Platinum%8358P%' Or
          tblProcessor.name Like '%Xeon%Platinum%8360Y%' Or
          tblProcessor.name Like '%Xeon%Platinum%8362%' Or
          tblProcessor.name Like '%Xeon%Platinum%8368%' Or
          tblProcessor.name Like '%Xeon%Platinum%8368Q%' Or
          tblProcessor.name Like '%Xeon%Platinum%8380%' Or
          tblProcessor.name Like '%Xeon%Platinum%8452Y%' Or
          tblProcessor.name Like '%Xeon%Platinum%8460Y%' Or
          tblProcessor.name Like '%Xeon%Platinum%8468%' Or
          tblProcessor.name Like '%Xeon%Platinum%8470%' Or
          tblProcessor.name Like '%Xeon%Platinum%8480%' Or
          tblProcessor.name Like '%Xeon%Platinum%8490H%' Or
          tblProcessor.name Like '%Xeon%Platinum%9221%' Or
          tblProcessor.name Like '%Xeon%Platinum%9222%' Or
          tblProcessor.name Like '%Xeon%Platinum%9242%' Or
          tblProcessor.name Like '%Xeon%Platinum%9282%' Or
          tblProcessor.name Like '%Xeon%Silver%4108%' Or
          tblProcessor.name Like '%Xeon%Silver%4109T%' Or
          tblProcessor.name Like '%Xeon%Silver%4110%' Or
          tblProcessor.name Like '%Xeon%Silver%4112%' Or
          tblProcessor.name Like '%Xeon%Silver%4114%' Or
          tblProcessor.name Like '%Xeon%Silver%4114T%' Or
          tblProcessor.name Like '%Xeon%Silver%4116%' Or
          tblProcessor.name Like '%Xeon%Silver%4116T%' Or
          tblProcessor.name Like '%Xeon%Silver%4208%' Or
          tblProcessor.name Like '%Xeon%Silver%4209T%' Or
          tblProcessor.name Like '%Xeon%Silver%4210%' Or
          tblProcessor.name Like '%Xeon%Silver%4210R%' Or
          tblProcessor.name Like '%Xeon%Silver%4210T%' Or
          tblProcessor.name Like '%Xeon%Silver%4214%' Or
          tblProcessor.name Like '%Xeon%Silver%4214R%' Or
          tblProcessor.name Like '%Xeon%Silver%4214Y%' Or
          tblProcessor.name Like '%Xeon%Silver%4215%' Or
          tblProcessor.name Like '%Xeon%Silver%4215R%' Or
          tblProcessor.name Like '%Xeon%Silver%4216%' Or
          tblProcessor.name Like '%Xeon%Silver%4309Y%' Or
          tblProcessor.name Like '%Xeon%Silver%4310%' Or
          tblProcessor.name Like '%Xeon%Silver%4310T%' Or
          tblProcessor.name Like '%Xeon%Silver%4314%' Or
          tblProcessor.name Like '%Xeon%Silver%4316%' Or
          tblProcessor.name Like '%Xeon%Silver%4410T%' Or
          tblProcessor.name Like '%Xeon%Silver%4410Y%' Or
          tblProcessor.name Like '%Xeon%Silver%4416%' Or
          tblProcessor.name Like '%Xeon%W-10855M%' Or
          tblProcessor.name Like '%Xeon%W-10885M%' Or
          tblProcessor.name Like '%Xeon%W-11055M%' Or
          tblProcessor.name Like '%Xeon%W-11155MLE%' Or
          tblProcessor.name Like '%Xeon%W-11155MRE%' Or
          tblProcessor.name Like '%Xeon%W-11555MLE%' Or
          tblProcessor.name Like '%Xeon%W-11555MRE%' Or
          tblProcessor.name Like '%Xeon%W-11855M%' Or
          tblProcessor.name Like '%Xeon%W-11865MLE%' Or
          tblProcessor.name Like '%Xeon%W-11865MRE%' Or
          tblProcessor.name Like '%Xeon%W-11955M%' Or
          tblProcessor.name Like '%Xeon%W-1250%' Or
          tblProcessor.name Like '%Xeon%W-1250E%' Or
          tblProcessor.name Like '%Xeon%W-1250P%' Or
          tblProcessor.name Like '%Xeon%W-1250TE%' Or
          tblProcessor.name Like '%Xeon%W-1270%' Or
          tblProcessor.name Like '%Xeon%W-1270E%' Or
          tblProcessor.name Like '%Xeon%W-1270P%' Or
          tblProcessor.name Like '%Xeon%W-1270TE%' Or
          tblProcessor.name Like '%Xeon%W-1290%' Or
          tblProcessor.name Like '%Xeon%W-1290E%' Or
          tblProcessor.name Like '%Xeon%W-1290P%' Or
          tblProcessor.name Like '%Xeon%W-1290T%' Or
          tblProcessor.name Like '%Xeon%W-1290TE%' Or
          tblProcessor.name Like '%Xeon%W-1350%' Or
          tblProcessor.name Like '%Xeon%W-1350P%' Or
          tblProcessor.name Like '%Xeon%W-1370%' Or
          tblProcessor.name Like '%Xeon%W-1370P%' Or
          tblProcessor.name Like '%Xeon%W-1390%' Or
          tblProcessor.name Like '%Xeon%W-1390P%' Or
          tblProcessor.name Like '%Xeon%W-1390T%' Or
          tblProcessor.name Like '%Xeon%W-2102%' Or
          tblProcessor.name Like '%Xeon%W-2104%' Or
          tblProcessor.name Like '%Xeon%W-2123%' Or
          tblProcessor.name Like '%Xeon%W-2125%' Or
          tblProcessor.name Like '%Xeon%W-2133%' Or
          tblProcessor.name Like '%Xeon%W-2135%' Or
          tblProcessor.name Like '%Xeon%W-2145%' Or
          tblProcessor.name Like '%Xeon%W-2155%' Or
          tblProcessor.name Like '%Xeon%W-2175%' Or
          tblProcessor.name Like '%Xeon%W-2195%' Or
          tblProcessor.name Like '%Xeon%W-2223%' Or
          tblProcessor.name Like '%Xeon%W-2225%' Or
          tblProcessor.name Like '%Xeon%W-2235%' Or
          tblProcessor.name Like '%Xeon%W-2245%' Or
          tblProcessor.name Like '%Xeon%W-2255%' Or
          tblProcessor.name Like '%Xeon%W-2265%' Or
          tblProcessor.name Like '%Xeon%W-2275%' Or
          tblProcessor.name Like '%Xeon%W-2295%' Or
          tblProcessor.name Like '%Xeon%W-3175X%' Or
          tblProcessor.name Like '%Xeon%W-3223%' Or
          tblProcessor.name Like '%Xeon%W-3225%' Or
          tblProcessor.name Like '%Xeon%W-3235%' Or
          tblProcessor.name Like '%Xeon%W3-2423%' Or
          tblProcessor.name Like '%Xeon%W3-2425%' Or
          tblProcessor.name Like '%Xeon%W3-2435%' Or
          tblProcessor.name Like '%Xeon%W-3245%' Or
          tblProcessor.name Like '%Xeon%W-3245M%' Or
          tblProcessor.name Like '%Xeon%W-3265%' Or
          tblProcessor.name Like '%Xeon%W-3265M%' Or
          tblProcessor.name Like '%Xeon%W-3275%' Or
          tblProcessor.name Like '%Xeon%W-3275M%' Or
          tblProcessor.name Like '%Xeon%W-3323%' Or
          tblProcessor.name Like '%Xeon%W-3335%' Or
          tblProcessor.name Like '%Xeon%W-3345%' Or
          tblProcessor.name Like '%Xeon%W-3365%' Or
          tblProcessor.name Like '%Xeon%W-3375%' Or
          tblProcessor.name Like '%Xeon%W5-2445%' Or
          tblProcessor.name Like '%Xeon%W5-2455X%' Or
          tblProcessor.name Like '%Xeon%W5-2465X%' Or
          tblProcessor.name Like '%Xeon%W5-3423%' Or
          tblProcessor.name Like '%Xeon%W5-3425%' Or
          tblProcessor.name Like '%Xeon%W5-3433%' Or
          tblProcessor.name Like '%Xeon%W5-3435X%' Or
          tblProcessor.name Like '%Xeon%W7-2475X%' Or
          tblProcessor.name Like '%Xeon%W7-2495X%' Or
          tblProcessor.name Like '%Xeon%W7-3445%' Or
          tblProcessor.name Like '%Xeon%W7-3455%' Or
          tblProcessor.name Like '%Xeon%W7-3465X%' Or
          tblProcessor.name Like '%Xeon%W9-3475X%' Or
          tblProcessor.name Like '%Xeon%W9-3495X%') And
        tblProcessor.Manufacturer Like '%%') Or
      ((tblProcessor.name Like '%Snapdragon%850%' Or
          tblProcessor.name Like '%Snapdragon%7c%' Or
          tblProcessor.name Like '%Snapdragon%8c%' Or
          tblProcessor.name Like '%Snapdragon%8cx%' Or
          tblProcessor.name Like '%QCM6490%' Or tblProcessor.name Like
          '%QCS6490%' Or tblProcessor.name Like '%QCM5430%' Or
          tblProcessor.name Like '%QCS5430%' Or tblProcessor.name Like
          '%Microsoft%SQ1%' Or tblProcessor.name Like '%Microsoft%SQ2%' Or
          tblProcessor.name Like '%Microsoft%SQ3%'))) As CPU On
      CPU.AssetID = tblAssets.AssetID
  Left Join (Select Top 1000000 tblAssets.AssetID,
      Case
        When tblTPM.SpecVersion Like '2.0%' Then 'Pass'
        Else 'Fail'
      End As [TPM Version]
    From tblAssets
      Inner Join tblTPM On tblAssets.AssetID = tblTPM.AssetId) As TPM On
      TPM.AssetID = tblAssets.AssetID
  Left Join (Select Top 1000000 tblAssets.AssetID,
      Case
        When Cast(tblAssets.Memory As numeric) >= 4096 Then 'Pass'
        Else 'Fail'
      End As RAM
    From tblAssets
    Where tblAssets.Memory Is Not Null) As RAM On
      RAM.AssetID = tblAssets.AssetID
  Left Join (Select Top 1000000 tblAssets.AssetID,
      tblDiskPartition.PrimaryPartition,
      tblDiskPartition.BootPartition,
      tblDiskPartition.Bootable,
      tblDiskPartition.Type,
      Case
        When tblDiskPartition.Type = 'Installable File System' Then 'Fail'
        Else 'Pass'
      End As [BIOS Type]
    From tblAssets
      Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
      Inner Join tsysAssetTypes On tsysAssetTypes.AssetType =
          tblAssets.Assettype
      Inner Join tblDiskPartition On
          tblAssets.AssetID = tblDiskPartition.AssetID
    Where tblDiskPartition.BootPartition = 1 And tblAssetCustom.State =
      1) As BIOS On BIOS.AssetID = tblAssets.AssetID
  Left Join (Select Top 1000000 tblRegistry.AssetID,
      tblRegistry.Regkey,
      tblRegistry.Valuename,
      tblRegistry.Value,
      tblRegistry.Lastchanged
    From tblRegistry
    Where
      tblRegistry.Regkey Like '%SYSTEM\ControlSet001\Control\SecureBoot\State'
      And tblRegistry.Valuename = 'UEFISecureBootEnabled') As SecureBoot On
      SecureBoot.AssetID = tblAssets.AssetID
  Left Join (Select Top 1000000 tblAssets.AssetID,
      tblAssets.AssetName,
      Cast(Cast(tblDiskdrives.Freespace As bigint) / 1024 / 1024 /
      1024 As numeric) As free,
      Cast(tblDiskdrives.Size / 1024 / 1024 / 1024 As numeric) As TotalSize,
      tblComputersystem.SystemType,
      tblDiskdrives.Caption
    From tblAssets
      Inner Join tblDiskdrives On tblAssets.AssetID = tblDiskdrives.AssetID
      Inner Join tblComputersystem On
          tblAssets.AssetID = tblComputersystem.AssetID
    Where tblDiskdrives.Caption = 'C:' And tblDiskdrives.size Is Not Null) As
  diskspace On diskspace.AssetID = tblAssets.AssetID
  Inner Join tblComputersystem On tblAssets.AssetID = tblComputersystem.AssetID
  Left Join (Select tblVideoController.AssetID,
      tblVideoController.Caption,
      Convert(VarChar,tblVideoController.CurrentHorizontalResolution) + 'x' +
      Convert(VarChar,tblVideoController.CurrentVerticalResolution) + ', ' +
      Convert(VarChar,tblVideoController.CurrentBitsPerPixel) + 'bpp' As
      [GPU Output],
      Case tblVideoController.Availability
        When 1 Then 'Other'
        When 2 Then 'Unknown'
        When 3 Then 'Running'
        When 4 Then 'Warning'
        When 5 Then 'In Test'
        When 6 Then 'Not applicable'
        When 7 Then 'Power off'
        When 8 Then 'Offline'
        When 9 Then 'Off duty'
        When 10 Then 'Degraded'
        When 11 Then 'Not installed'
        When 12 Then 'Install error'
        When 13 Then 'Power save: Unknown'
        When 14 Then 'Power save: Low power'
        When 15 Then 'Power save: Standby'
        When 16 Then 'Power cycle'
        When 17 Then 'Power save: Warning'
        Else 'Undefined: ' + Convert(VarChar,tblVideoController.Availability)
      End As [Video Card State],
      Case
        When tblVideoController.CurrentBitsPerPixel >= 8 And
          tblVideoController.CurrentHorizontalResolution >= 1280 And
          tblVideoController.CurrentVerticalResolution >= 720 Then 'Pass'
        Else 'Fail'
      End As Screen
    From tblVideoController
    Where (tblVideoController.AdapterCompatibility Like '%intel%' Or
        tblVideoController.AdapterCompatibility Like '%amd%' Or
        tblVideoController.AdapterCompatibility Like '%nvidia%')) As Screen On
      Screen.AssetID = tblAssets.AssetID
Where tblAssetCustom.Model Not In ('Virtual Machine', 'VMware7,1',
  'VMware Virtual Platform') And tsysOS.OSname <> 'Win 11' And
  tblState.Statename = 'Active' And tblComputersystem.Domainrole < 2
Order By [W11 Compatible],
  [Disk Space Check] Desc,
  tblAssets.Domain,
  tblAssets.AssetName,
  [Drive Letter]

[IvanR]

Hello!

I've been adapting this (incredible) report to my organization; however, I get duplicate entries for assets, sometimes it's because they have more than one drive, but other times I cannot tell why. Any help would be appreciated 😁

Example: Computer1 has C: and 😧 drives, therefore two entries appear as the report scans for both drive's capacity. But, in many cases I can get up to 4 entries for the same computer despite it only having 2 drives.

Thanks!

[kv-jsmith]

If you use my version, it addresses that, as we found the same problem in our environment. Hope it helps!

https://community.lansweeper.com/t5/reports-analytics/windows-11-compatibility-report/m-p/80232/high...

[Esben_D]

The report is very complex so a lot of different data points are combined and as soon as any of those has 2 values it will create "duplicate" lines. It should be easy enough to see where the difference lies.

The last two days I have updated the report twice to fix some more of those issues. So you could try and grab the latest version and see if it got fixed.

[tchan]

Recently, I found that some CPU types are supported but not included in the original SQL. I can add them manually.

But I’m encountering a problem with duplicate entries of computer names. It seems that one entry shows a BIOS scan pass, while the second entry shows a BIOS scan fail. Any clues on why these duplicate lines are appearing?

[Esben_D]

BIOS type is determined based on the boot partition type. If you have a duplicate because of that, it might be that you have a boot partitions with mixed types, both "Installable File System" and "GPT" for example.

[BelcoCCU]

The link is no longer working. I'm seeing a "this site can't be reached" error message. Is someone able to fix the link so that this report can be accessed?

[Mister_Nobody]

Try again

[kdunnett1]

When I copy the report from the above page into LS,  I get the following error:

Invalid SELECT statement. Unexpected token ";" at line 35, pos 71.

Select Distinct Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tblAssets.Username,
Coalesce(tsysOS.Image, tsysAssetTypes.AssetTypeIcon10) As icon,
tblAssets.IPAddress,
tblAssetCustom.Manufacturer,
tblAssetCustom.Model,
tsysIPLocations.IPLocation,
tblProcessor.Name As CPU,
diskspace.Caption as [Drive Letter],
diskspace.free as [Free Disk Space(GB)],
Case
When CPU.AssetID = tblAssets.AssetID And (TPM.[TPM Version] Is Not Null and TPM.[TPM Version] = 'Pass')
And BIOS.[BIOS Type] = 'Pass' And RAM.RAM = 'Pass' And tblAssets.AssetID =
diskspace.AssetID Then 'Yes'
Else 'No'
End As [W11 Compatible],
Case
When CPU.AssetID = tblAssets.AssetID Then 'Pass'
Else 'Fail'
End As [CPU Compatible],
Case
When TPM.[TPM Version] Is Null Then 'Fail'
Else TPM.[TPM Version]
End As [TPM Version 2.0],
BIOS.[BIOS Type] As [BIOS Type EUFI],
Case
When SecureBoot.Value = 0 Then 'No'
When SecureBoot.Value = 1 Then 'Yes'
Else 'RegKey not found'
End As [Secure Boot Enabled],
RAM.RAM As [RAM > 4GB],
Case
When tblAssets.AssetID = diskspace.AssetID and diskspace.TotalSize > 64