→ 🚀Are you a Lansweeper Champion?! Join our Contributor Program Sign up here!

Community FAQ
cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Asdfzxcvm
Engaged Sweeper

Hi everyone,

not sure if anyone else had this problem but I got the Lansweeper report for windows 11 readiness to see if our devices are compatible for a win 11 upgrade, modified it for 16 GB RAM because on 8 GB it runs awful and what I noticed is the storage is supposed to be above 64 GB in order for the device to "Pass" that criteria, but I have a lot of devices which show as eligible even though I have 2 GB of free storage. could anyone help on this?

code is below:

 

 

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 > 15GB],
  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 Then '#d4f4be'
    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%3%100U%' Or
          tblProcessor.name Like '%Core%5%120U%' Or
          tblProcessor.name Like '%Core%7%150U%' 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%14100%' Or
          tblProcessor.name Like '%Core%i3%14100F%' Or
          tblProcessor.name Like '%Core%i3%14100T%' 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%14400%' Or
          tblProcessor.name Like '%Core%i5%14500%' Or
          tblProcessor.name Like '%Core%i5%14600%' 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%14700%' Or
          tblProcessor.name Like '%Core%i7%14700F%' Or
          tblProcessor.name Like '%Core%i7%14700K%' Or
          tblProcessor.name Like '%Core%i7%14700KF%' Or
          tblProcessor.name Like '%Core%i7%14700T%' 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%14900%' Or
          tblProcessor.name Like '%Core%i9%14900F%' Or
          tblProcessor.name Like '%Core%i9%14900K%' Or
          tblProcessor.name Like '%Core%i9%14900KF%' Or
          tblProcessor.name Like '%Core%i9%14900T%' 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 '%Core%m3%8100Y%' Or
          tblProcessor.name Like '%Core%Ultra%5%125H%' Or
          tblProcessor.name Like '%Core%Ultra%5%125U%' Or
          tblProcessor.name Like '%Core%Ultra%5%134U%' Or
          tblProcessor.name Like '%Core%Ultra%5%135H%' Or
          tblProcessor.name Like '%Core%Ultra%5%135U%' Or
          tblProcessor.name Like '%Core%Ultra%7%155H%' Or
          tblProcessor.name Like '%Core%Ultra%7%155U%' Or
          tblProcessor.name Like '%Core%Ultra%7%164U%' Or
          tblProcessor.name Like '%Core%Ultra%7%165H%' Or
          tblProcessor.name Like '%Core%Ultra%7%165U%' Or
          tblProcessor.name Like '%Core%Ultra%9%185H%' 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) >= 15360 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 Not Like '%GPT%' 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.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 tsysOS.OSname <> 'Win 11' And tblState.Statename = 'Active' And
  tblComputersystem.Domainrole < 2
Order By tblAssets.Domain,
  tblAssets.AssetName

 

 

Thank you

1 ACCEPTED SOLUTION
KevinA-REJIS
Champion Sweeper III

I believe the Pass/Fail for the disk space is for the total size of the drive, not the free space. 

View solution in original post

2 REPLIES 2
KevinA-REJIS
Champion Sweeper III

I believe the Pass/Fail for the disk space is for the total size of the drive, not the free space. 

Esben_D
Lansweeper Employee
Lansweeper Employee

Correct. Microsoft requirements list storage drive capacity as a requirement, not free space.image (16).png

Reports & Analytics

Ask about reports you're interested in and share reports you've created. Subscribe to receive daily updates of reports shared in the Community.

New to Lansweeper?

Try Lansweeper For Free

Experience Lansweeper with your own data.
Sign up now for a 14-day free trial.

Try Now