This website uses cookies. By clicking Accept, you consent to the use of cookies. Click Here to learn more about how we use cookies.
Community FAQ
Register | Log In
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
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
- Re: Report Request: Computers that are currently W...
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
10-16-2024 04:19 PM
Is there a report that will show PCs that can be Windows 11 and just aren't yet?
Labels:
- Labels:
-
User-Generated Reports
2 REPLIES 2
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-17-2024 08:46 PM
This is one I have, I believe it was created by @Esben_D
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,
freespace.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 = 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 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'
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 '%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%3125GE%' Or
tblProcessor.name Like '%Athlon%3150G%' Or
tblProcessor.name Like '%Athlon%3150GE%' 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%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%5300GE%' Or
tblProcessor.name Like '%Ryzen%3%5300U%' Or
tblProcessor.name Like '%Ryzen%3%5400U%' Or
tblProcessor.name Like '%Ryzen%3%7320e%' Or
tblProcessor.name Like '%Ryzen%3%7320U%' 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%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%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%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%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%6600H%' Or
tblProcessor.name Like '%Ryzen%5%6600U%' Or
tblProcessor.name Like '%Ryzen%5%7520U%' Or
tblProcessor.name Like '%Ryzen%5%7600X%' Or
tblProcessor.name Like '%Ryzen%5%7[0-9][0-9][0-9]%' Or
tblProcessor.name Like '%Ryzen%5%2600%' Or
tblProcessor.name Like '%Ryzen%5%3600%' 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%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%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%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%6800H%' 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%7[0-9][0-9][0-9]%' Or
tblProcessor.name Like '%Ryzen%7%2700%' Or
tblProcessor.name Like '%Ryzen%7%3700%' 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%9%5900%' 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%6900HX%' Or
tblProcessor.name Like '%Ryzen%9%6980HX%' Or
tblProcessor.name Like '%Ryzen%9%7900X%' Or
tblProcessor.name Like '%Ryzen%9%7950X%' Or
tblProcessor.name Like '%Ryzen%9%7[0-9][0-9][0-9]%' Or
tblProcessor.name Like '%Ryzen%9%3900%' Or
tblProcessor.name Like '%Ryzen%9%3900%' 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 '%Threadripper%5945WX%' Or
tblProcessor.name Like '%Threadripper%5955WX%' Or
tblProcessor.name Like '%Threadripper%5965WX%' Or
tblProcessor.name Like '%Threadripper%5975WX%' Or
tblProcessor.name Like '%Threadripper%5995WX%') 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%7300%' Or
tblProcessor.name Like '%Celeron%7305%' Or
tblProcessor.name Like '%Celeron%3867U%' Or
tblProcessor.name Like '%Celeron%4205U%' Or
tblProcessor.name Like '%Celeron%4305U%' Or
tblProcessor.name Like '%Celeron%4305UE%' Or
tblProcessor.name Like '%Celeron%5205U%' Or
tblProcessor.name Like '%Celeron%5305U%' Or
tblProcessor.name Like '%Celeron%6305E%' Or
tblProcessor.name Like '%Celeron%6600HE%' Or
tblProcessor.name Like '%Celeron%7305E%' Or
tblProcessor.name Like '%Celeron%7305L%' Or
tblProcessor.name Like '%Celeron%G4900%' Or
tblProcessor.name Like '%Celeron%G4900T%' Or
tblProcessor.name Like '%Celeron%G4920%' Or
tblProcessor.name Like '%Celeron%G4930%' Or
tblProcessor.name Like '%Celeron%G4930E%' Or
tblProcessor.name Like '%Celeron%G4930T%' Or
tblProcessor.name Like '%Celeron%G4932E%' Or
tblProcessor.name Like '%Celeron%G4950%' Or
tblProcessor.name Like '%Celeron%G5900%' Or
tblProcessor.name Like '%Celeron%G5900E%' Or
tblProcessor.name Like '%Celeron%G5900T%' Or
tblProcessor.name Like '%Celeron%G5900TE%' Or
tblProcessor.name Like '%Celeron%G5905%' Or
tblProcessor.name Like '%Celeron%G5905T%' Or
tblProcessor.name Like '%Celeron%G5920%' Or
tblProcessor.name Like '%Celeron%G5925%' Or
tblProcessor.name Like '%Celeron%G6900%' Or
tblProcessor.name Like '%Celeron%G6900E%' Or
tblProcessor.name Like '%Celeron%G6900T%' Or
tblProcessor.name Like '%Celeron%G6900TE%' Or
tblProcessor.name Like '%Celeron%J4005%' Or
tblProcessor.name Like '%Celeron%J4025%' Or
tblProcessor.name Like '%Celeron%J4105%' Or
tblProcessor.name Like '%Celeron%J4115%' Or
tblProcessor.name Like '%Celeron%J4125%' Or
tblProcessor.name Like '%Celeron%J6412%' Or
tblProcessor.name Like '%Celeron%J6413%' Or
tblProcessor.name Like '%Celeron%N4000%' Or
tblProcessor.name Like '%Celeron%N4020%' Or
tblProcessor.name Like '%Celeron%N4100%' Or
tblProcessor.name Like '%Celeron%N4120%' Or
tblProcessor.name Like '%Celeron%N4500%' Or
tblProcessor.name Like '%Celeron%N4505%' Or
tblProcessor.name Like '%Celeron%N5100%' Or
tblProcessor.name Like '%Celeron%N5105%' Or
tblProcessor.name Like '%Celeron%N6210%' Or
tblProcessor.name Like '%Celeron%N6211%' Or
tblProcessor.name Like '%13th gen%' Or
tblProcessor.name Like '%Core%i3-1000G1%' Or
tblProcessor.name Like '%Core%i3-1000G4%' Or
tblProcessor.name Like '%Core%i3-1005G1%' Or
tblProcessor.name Like '%Core%i3-10100%' Or
tblProcessor.name Like '%Core%i3-10100E%' Or
tblProcessor.name Like '%Core%i3-10100F%' Or
tblProcessor.name Like '%Core%i3-10100T%' Or
tblProcessor.name Like '%Core%i3-10100TE%' Or
tblProcessor.name Like '%Core%i3-10100Y%' Or
tblProcessor.name Like '%Core%i3-10105%' Or
tblProcessor.name Like '%Core%i3-10105F%' Or
tblProcessor.name Like '%Core%i3-10105T%' Or
tblProcessor.name Like '%Core%i3-10110U%' Or
tblProcessor.name Like '%Core%i3-10110Y%' Or
tblProcessor.name Like '%Core%i3-10300%' Or
tblProcessor.name Like '%Core%i3-10300T%' Or
tblProcessor.name Like '%Core%i3-10305%' Or
tblProcessor.name Like '%Core%i3-10305T%' Or
tblProcessor.name Like '%Core%i3-10320%' Or
tblProcessor.name Like '%Core%i3-10325%' Or
tblProcessor.name Like '%Core%i3-11100HE%' Or
tblProcessor.name Like '%Core%i3-1110G4%' Or
tblProcessor.name Like '%Core%i3-1115G4%' Or
tblProcessor.name Like '%Core%i3-1115G4E%' Or
tblProcessor.name Like '%Core%i3-1115GRE%' Or
tblProcessor.name Like '%Core%i3-1120G4%' Or
tblProcessor.name Like '%Core%i3-1125G4%' Or
tblProcessor.name Like '%Core%i3-12100%' Or
tblProcessor.name Like '%Core%i3-12100E%' Or
tblProcessor.name Like '%Core%i3-12100F%' Or
tblProcessor.name Like '%Core%i3-12100T%' Or
tblProcessor.name Like '%Core%i3-12100TE%' Or
tblProcessor.name Like '%Core%i3-1210U%' Or
tblProcessor.name Like '%Core%i3-1215U%' Or
tblProcessor.name Like '%Core%i3-1215UE%' Or
tblProcessor.name Like '%Core%i3-1215UL%' Or
tblProcessor.name Like '%Core%i3-1220P%' Or
tblProcessor.name Like '%Core%i3-1220PE%' Or
tblProcessor.name Like '%Core%i3-12300%' Or
tblProcessor.name Like '%Core%i3-12300HE%' Or
tblProcessor.name Like '%Core%i3-12300HL%' Or
tblProcessor.name Like '%Core%i3-12300T%' Or
tblProcessor.name Like '%Core%i3-13100%' Or
tblProcessor.name Like '%Core%i3-13100F%' Or
tblProcessor.name Like '%Core%i3-13100T%' 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%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-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-13400%' Or
tblProcessor.name Like '%Core%i5-13400F%' Or
tblProcessor.name Like '%Core%i5-13400T%' Or
tblProcessor.name Like '%Core%i5-13500%' Or
tblProcessor.name Like '%Core%i5-13500T%' Or
tblProcessor.name Like '%Core%i5-13600%' Or
tblProcessor.name Like '%Core%i5-13600K%' Or
tblProcessor.name Like '%Core%i5-13600KF%' Or
tblProcessor.name Like '%Core%i5-13600T%' Or
tblProcessor.name Like '%Core%i5-8200Y%' Or
tblProcessor.name Like '%Core%i5-8210Y%' Or
tblProcessor.name Like '%Core%i5-8250U%' Or
tblProcessor.name Like '%Core%i5-8257U%' Or
tblProcessor.name Like '%Core%i5-8259U%' Or
tblProcessor.name Like '%Core%i5-8260U%' Or
tblProcessor.name Like '%Core%i5-8265U%' Or
tblProcessor.name Like '%Core%i5-8269U%' Or
tblProcessor.name Like '%Core%i5-8279U%' Or
tblProcessor.name Like '%Core%i5-8300H%' Or
tblProcessor.name Like '%Core%i5-8305G%' Or
tblProcessor.name Like '%Core%i5-8310Y%' Or
tblProcessor.name Like '%Core%i5-8350U%' Or
tblProcessor.name Like '%Core%i5-8365U%' Or
tblProcessor.name Like '%Core%i5-8365UE%' Or
tblProcessor.name Like '%Core%i5-8400%' Or
tblProcessor.name Like '%Core%i5-8400B%' Or
tblProcessor.name Like '%Core%i5-8400H%' Or
tblProcessor.name Like '%Core%i5-8400T%' Or
tblProcessor.name Like '%Core%i5-8500%' Or
tblProcessor.name Like '%Core%i5-8500B%' Or
tblProcessor.name Like '%Core%i5-8500T%' Or
tblProcessor.name Like '%Core%i5-8600%' Or
tblProcessor.name Like '%Core%i5-8600K%' Or
tblProcessor.name Like '%Core%i5-8600T%' Or
tblProcessor.name Like '%Core%i5-9300H%' Or
tblProcessor.name Like '%Core%i5-9300HF%' Or
tblProcessor.name Like '%Core%i5-9400%' Or
tblProcessor.name Like '%Core%i5-9400F%' Or
tblProcessor.name Like '%Core%i5-9400H%' Or
tblProcessor.name Like '%Core%i5-9400T%' Or
tblProcessor.name Like '%Core%i5-9500%' Or
tblProcessor.name Like '%Core%i5-9500E%' Or
tblProcessor.name Like '%Core%i5-9500F%' Or
tblProcessor.name Like '%Core%i5-9500T%' Or
tblProcessor.name Like '%Core%i5-9500TE%' Or
tblProcessor.name Like '%Core%i5-9600%' Or
tblProcessor.name Like '%Core%i5-9600K%' Or
tblProcessor.name Like '%Core%i5-9600KF%' Or
tblProcessor.name Like '%Core%i5-9600T%' Or
tblProcessor.name Like '%Core%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-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-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-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-13700%' Or
tblProcessor.name Like '%Core%i7-13700F%' 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-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-13900F%' Or
tblProcessor.name Like '%Core%i9-13900K%' Or
tblProcessor.name Like '%Core%i9-13900KF%' Or
tblProcessor.name Like '%Core%i9-13900T%' Or
tblProcessor.name Like '%Core%i9-7900X%' Or
tblProcessor.name Like '%Core%i9-7920X%' Or
tblProcessor.name Like '%Core%i9-7940X%' Or
tblProcessor.name Like '%Core%i9-7960X%' Or
tblProcessor.name Like '%Core%i9-7980XE%' Or
tblProcessor.name Like '%Core%i9-8950HK%' Or
tblProcessor.name Like '%Core%i9-9820X%' Or
tblProcessor.name Like '%Core%i9-9880H%' Or
tblProcessor.name Like '%Core%i9-9900%' Or
tblProcessor.name Like '%Core%i9-9900K%' Or
tblProcessor.name Like '%Core%i9-9900KF%' Or
tblProcessor.name Like '%Core%i9-9900KS%' Or
tblProcessor.name Like '%Core%i9-9900T%' Or
tblProcessor.name Like '%Core%i9-9900X%' Or
tblProcessor.name Like '%Core%i9-9920X%' Or
tblProcessor.name Like '%Core%i9-9940X%' Or
tblProcessor.name Like '%Core%i9-9960X%' Or
tblProcessor.name Like '%Core%i9-9980HK%' Or
tblProcessor.name Like '%Core%i9-9980XE%' Or
tblProcessor.name Like '%Core%m3-8100Y%' Or
tblProcessor.name Like '%Pentium%Gold%4417U%' Or
tblProcessor.name Like '%Pentium%Gold%4425Y%' Or
tblProcessor.name Like '%Pentium%Gold%5405U%' Or
tblProcessor.name Like '%Pentium%Gold%6405U%' Or
tblProcessor.name Like '%Pentium%Gold%6500Y%' Or
tblProcessor.name Like '%Pentium%Gold%6805%' Or
tblProcessor.name Like '%Pentium%Gold%7505%' Or
tblProcessor.name Like '%Pentium%Gold%8500%' Or
tblProcessor.name Like '%Pentium%Gold%8505%' Or
tblProcessor.name Like '%Pentium%Gold%G5400%' Or
tblProcessor.name Like '%Pentium%Gold%G5400T%' Or
tblProcessor.name Like '%Pentium%Gold%G5420%' Or
tblProcessor.name Like '%Pentium%Gold%G5420T%' Or
tblProcessor.name Like '%Pentium%Gold%G5500%' Or
tblProcessor.name Like '%Pentium%Gold%G5500T%' Or
tblProcessor.name Like '%Pentium%Gold%G5600%' Or
tblProcessor.name Like '%Pentium%Gold%G5600E%' Or
tblProcessor.name Like '%Pentium%Gold%G5600T%' Or
tblProcessor.name Like '%Pentium%Gold%G5620%' Or
tblProcessor.name Like '%Pentium%Gold%G6400%' Or
tblProcessor.name Like '%Pentium%Gold%G6400E%' Or
tblProcessor.name Like '%Pentium%Gold%G6400T%' Or
tblProcessor.name Like '%Pentium%Gold%G6400TE%' Or
tblProcessor.name Like '%Pentium%Gold%G6405%' Or
tblProcessor.name Like '%Pentium%Gold%G6405T%' Or
tblProcessor.name Like '%Pentium%Gold%G6500%' Or
tblProcessor.name Like '%Pentium%Gold%G6500T%' Or
tblProcessor.name Like '%Pentium%Gold%G6505%' Or
tblProcessor.name Like '%Pentium%Gold%G6505T%' Or
tblProcessor.name Like '%Pentium%Gold%G6600%' Or
tblProcessor.name Like '%Pentium%Gold%G6605%' Or
tblProcessor.name Like '%Pentium%Gold%G7400%' Or
tblProcessor.name Like '%Pentium%Gold%G7400E%' Or
tblProcessor.name Like '%Pentium%Gold%G7400T%' Or
tblProcessor.name Like '%Pentium%Gold%G7400TE%' Or
tblProcessor.name Like '%Pentium%J6426%' Or
tblProcessor.name Like '%Pentium%N6415%' Or
tblProcessor.name Like '%Pentium%Silver%J5005%' Or
tblProcessor.name Like '%Pentium%Silver%J5040%' Or
tblProcessor.name Like '%Pentium%Silver%N5000%' Or
tblProcessor.name Like '%Pentium%Silver%N5030%' Or
tblProcessor.name Like '%Pentium%Silver%N6000%' Or
tblProcessor.name Like '%Pentium%Silver%N6005%' Or
tblProcessor.name Like '%Processor%N100%' Or
tblProcessor.name Like '%Processor%N200%' 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%E-2314%' Or
tblProcessor.name Like '%Xeon%E-2324G%' Or
tblProcessor.name Like '%Xeon%E-2334%' Or
tblProcessor.name Like '%Xeon%E-2336%' Or
tblProcessor.name Like '%Xeon%E-2356G%' Or
tblProcessor.name Like '%Xeon%E-2374G%' Or
tblProcessor.name Like '%Xeon%E-2378%' Or
tblProcessor.name Like '%Xeon%E-2378G%' Or
tblProcessor.name Like '%Xeon%E-2386G%' Or
tblProcessor.name Like '%Xeon%E-2388G%' 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%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%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%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-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-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%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%') And
tblProcessor.Manufacturer Like '%Intel%') Or
((tblProcessor.name Like '%Snapdragon %Snapdragon 850%' Or
tblProcessor.name Like '%Snapdragon %Snapdragon 7c%' Or
tblProcessor.name Like '%Snapdragon %Snapdragon 8c%' Or
tblProcessor.name Like '%Snapdragon %Snapdragon 8cx%' Or
tblProcessor.name Like '%Snapdragon %Microsoft SQ1%' Or
tblProcessor.name Like '%Snapdragon %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 /
1024 As numeric) As free,
Cast(tblDiskdrives.Size / 1024 / 1024 / 1024 As numeric) As TotalSize,
tblComputersystem.SystemType
From tblAssets
Inner Join tblDiskdrives On tblAssets.AssetID = tblDiskdrives.AssetID
Inner Join tblComputersystem On
tblAssets.AssetID = tblComputersystem.AssetID
Where Cast(tblDiskdrives.Size / 1024 / 1024 / 1024 As numeric) >
64) 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
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-24-2024 02:53 PM - edited 10-24-2024 02:58 PM
Hi
Cool report!
Here it was shared and it is still updated every couple of months/weeks:
https://www.lansweeper.com/resources/report/hardware-components/windows-11-requirements-audit/
Reports & Analytics
Ask about reports you're interested in and share reports you've created. Subscribe to receive daily updates of reports shared in the Community.
New to Lansweeper?
Try Lansweeper For Free
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now
Related Content
- Disable monitor extended display scanning in General Discussions
- Lansweeper Linux SSH scan doesn't scan all software - Sophos antivirus in General Discussions
- Does Helpdesk require a separate license? in Open Office Hours Q&A
- When should you setup secondary scan servers? in Open Office Hours Q&A
- Lansweeper Cloud Software Not Installed Report in Reports & Analytics
