This website uses cookies. By clicking Accept, you consent to the use of cookies. Click Here to learn more about how we use cookies.
→ 🚀What's New? Join Us for the Fall Product Launch! Register Now !
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
a month ago
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
a month ago
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
3 weeks ago - last edited 3 weeks ago
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/
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
