This website uses cookies. By clicking Accept, you consent to the use of cookies. Click Here to learn more about how we use cookies.
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
- Lansweeper Community
- Forums
- Reports & Analytics
- Windows 11 readiness report - storage not working ...
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Register to ask a question, start a topic or share an idea
Join the Community
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
5 hours ago
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
Labels:
- Labels:
-
Other Report Topics
-
scanning
1 REPLY 1
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
3 hours ago
I believe the Pass/Fail for the disk space is for the total size of the drive, not the free space.
New to Lansweeper?
Try Lansweeper For Free
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now
Related Content
- Unlock the Future of Device Management with Devicie Endpoint Health dashboard! in General Discussions
- Empty allInstallations response from API in General Discussions
- Ticket dispatching not working in General Discussions
- Need Assistance Creating Tickets? Report your issue on our webform in General Discussions
