Windows 11 Requirements Audit

Getting Ready for Windows 11

Windows 10 will go end of life in 2025. It will be followed up Windows 11. Running an unsupported version of Windows can be a significant security risk for your organization since those computers will no longer get critical security patches. Additionally, you won't be able to rely on Microsoft for any issues regarding the operating system either. Once Windows 10 reaches end of life in 2025, it is important that you have finished moving all your computers to Windows 11. Find more information on the win11 minimum system requirements in our dedicated blog: Is Your Business Ready for Windows 11?

Microsoft has not been very clear on their system requirements. Compared to Windows 10, these are much stricter and it won't be as easy as updating to a new Windows 10 version. To prevent confusion, you can find the official Microsoft requirements here which we use in our report. The current report uses the following requirements:

Processor:1 gigahertz (GHz) or faster with 2 or more cores on a compatible 64-bit processor or System on a Chip (SoC)

Note: The report uses the provided 64-bit processor list to check compatibility.

RAM:4 gigabyte (GB)
Storage:64 GB or larger storage device
System firmware:UEFI, Secure Boot capable

Note: The report does not use secure boot as a hard requirement (indicated by the row colors) since capability cannot be scanned. To scan the Secure boot state, you can add the following configuration to your registry scanning.

Rootkey: HKEY_LOCAL_MACHINE
Regpath: SYSTEM\ControlSet001\Control\SecureBoot\State
Regvalue: UEFISecureBootEnabled

TPM:Trusted Platform Module (TPM) version 2.0
Graphics card:Compatible with DirectX 12 or later with WDDM 2.0 driver

Note: The report does not use this as a hard requirement as it is not scanned. Instead, it displays the GPU's name.

Display:High definition (720p) display that is greater than 9" diagonally, 8 bits per color channel

Note: The report checks whether your GPU outputs an image in 720p, 8bit or higher. It does not contain display size and neither are used as a hard requirement.

The report below provided an overview of which devices are capable of running Windows 11. A device is considered capable when it meets the processor, RAM, storage, BIOS mode, and TPM requirements listed above.

Windows 11 Requirements Query

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 And TPM.[TPM Version] Is Not Null 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 TPM.[TPM Version] Is Null Then 'Fail'
Else 'Pass'
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'
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,
tblAssets.AssetName,
tblComputersystem.SystemType,
Sum(Cast(Cast(tblPhysicalMemory.Capacity As bigint) / 1024 /
1024 As numeric)) As Memory,
Case
When Sum(Cast(Cast(tblPhysicalMemory.Capacity As bigint) / 1024 /
1024 As numeric)) >= 4096 Then 'Pass'
Else 'Fail'
End As RAM
From tblAssets
Inner Join tblComputersystem On
tblAssets.AssetID = tblComputersystem.AssetID
Inner Join tblPhysicalMemory On
tblAssets.AssetID = tblPhysicalMemory.AssetID
Group By tblAssets.AssetID,
tblAssets.AssetName,
tblComputersystem.SystemType,
tblAssets.Memory) 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
Where tsysOS.OSname <> 'Win 11' And tblState.Statename = 'Active' And
tblComputersystem.Domainrole < 2
Order By tblAssets.Domain,
tblAssets.AssetName

Audit and Take Action in 3 Easy Steps

1. Download & Install Lansweeper

3. Run the Audit & Take Action

Download Lansweeper to Run this Audit

Harness the Power of Reporting