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, Case When (CPU.AssetID = tblAssets.AssetID Or (SubQuery1.Valuename Is Not Null And SubQuery1.Value = '1')) And (TPM.[TPM Version] Is Not Null And TPM.[TPM Version] = 'Pass') And BIOS.[BIOS Type] = 'Pass' And RAM.RAM = 'Pass' And tblAssets.AssetID = freespace.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 SubQuery1.Value Is Not Null And SubQuery1.Value = '1' Then 'Yes' Else 'No' End As [Unsupported CPU/TPM Allowed], Case When TPM.[TPM Version] Is Null Then 'Fail' Else TPM.[TPM Version] End As [TPM Version 2.0], BIOS.[BIOS Type] As [BIOS Type EUFI], Case When SecureBoot.Value = 0 Then 'No' When SecureBoot.Value = 1 Then 'Yes' Else 'RegKey not found' End As [Secure Boot Enabled], RAM.RAM As [RAM > 4GB], Case When tblAssets.AssetID = freespace.AssetID 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 = freespace.AssetID Then '#d4f4be' When (CPU.AssetID = tblAssets.AssetID Or (SubQuery1.Valuename Is Not Null And SubQuery1.Value = '1')) And (TPM.[TPM Version] Is Not Null And TPM.[TPM Version] = 'Pass') And BIOS.[BIOS Type] = 'Pass' And RAM.RAM = 'Pass' And tblAssets.AssetID = freespace.AssetID Then '#FFD580' 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%3150C%' Or tblProcessor.name Like '%Athlon%3150G%' Or tblProcessor.name Like '%Athlon%3150GE%' Or tblProcessor.name Like '%Athlon%3150U%' Or tblProcessor.name Like '%Athlon%3050C%' Or tblProcessor.name Like '%Athlon%3050e%' Or tblProcessor.name Like '%Athlon%3050GE%' Or tblProcessor.name Like '%Athlon%3050U%' 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%3%3100%' 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%5300U%' Or tblProcessor.name Like '%Ryzen%3%5400U%' 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%5%2600%' Or tblProcessor.name Like '%Ryzen%5%3600%' 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%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%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%4600U%' Or tblProcessor.name Like '%Ryzen%5%5300G%' Or tblProcessor.name Like '%Ryzen%5%5300GE%' Or tblProcessor.name Like '%Ryzen%5%5500U%' 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%2600%' Or tblProcessor.name Like '%Ryzen%5%3600%' 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%5650G%' Or tblProcessor.name Like '%Ryzen%5%5650GE%' Or tblProcessor.name Like '%Ryzen%5%5650U%' Or tblProcessor.name Like '%Ryzen%5%5750G%' Or tblProcessor.name Like '%Ryzen%5%5750GE%' Or tblProcessor.name Like '%Ryzen%7%2700%' Or tblProcessor.name Like '%Ryzen%7%5800%' 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%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%2700%' 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%5850U%' Or tblProcessor.name Like '%Ryzen%9%5900%' 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%3900%' Or tblProcessor.name Like '%Ryzen%Threadripper%2920X%' Or tblProcessor.name Like '%Ryzen%Threadripper%2950X%' Or tblProcessor.name Like '%Ryzen%Threadripper%2970WX%' Or tblProcessor.name Like '%Ryzen%Threadripper%2990WX%' Or tblProcessor.name Like '%Ryzen%Threadripper%3960X%' Or tblProcessor.name Like '%Ryzen%Threadripper%3970X%' Or tblProcessor.name Like '%Ryzen%Threadripper%3990X%' Or tblProcessor.name Like '%Ryzen%Threadripper%3945WX%' Or tblProcessor.name Like '%Ryzen%Threadripper%3955WX%' Or tblProcessor.name Like '%Ryzen%Threadripper%3975WX%' Or tblProcessor.name Like '%Ryzen%Threadripper%3995WX%') And (tblProcessor.Manufacturer Like '%AMD%' 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%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%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%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 '%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-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-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-L13G4%' 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-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-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-7640X%' 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%i5-L16G7%' 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-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-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-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-7740X%' 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-7900X%' Or tblProcessor.name Like '%Core%i9-7920X%' Or tblProcessor.name Like '%Core%i9-7940X%' Or tblProcessor.name Like '%Core%i9-7960X%' Or tblProcessor.name Like '%Core%i9-7980XE%' Or tblProcessor.name Like '%Core%i9-8950HK%' Or tblProcessor.name Like '%Core%i9-9820X%' Or tblProcessor.name Like '%Core%i9-9880H%' Or tblProcessor.name Like '%Core%i9-9900%' Or tblProcessor.name Like '%Core%i9-9900K%' Or tblProcessor.name Like '%Core%i9-9900KF%' Or tblProcessor.name Like '%Core%i9-9900KS%' Or tblProcessor.name Like '%Core%i9-9900T%' Or tblProcessor.name Like '%Core%i9-9900X%' Or tblProcessor.name Like '%Core%i9-9920X%' Or tblProcessor.name Like '%Core%i9-9940X%' Or tblProcessor.name Like '%Core%i9-9960X%' Or tblProcessor.name Like '%Core%i9-9980HK%' Or tblProcessor.name Like '%Core%i9-9980XE%' Or tblProcessor.name Like '%Core%m3-8100Y%' Or tblProcessor.name Like '%Pentium%6805%' 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%7505%' 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%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%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 '%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%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%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%5320%' Or tblProcessor.name Like '%Xeon%Gold%5320T%' 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%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%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%Gold%5318Y%' 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%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%8260Y%' Or tblProcessor.name Like '%Xeon%Platinum%8268%' Or tblProcessor.name Like '%Xeon%Platinum%8270%' Or tblProcessor.name Like '%Xeon%Platinum%8276%' Or tblProcessor.name Like '%Xeon%Platinum%8276L%' Or tblProcessor.name Like '%Xeon%Platinum%8280%' Or tblProcessor.name Like '%Xeon%Platinum%8280L%' 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%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%W-10855M%' Or tblProcessor.name Like '%Xeon%W-10885M%' Or tblProcessor.name Like '%Xeon%W-11855M%' 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-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%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%') And tblProcessor.Manufacturer Like '%Intel%') 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 '%Microsoft%SQ1%' Or tblProcessor.Name Like '%Microsoft%SQ2%'))) As CPU On CPU.AssetID = tblAssets.AssetID Left Join (Select Top 1000000 tblAssets.AssetID, Case When tblTPM.SpecVersion Like '2.0%' Then 'Pass' Else 'Fail' End As [TPM Version] From tblAssets Inner Join tblTPM On tblAssets.AssetID = tblTPM.AssetId) As TPM On TPM.AssetID = tblAssets.AssetID Left Join (Select Top 1000000 tblAssets.AssetID, Case When Cast(tblAssets.Memory As numeric) >= 4096 Then 'Pass' Else 'Fail' End As RAM From tblAssets Where tblAssets.Memory Is Not Null) As RAM On RAM.AssetID = tblAssets.AssetID Left Join (Select Top 1000000 tblAssets.AssetID, tblDiskPartition.PrimaryPartition, tblDiskPartition.BootPartition, tblDiskPartition.Bootable, tblDiskPartition.Type, Case When tblDiskPartition.Type = 'Installable File System' Then 'Fail' Else 'Pass' End As [BIOS Type] From tblAssets Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype Inner Join tblDiskPartition On tblAssets.AssetID = tblDiskPartition.AssetID Where tblDiskPartition.BootPartition = 1 And tblAssetCustom.State = 1) As BIOS On BIOS.AssetID = tblAssets.AssetID Left Join (Select Top 1000000 tblRegistry.AssetID, tblRegistry.Regkey, tblRegistry.Valuename, tblRegistry.Value, tblRegistry.Lastchanged From tblRegistry Where tblRegistry.Regkey Like '%SYSTEM\ControlSet001\Control\SecureBoot\State' And tblRegistry.Valuename = 'UEFISecureBootEnabled') As SecureBoot On SecureBoot.AssetID = tblAssets.AssetID Left Join (Select Top 1000000 tblAssets.AssetID, tblAssets.AssetName, Cast(Cast(tblDiskdrives.Freespace As bigint) / 1024 / 1024 As numeric) As free, tblComputersystem.SystemType From tblAssets Inner Join tblDiskdrives On tblAssets.AssetID = tblDiskdrives.AssetID Inner Join tblComputersystem On tblAssets.AssetID = tblComputersystem.AssetID Where Cast(Cast(tblDiskdrives.Freespace As bigint) / 1024 / 1024 As numeric) > 64000) As freespace On freespace.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 Left Join (Select Top 1000000 tblRegistry.AssetID, tblRegistry.Regkey, tblRegistry.Valuename, tblRegistry.Value, tblRegistry.Lastchanged From tblRegistry Where tblRegistry.Regkey Like '%SYSTEM\Setup\MoSetup' And tblRegistry.Valuename = 'AllowUpgradesWithUnsupportedTPMOrCPU') SubQuery1 On SubQuery1.AssetID = tblAssets.AssetID Where tsysOS.OSname <> 'Win 11' And tblState.Statename = 'Active' And tblComputersystem.Domainrole < 2 Order By tblAssets.Domain, tblAssets.AssetName