Intel June 2021 Platform Update Vulnerabilities Audit

Select Distinct Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tsysAssetTypes.AssetTypename As AssetType,
tblAssets.Username,
tblAssets.Userdomain,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.IPAddress,
tsysIPLocations.IPLocation,
tblAssetCustom.Manufacturer,
tblAssetCustom.Model,
tsysOS.OSname As OS,
subquery1.[WiFi Driver (sa-00472)],
subquery2.[VTune Profiler (sa-00518)],
subquery3.[Processor Diagnostic Tool (sa-00458)],
subquery4.[Driver and Support Assistant (sa-00510)],
subquery5.[Unite Client (sa-00506)],
subquery6.[Optane DC Persistent Memory (sa-00541)],
subquery7.[SSD Data Center Tool (sa-00537)],
subquery8.[Wireless Bluetooth (sa-00520)],
subquery9.[Computing Improvement Program (sa-00530)],
subquery10.[Intel NUC Firmware (sa-00511)],
subquery10.SMBIOSBIOSVersion As [BIOS Version],
subquery10.ReleaseDate [BIOS Release date],
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 subquery1.[WiFi Driver (sa-00472)] <> 'Safe' Then '#ffadad'
When subquery2.[VTune Profiler (sa-00518)] <> 'Safe' Then '#ffadad'
When subquery3.[Processor Diagnostic Tool (sa-00458)] <> 'Safe' Then
'#ffadad'
When subquery4.[Driver and Support Assistant (sa-00510)] <> 'Safe'
Then '#ffadad'
When subquery5.[Unite Client (sa-00506)] <> 'Safe' Then '#ffadad'
When subquery6.[Optane DC Persistent Memory (sa-00541)] <> 'Safe' Then
'#ffadad'
When subquery7.[SSD Data Center Tool (sa-00537)] <> 'Safe' Then '#ffadad'
When subquery8.[Wireless Bluetooth (sa-00520)] <> 'Safe' Then '#ffadad'
When subquery9.[Computing Improvement Program (sa-00530)] <> 'Safe' Then
'#ffadad'
When subquery10.[Intel NUC Firmware (sa-00511)] <> 'Safe' Then '#ffadad'
Else '#d4f4be'
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 tblSoftware On tblAssets.AssetID = tblSoftware.AssetID
Inner Join tblSoftwareUni On tblSoftwareUni.SoftID = tblSoftware.softID
Left Join tsysOS On tsysOS.OScode = tblAssets.OScode
Inner Join tblState On tblState.State = tblAssetCustom.State
Left Join (Select Distinct Top 1000000 tblAssets.AssetID,
tblNetworkAdapter.Name As NetworkAdapter,
tblNetworkAdapter.Manufacturer As AdapterManufacturer,
Case
When (tblNetworkAdapter.Name Like '%AX201%' Or
tblNetworkAdapter.Name Like '%AX200%' Or
tblNetworkAdapter.Name Like '%9560%' Or
tblNetworkAdapter.Name Like '%9462%' Or
tblNetworkAdapter.Name Like '%9461%') And
tblNetworkAdapter.Manufacturer Like '%Intel%' Then
'Potentially Vulnerable'
Else 'Safe'
End As [WiFi Driver (sa-00472)]
From tblAssets
Inner Join tblNetworkAdapter On
tblAssets.AssetID = tblNetworkAdapter.AssetID
Where Case tblNetworkAdapter.NetEnabled
When 0 Then 'No'
When 1 Then 'Yes'
End = 'Yes') As subquery1 On subquery1.AssetID = tblAssets.AssetID
Left Join (Select Top 1000000 tblAssets.AssetID,
Case
When tblSoftwareUni.softwareName Like '%VTune%Profiler%' And
Cast(ParseName(tblSoftware.softwareVersion, 3) As bigint) > 2021 Then
'Safe'
When tblSoftwareUni.softwareName Like '%VTune%Profiler%' And
Cast(ParseName(tblSoftware.softwareVersion, 3) As bigint) = 2021 And
Cast(ParseName(tblSoftware.softwareVersion, 2) As bigint) > 1 Then
'Safe'
When tblSoftwareUni.softwareName Like '%VTune%Profiler%' And
Cast(ParseName(tblSoftware.softwareVersion, 3) As bigint) = 2021 And
Cast(ParseName(tblSoftware.softwareVersion, 2) As bigint) = 1 And
Cast(ParseName(tblSoftware.softwareVersion, 1) As bigint) >= 1 Then
'Safe'
When tblSoftwareUni.softwareName Like '%VTune%Profiler%' Then
'Vulnerable'
End As [VTune Profiler (sa-00518)]
From tblAssets
Inner Join tblSoftware On tblAssets.AssetID = tblSoftware.AssetID
Inner Join tblSoftwareUni On tblSoftwareUni.SoftID = tblSoftware.softID
Where tblSoftwareUni.softwareName Like '%VTune%Profiler%') As subquery2 On
subquery2.AssetID = tblAssets.AssetID
Left Join (Select Top 1000000 tblAssets.AssetID,
Case
When
tblSoftwareUni.softwareName Like '%Intel Processor Diagnostic Tool%'
And Cast(ParseName(tblSoftware.softwareVersion, 3) As bigint) > 4 Then
'Safe'
When
tblSoftwareUni.softwareName Like '%Intel Processor Diagnostic Tool%'
And Cast(ParseName(tblSoftware.softwareVersion, 3) As bigint) = 4 And
Cast(ParseName(tblSoftware.softwareVersion, 2) As bigint) > 1 Then
'Safe'
When
tblSoftwareUni.softwareName Like '%Intel Processor Diagnostic Tool%'
And Cast(ParseName(tblSoftware.softwareVersion, 3) As bigint) = 4 And
Cast(ParseName(tblSoftware.softwareVersion, 2) As bigint) = 1 And
Cast(ParseName(tblSoftware.softwareVersion, 1) As bigint) >= 5 Then
'Safe'
When
tblSoftwareUni.softwareName Like '%Intel Processor Diagnostic Tool%'
Then 'Vulnerable'
End As [Processor Diagnostic Tool (sa-00458)]
From tblAssets
Inner Join tblSoftware On tblAssets.AssetID = tblSoftware.AssetID
Inner Join tblSoftwareUni On tblSoftwareUni.SoftID = tblSoftware.softID
Where tblSoftwareUni.softwareName Like '%Intel Processor Diagnostic Tool%')
As subquery3 On subquery3.AssetID = tblAssets.AssetID
Left Join (Select Top 1000000 tblAssets.AssetID,
Case
When tblSoftwareUni.softwareName Like '%Driver & Support Assistant%' And
Cast(ParseName(tblSoftware.softwareVersion, 4) As bigint) > 20 Then
'Safe'
When tblSoftwareUni.softwareName Like '%Driver & Support Assistant%' And
Cast(ParseName(tblSoftware.softwareVersion, 4) As bigint) = 20 And
Cast(ParseName(tblSoftware.softwareVersion, 3) As bigint) > 11 Then
'Safe'
When tblSoftwareUni.softwareName Like '%Driver & Support Assistant%' And
Cast(ParseName(tblSoftware.softwareVersion, 4) As bigint) = 20 And
Cast(ParseName(tblSoftware.softwareVersion, 3) As bigint) = 11 And
Cast(ParseName(tblSoftware.softwareVersion, 2) As bigint) > 50 Then
'Safe'
When tblSoftwareUni.softwareName Like '%Driver & Support Assistant%' And
Cast(ParseName(tblSoftware.softwareVersion, 4) As bigint) = 20 And
Cast(ParseName(tblSoftware.softwareVersion, 3) As bigint) = 11 And
Cast(ParseName(tblSoftware.softwareVersion, 2) As bigint) = 50 And
Cast(ParseName(tblSoftware.softwareVersion, 1) As bigint) >= 9 Then
'Safe'
When tblSoftwareUni.softwareName Like '%Driver & Support Assistant%'
Then 'Vulnerable'
End As [Driver and Support Assistant (sa-00510)]
From tblAssets
Inner Join tblSoftware On tblAssets.AssetID = tblSoftware.AssetID
Inner Join tblSoftwareUni On tblSoftwareUni.SoftID = tblSoftware.softID
Where tblSoftwareUni.softwareName Like '%Driver & Support Assistant%') As
subquery4 On subquery4.AssetID = tblAssets.AssetID
Left Join (Select Top 1000000 tblAssets.AssetID,
Case
When tblSoftwareUni.softwareName Like '%Intel Unite%Client%' And
Cast(ParseName(tblSoftware.softwareVersion, 4) As bigint) > 4 Then
'Safe'
When tblSoftwareUni.softwareName Like '%Intel Unite%Client%' And
Cast(ParseName(tblSoftware.softwareVersion, 4) As bigint) = 4 And
Cast(ParseName(tblSoftware.softwareVersion, 3) As bigint) > 2 Then
'Safe'
When tblSoftwareUni.softwareName Like '%Intel Unite%Client%' And
Cast(ParseName(tblSoftware.softwareVersion, 4) As bigint) = 4 And
Cast(ParseName(tblSoftware.softwareVersion, 3) As bigint) = 2 And
Cast(ParseName(tblSoftware.softwareVersion, 2) As bigint) >= 25031
Then 'Safe'
When tblSoftwareUni.softwareName Like '%Intel Unite%Client%' Then
'Vulnerable'
End As [Unite Client (sa-00506)]
From tblAssets
Inner Join tblSoftware On tblAssets.AssetID = tblSoftware.AssetID
Inner Join tblSoftwareUni On tblSoftwareUni.SoftID = tblSoftware.softID
Where tblSoftwareUni.softwareName Like '%Intel Unite%Client%') As subquery5
On subquery5.AssetID = tblAssets.AssetID
Left Join (Select Top 1000000 tblAssets.AssetID,
Case
When tblSoftwareUni.softwareName Like '%PMem Software%' And
Cast(ParseName(tblSoftware.softwareVersion, 4) As bigint) > 2 Then
'Safe'
When tblSoftwareUni.softwareName Like '%DCPM Software%' And
Cast(ParseName(tblSoftware.softwareVersion, 4) As bigint) = 1 And
Cast(ParseName(tblSoftware.softwareVersion, 3) As bigint) > 0 Then
'Safe'
When tblSoftwareUni.softwareName Like '%DCPM Software%' And
Cast(ParseName(tblSoftware.softwareVersion, 4) As bigint) = 1 And
Cast(ParseName(tblSoftware.softwareVersion, 3) As bigint) = 0 And
Cast(ParseName(tblSoftware.softwareVersion, 2) As bigint) > 0 Then
'Safe'
When tblSoftwareUni.softwareName Like '%DCPM Software%' And
Cast(ParseName(tblSoftware.softwareVersion, 4) As bigint) = 1 And
Cast(ParseName(tblSoftware.softwareVersion, 3) As bigint) = 0 And
Cast(ParseName(tblSoftware.softwareVersion, 2) As bigint) = 0 And
Cast(ParseName(tblSoftware.softwareVersion, 1) As bigint) >= 3515 Then
'Safe'
When tblSoftwareUni.softwareName Like '%PMem Software%' And
Cast(ParseName(tblSoftware.softwareVersion, 4) As bigint) = 2 And
Cast(ParseName(tblSoftware.softwareVersion, 3) As bigint) > 0 Then
'Safe'
When tblSoftwareUni.softwareName Like '%PMem Software%' And
Cast(ParseName(tblSoftware.softwareVersion, 4) As bigint) = 2 And
Cast(ParseName(tblSoftware.softwareVersion, 3) As bigint) = 0 And
Cast(ParseName(tblSoftware.softwareVersion, 2) As bigint) > 0 Then
'Safe'
When tblSoftwareUni.softwareName Like '%PMem Software%' And
Cast(ParseName(tblSoftware.softwareVersion, 4) As bigint) = 2 And
Cast(ParseName(tblSoftware.softwareVersion, 3) As bigint) = 0 And
Cast(ParseName(tblSoftware.softwareVersion, 2) As bigint) = 0 And
Cast(ParseName(tblSoftware.softwareVersion, 1) As bigint) >= 3842 Then
'Safe'
When tblSoftwareUni.softwareName Like '%PMem Software%' Then
'Vulnerable'
When tblSoftwareUni.softwareName Like '%DCPM Software%' Then
'Vulnerable'
End As [Optane DC Persistent Memory (sa-00541)]
From tblAssets
Inner Join tblSoftware On tblAssets.AssetID = tblSoftware.AssetID
Inner Join tblSoftwareUni On tblSoftwareUni.SoftID = tblSoftware.softID
Where (tblSoftwareUni.softwareName Like '%DCPM Software%' Or
tblSoftwareUni.softwareName Like '%PMem Software%')) As subquery6 On
subquery6.AssetID = tblAssets.AssetID
Left Join (Select Top 1000000 tblAssets.AssetID,
Case
When tblSoftwareUni.softwareName Like '%SSD Data Center Tool%'
Then 'Vulnerable, Replace with Memory and Storage Tool (MAS)'
End As [SSD Data Center Tool (sa-00537)]
From tblAssets
Inner Join tblSoftware On tblAssets.AssetID = tblSoftware.AssetID
Inner Join tblSoftwareUni On tblSoftwareUni.SoftID = tblSoftware.softID
Where tblSoftwareUni.softwareName Like '%SSD Data Center Tool%') As
subquery7 On subquery7.AssetID = tblAssets.AssetID
Left Join (Select Distinct Top 1000000 tblAssets.AssetID,
tblNetworkAdapter.Name As NetworkAdapter,
tblNetworkAdapter.Manufacturer As AdapterManufacturer,
Case
When (tblNetworkAdapter.Name Like '%AX210%' Or
tblNetworkAdapter.Name Like '%AX201%' Or
tblNetworkAdapter.Name Like '%AX200%' Or
tblNetworkAdapter.Name Like '%9560%' Or
tblNetworkAdapter.Name Like '%9462%' Or
tblNetworkAdapter.Name Like '%9461%' Or
tblNetworkAdapter.Name Like '%9260%' Or
tblNetworkAdapter.Name Like '%8265%' Or
tblNetworkAdapter.Name Like '%8260%' Or
tblNetworkAdapter.Name Like '%3168%' Or
tblNetworkAdapter.Name Like '%7265%' Or
tblNetworkAdapter.Name Like '%3165%') And
tblNetworkAdapter.Manufacturer Like '%Intel%' Then
'Potentially Vulnerable'
When (tblNetworkAdapter.Name Like '%AX1675%' Or
tblNetworkAdapter.Name Like '%AX1650%' Or
tblNetworkAdapter.Name Like '%1550%') And
tblNetworkAdapter.Name Like '%Killer%' Then 'Potentially Vulnerable'
Else 'Safe'
End As [Wireless Bluetooth (sa-00520)]
From tblAssets
Inner Join tblNetworkAdapter On
tblAssets.AssetID = tblNetworkAdapter.AssetID
Where Case tblNetworkAdapter.NetEnabled
When 0 Then 'No'
When 1 Then 'Yes'
End = 'Yes') As subquery8 On subquery8.AssetID = tblAssets.AssetID
Left Join (Select Top 1000000 tblAssets.AssetID,
Case
When tblSoftwareUni.softwareName Like '%Computing Improvement Program%'
And Cast(ParseName(tblSoftware.softwareVersion, 3) As bigint) > 2 Then
'Safe'
When tblSoftwareUni.softwareName Like '%Computing Improvement Program%'
And Cast(ParseName(tblSoftware.softwareVersion, 3) As bigint) = 2 And
Cast(ParseName(tblSoftware.softwareVersion, 2) As bigint) > 4 Then
'Safe'
When tblSoftwareUni.softwareName Like '%Computing Improvement Program%'
And Cast(ParseName(tblSoftware.softwareVersion, 3) As bigint) = 2 And
Cast(ParseName(tblSoftware.softwareVersion, 2) As bigint) = 4 And
Cast(ParseName(tblSoftware.softwareVersion, 1) As bigint) >= 6522 Then
'Safe'
When tblSoftwareUni.softwareName Like '%Computing Improvement Program%'
Then 'Vulnerable'
End As [Computing Improvement Program (sa-00530)]
From tblAssets
Inner Join tblSoftware On tblAssets.AssetID = tblSoftware.AssetID
Inner Join tblSoftwareUni On tblSoftwareUni.SoftID = tblSoftware.softID
Where tblSoftwareUni.softwareName Like '%Computing Improvement Program%') As
subquery9 On subquery9.AssetID = tblAssets.AssetID
Left Join (Select Top 1000000 tblAssets.AssetID,
Case
When tblAssetCustom.Model Like '%LAPBC510%' Or
tblAssetCustom.Model Like '%LAPBC710%' Or
tblAssetCustom.Model Like '%CM11EBC4W%' Or
tblAssetCustom.Model Like '%CM11EBi38W%' Or
tblAssetCustom.Model Like '%CM11EBi58W%' Or
tblAssetCustom.Model Like '%CM11EBi716W%' Or
tblAssetCustom.Model Like '%NUC11PAHi3%' Or
tblAssetCustom.Model Like '%NUC11PAHi5%' Or
tblAssetCustom.Model Like '%NUC11PAHi7%' Or
tblAssetCustom.Model Like '%NUC11PAKi3%' Or
tblAssetCustom.Model Like '%NUC11PAKi5%' Or
tblAssetCustom.Model Like '%NUC11PAKi7%' Or
tblAssetCustom.Model Like '%NUC11PAQi50WA%' Or
tblAssetCustom.Model Like '%NUC11PAQi70QA%' Or
tblAssetCustom.Model Like '%NUC11TNBi3%' Or
tblAssetCustom.Model Like '%NUC11TNBi5%' Or
tblAssetCustom.Model Like '%NUC11TNBi7%' Or
tblAssetCustom.Model Like '%NUC11TNHi3%' Or
tblAssetCustom.Model Like '%NUC11TNHi30L%' Or
tblAssetCustom.Model Like '%NUC11TNHi30P%' Or
tblAssetCustom.Model Like '%NUC11TNHi5%' Or
tblAssetCustom.Model Like '%NUC11TNHi50L%' Or
tblAssetCustom.Model Like '%NUC11TNHi50W%' Or
tblAssetCustom.Model Like '%NUC11TNHi7%' Or
tblAssetCustom.Model Like '%NUC11TNHi70L%' Or
tblAssetCustom.Model Like '%NUC11TNHi70Q%' Or
tblAssetCustom.Model Like '%NUC11TNKi3%' Or
tblAssetCustom.Model Like '%NUC11TNKi5%' Or
tblAssetCustom.Model Like '%NUC11TNKi7%' Or
tblAssetCustom.Model Like '%NUC11PHKi7C%' Or
tblAssetCustom.Model Like '%NUC11PHKi7CAA%' Or
tblAssetCustom.Model Like '%NUC10i3FNH%' Or
tblAssetCustom.Model Like '%NUC10i3FNHF%' Or
tblAssetCustom.Model Like '%NUC10i3FNK%' Or
tblAssetCustom.Model Like '%NUC10i5FNH%' Or
tblAssetCustom.Model Like '%NUC10i5FNHF%' Or
tblAssetCustom.Model Like '%NUC10i5FNHJ%' Or
tblAssetCustom.Model Like '%NUC10i5FNK%' Or
tblAssetCustom.Model Like '%NUC10i5FNKP%' Or
tblAssetCustom.Model Like '%NUC10i7FNH%' Or
tblAssetCustom.Model Like '%NUC10i7FNHC%' Or
tblAssetCustom.Model Like '%NUC10i7FNK%' Or
tblAssetCustom.Model Like '%NUC10i7FNKP%' Or
tblAssetCustom.Model Like '%NUC10i3FNHFA%' Or
tblAssetCustom.Model Like '%NUC10i3FNHJA%' Or
tblAssetCustom.Model Like '%NUC10i5FNHCA%' Or
tblAssetCustom.Model Like '%NUC10i5FNHJA%' Or
tblAssetCustom.Model Like '%NUC10i5FNKPA%' Or
tblAssetCustom.Model Like '%NUC10i7FNHAA%' Or
tblAssetCustom.Model Like '%NUC10i7FNHJA%' Or
tblAssetCustom.Model Like '%NUC10i7FNKPA%' Or
tblAssetCustom.Model Like '%NUC9V7QNB%' Or
tblAssetCustom.Model Like '%NUC9VXQNB%' Or
tblAssetCustom.Model Like '%NUC9V7QNX%' Or
tblAssetCustom.Model Like '%NUC9VXQNX%' Or
tblAssetCustom.Model Like '%NUC8i7HNKQC%' Or
tblAssetCustom.Model Like '%NUC8i7HVKVA%' Or
tblAssetCustom.Model Like '%NUC8i7HVKVAW%' Or
tblAssetCustom.Model Like '%NUC8i7HNK%' Or
tblAssetCustom.Model Like '%NUC8i7HVK%' Or
tblAssetCustom.Model Like '%NUC8CCHKR%' Or
tblAssetCustom.Model Like '%NUC8CCHB%' Or
tblAssetCustom.Model Like '%CM8CCB%' Or
tblAssetCustom.Model Like '%CM8i3CB%' Or
tblAssetCustom.Model Like '%CM8i5CB%' Or
tblAssetCustom.Model Like '%CM8i7CB%' Or
tblAssetCustom.Model Like '%CM8PCB%' Or
tblAssetCustom.Model Like '%NUC8i3PNB%' Or
tblAssetCustom.Model Like '%NUC8i3PNH%' Or
tblAssetCustom.Model Like '%NUC8i3PNK%' Or
tblAssetCustom.Model Like '%NUC8i5INH%' Or
tblAssetCustom.Model Like '%NUC8i7INH%' Or
tblAssetCustom.Model Like '%NUC8i5INH%' Or
tblAssetCustom.Model Like '%NUC8i7INH%' Or
tblAssetCustom.Model Like '%NUC7CJYSAL%' Or
tblAssetCustom.Model Like '%NUC7CJYH%' Or
tblAssetCustom.Model Like '%NUC7PJYH%' Then 'Potentailly Vulnerable'
Else 'Safe'
End As [Intel NUC Firmware (sa-00511)],
tblBIOS.SMBIOSBIOSVersion,
tblBIOS.ReleaseDate
From tblAssets
Inner Join tblAssetCustom On tblAssetCustom.AssetID = tblAssets.AssetID
Inner Join tblBIOS On tblBIOS.AssetID = tblAssets.AssetID) As subquery10
On subquery10.AssetID = tblAssets.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
Where tsysAssetTypes.AssetTypename = 'Windows' And tblState.Statename = 'Active'
And (tblSoftwareUni.softwareName Like '%VTune%Profiler%' Or
tblSoftwareUni.softwareName Like '%Intel Processor Diagnostic Tool%' Or
tblSoftwareUni.softwareName Like '%Driver & Support Assistant%' Or
tblSoftwareUni.softwareName Like '%Intel Unite%Client%' Or
tblSoftwareUni.softwareName Like '%DCPM Software%' Or
tblSoftwareUni.softwareName Like '%PMem Software%' Or
tblSoftwareUni.softwareName Like '%SSD Data Center Tool%' Or
tblSoftwareUni.softwareName Like '%Computing Improvement Program%'
Or tblAssetCustom.Model Like '%LAPBC510%' Or tblAssetCustom.Model Like
'%LAPBC710%' Or tblAssetCustom.Model Like '%CM11EBC4W%' Or
tblAssetCustom.Model Like '%CM11EBi38W%' Or tblAssetCustom.Model Like
'%CM11EBi58W%' Or tblAssetCustom.Model Like '%CM11EBi716W%' Or
tblAssetCustom.Model Like '%NUC11PAHi3%' Or tblAssetCustom.Model Like
'%NUC11PAHi5%' Or tblAssetCustom.Model Like '%NUC11PAHi7%' Or
tblAssetCustom.Model Like '%NUC11PAKi3%' Or tblAssetCustom.Model Like
'%NUC11PAKi5%' Or tblAssetCustom.Model Like '%NUC11PAKi7%' Or
tblAssetCustom.Model Like '%NUC11PAQi50WA%' Or
tblAssetCustom.Model Like '%NUC11PAQi70QA%' Or
tblAssetCustom.Model Like '%NUC11TNBi3%' Or tblAssetCustom.Model Like
'%NUC11TNBi5%' Or tblAssetCustom.Model Like '%NUC11TNBi7%' Or
tblAssetCustom.Model Like '%NUC11TNHi3%' Or tblAssetCustom.Model Like
'%NUC11TNHi30L%' Or tblAssetCustom.Model Like '%NUC11TNHi30P%' Or
tblAssetCustom.Model Like '%NUC11TNHi5%' Or tblAssetCustom.Model Like
'%NUC11TNHi50L%' Or tblAssetCustom.Model Like '%NUC11TNHi50W%' Or
tblAssetCustom.Model Like '%NUC11TNHi7%' Or tblAssetCustom.Model Like
'%NUC11TNHi70L%' Or tblAssetCustom.Model Like '%NUC11TNHi70Q%' Or
tblAssetCustom.Model Like '%NUC11TNKi3%' Or tblAssetCustom.Model Like
'%NUC11TNKi5%' Or tblAssetCustom.Model Like '%NUC11TNKi7%' Or
tblAssetCustom.Model Like '%NUC11PHKi7C%' Or tblAssetCustom.Model Like
'%NUC11PHKi7CAA%' Or tblAssetCustom.Model Like '%NUC10i3FNH%' Or
tblAssetCustom.Model Like '%NUC10i3FNHF%' Or tblAssetCustom.Model Like
'%NUC10i3FNK%' Or tblAssetCustom.Model Like '%NUC10i5FNH%' Or
tblAssetCustom.Model Like '%NUC10i5FNHF%' Or tblAssetCustom.Model Like
'%NUC10i5FNHJ%' Or tblAssetCustom.Model Like '%NUC10i5FNK%' Or
tblAssetCustom.Model Like '%NUC10i5FNKP%' Or tblAssetCustom.Model Like
'%NUC10i7FNH%' Or tblAssetCustom.Model Like '%NUC10i7FNHC%' Or
tblAssetCustom.Model Like '%NUC10i7FNK%' Or tblAssetCustom.Model Like
'%NUC10i7FNKP%' Or tblAssetCustom.Model Like '%NUC10i3FNHFA%' Or
tblAssetCustom.Model Like '%NUC10i3FNHJA%' Or tblAssetCustom.Model
Like '%NUC10i5FNHCA%' Or tblAssetCustom.Model Like '%NUC10i5FNHJA%' Or
tblAssetCustom.Model Like '%NUC10i5FNKPA%' Or tblAssetCustom.Model
Like '%NUC10i7FNHAA%' Or tblAssetCustom.Model Like '%NUC10i7FNHJA%' Or
tblAssetCustom.Model Like '%NUC10i7FNKPA%' Or tblAssetCustom.Model
Like '%NUC9V7QNB%' Or tblAssetCustom.Model Like '%NUC9VXQNB%' Or
tblAssetCustom.Model Like '%NUC9V7QNX%' Or tblAssetCustom.Model Like
'%NUC9VXQNX%' Or tblAssetCustom.Model Like '%NUC8i7HNKQC%' Or
tblAssetCustom.Model Like '%NUC8i7HVKVA%' Or tblAssetCustom.Model Like
'%NUC8i7HVKVAW%' Or tblAssetCustom.Model Like '%NUC8i7HNK%' Or
tblAssetCustom.Model Like '%NUC8i7HVK%' Or tblAssetCustom.Model Like
'%NUC8CCHKR%' Or tblAssetCustom.Model Like '%NUC8CCHB%' Or
tblAssetCustom.Model Like '%CM8CCB%' Or tblAssetCustom.Model Like
'%CM8i3CB%' Or tblAssetCustom.Model Like '%CM8i5CB%' Or
tblAssetCustom.Model Like '%CM8i7CB%' Or tblAssetCustom.Model Like
'%CM8PCB%' Or tblAssetCustom.Model Like '%NUC8i3PNB%' Or
tblAssetCustom.Model Like '%NUC8i3PNH%' Or tblAssetCustom.Model Like
'%NUC8i3PNK%' Or tblAssetCustom.Model Like '%NUC8i5INH%' Or
tblAssetCustom.Model Like '%NUC8i7INH%' Or tblAssetCustom.Model Like
'%NUC8i5INH%' Or tblAssetCustom.Model Like '%NUC8i7INH%' Or
tblAssetCustom.Model Like '%NUC7CJYSAL%' Or tblAssetCustom.Model Like
'%NUC7CJYH%' Or tblAssetCustom.Model Like '%NUC7PJYH%')