Intel June 2021 Platform Update Vulnerabilities Audit

Find Intel Software with Vulnerabilities

Intel released a June 2021 platform update which includes a bunch of advisories regarding vulnerabilities in their products. Not only their processors, but also software utilities they provide. To help you identify if you have software utilities in your environment the report below will indicate if you have any of the software included in the following Intel advisories:

  • WiFi Driver (sa-00472)
  • VTune Profiler (sa-00518)
  • Processor Diagnostic Tool (sa-00458)
  • Driver and Support Assistant (sa-00510)
  • Unite Client (sa-00506)
  • Optane DC Persistent Memory (sa-00541)
  • SSD Data Center Tool (sa-00537)
  • Wireless Bluetooth (sa-00520)
  • Computing Improvement Program (sa-00530)
  • Intel NUC Firmware (sa-00511)

If you would like to read more about the Intel June 2021 Platform Update, you can head over to the Intel June 2021 Platform Update blog post.

 

Intel Processor Diagnostic Tool Vulnerability Query

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%')

Audit and Take Action in 3 Easy Steps

1. Download & Install Lansweeper

3. Run the Audit & Take Action

Download Lansweeper to Run this Audit