INTEL-SA-00233 "Zombieload/RIDL/Fallout"

[Esben_D]

Intel, along with all major operating system manufactures released security advisories regarding the Zombieload, RIDL and Fallout vulnerabilities or CVE-2018-12126, CVE-2018-12127, CVE-2018-12130. You find out more about it in our blog post.

The report below will show all assets which will receive a microcode update according to Intel's microcode update guidance. Instructions to run this report can be found here: https://www.lansweeper.com/forum/yaf_postst9882_How-to-run-a-report.aspx

Select Top 1000000 tblAssets.AssetID,
  tblAssets.AssetName,
  tblAssets.Domain,
  tblAssets.Username,
  tblAssets.Userdomain,
  Coalesce(tsysOS.Image, tsysAssetTypes.AssetTypeIcon10) As icon,
  tblAssets.IPAddress,
  tblProcessor.Name As CPU,
  tsysIPLocations.IPLocation,
  tblAssetCustom.Manufacturer,
  tblAssetCustom.Model,
  tsysOS.OSname As OS,
  tblAssets.SP,
  tblAssets.Lastseen,
  tblAssets.Lasttried
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
  Left Join tsysOS On tsysOS.OScode = tblAssets.OScode
  Inner Join tblProcessor On tblAssets.AssetID = tblProcessor.AssetID
Where (tblProcessor.Name Like '%8___Y%' Or tblProcessor.Name Like '%Pentium%J4%'
    Or tblProcessor.Name Like '%Pentium%N4%' Or tblProcessor.Name Like
    '%Pentium%J5%' Or tblProcessor.Name Like '%Pentium%N5%' Or
    tblProcessor.Name Like '%Celeron%J3%' Or
    tblProcessor.Name Like '%Celeron%N3%' Or
    tblProcessor.Name Like '%Celeron%J4%' Or
    tblProcessor.Name Like '%Celeron%N4%' Or tblProcessor.Name Like '%Atom%A3%'
    Or tblProcessor.Name Like '%Atom%E3%' Or tblProcessor.Name Like '%Atom%C2%'
    Or tblProcessor.Name Like '%Atom%C3%' Or tblProcessor.Name Like '%Xeon%D%'
    Or tblProcessor.Name Like '%i7-6%' Or tblProcessor.Name Like '%i5-5%' Or
    tblProcessor.Name Like '%i7-5%' Or tblProcessor.Name Like '%Xeon%E5%v4%' Or
    tblProcessor.Name Like '%Xeon%E7%v4%' Or tblProcessor.Name Like '%i3-5%' Or
    tblProcessor.Name Like '%pentium%3___U%' Or tblProcessor.Name Like
    '%Celeron%3___U%' Or tblProcessor.Name Like '%Xeon%e3%v4%' Or
    tblProcessor.Name Like '%M-5Y%' Or tblProcessor.Name Like '%Atom%z8%' Or
    tblProcessor.Name Like '%i9-8%' Or tblProcessor.Name Like '%i7-8%'
    Or tblProcessor.Name Like '%i5-8%' Or tblProcessor.Name Like '%i3-8%' Or
    tblProcessor.Name Like '%i9-9%' Or tblProcessor.Name Like '%i7-9%'
    Or tblProcessor.Name Like '%i5-9%' Or tblProcessor.Name Like '%Xeon%E-2%' Or
    tblProcessor.Name Like '%Pentium%G5%' Or
    tblProcessor.Name Like '%Celeron%G4%' Or tblProcessor.Name Like '%i3-2%' Or
    tblProcessor.Name Like '%i3-3%' Or tblProcessor.Name Like '%pentium%b9%' Or
    tblProcessor.Name Like '%celeron%725c%' Or tblProcessor.Name Like
    '%xeon%E3-1%' Or tblProcessor.Name Like '%i7-4%' Or
    tblProcessor.Name Like '%i5-4%' Or tblProcessor.Name Like '%i3-4%'
    Or tblProcessor.Name Like '%Pentium%g3%' Or tblProcessor.Name Like
    '%Pentium%3560M%' Or tblProcessor.Name Like '%celeron%2970M%' Or
    tblProcessor.Name Like '%Xeon%e5%v3%' Or
    tblProcessor.Name Like '%Xeon%e7%v3%' Or
    tblProcessor.Name Like '%Pentium%3___U%' Or tblProcessor.Name Like
    '%celeron%2___U%' Or tblProcessor.Name Like '%Pentium%3___Y%' Or
    tblProcessor.Name Like '%i7-3%' Or tblProcessor.Name Like '%i5-3%'
    Or tblProcessor.Name Like '%i3-3%' Or
    tblProcessor.Name Like '%pentium%14%v2%' Or tblProcessor.Name Like
    '%pentium%g2%' Or tblProcessor.Name Like '%pentium%2___M' Or
    tblProcessor.Name Like '%pentium%2___U' Or tblProcessor.Name Like
    '%pentium%2___Y' Or tblProcessor.Name Like '%Xeon%v2%e5%' Or
    tblProcessor.Name Like '%Xeon%e7%v2%' Or
    tblProcessor.Name Like '%Xeon%e3%v2%' Or tblProcessor.Name Like '%i7-7%' Or
    tblProcessor.Name Like '%i9-7%' Or tblProcessor.Name Like '%i5-7%'
    Or tblProcessor.Name Like '%i3-7%' Or tblProcessor.Name Like '%celeron%g3%'
    Or tblProcessor.Name Like '%celeron%3___U' Or
    tblProcessor.Name Like '%pentium%4___U' Or tblProcessor.Name Like
    '%Xeon%e3%v6%' Or tblProcessor.Name Like '%m3-7%' Or
    tblProcessor.Name Like '%pentium%4___Y' Or tblProcessor.Name Like
    '%celeron%3___Y' Or tblProcessor.Name Like '%i7-2%' Or
    tblProcessor.Name Like '%i5-2%' Or tblProcessor.Name Like '%i3-2%'
    Or tblProcessor.Name Like '%pentium%9__' Or tblProcessor.Name Like
    '%pentium%b9__' Or tblProcessor.Name Like '%pentium%g6__' Or
    tblProcessor.Name Like '%pentium%g8__' Or
    tblProcessor.Name Like '%celeron%b8__' Or
    tblProcessor.Name Like '%celeron%g4__' Or
    tblProcessor.Name Like '%celeron%g5__' Or
    tblProcessor.Name Like '%celeron%7__' Or
    tblProcessor.Name Like '%celeron%8__%' Or
    tblProcessor.Name Like '%Xeon%E5-2%' Or tblProcessor.Name Like '%Xeon%E5-1%'
    Or tblProcessor.Name Like '%Xeon%E5-4%' Or tblProcessor.Name Like
    '%Xeon%E3-2%' Or tblProcessor.Name Like '%Xeon%D-%' Or
    tblProcessor.Name Like '%i7-6%' Or tblProcessor.Name Like '%i5-6%'
    Or tblProcessor.Name Like '%i3-6%' Or
    tblProcessor.Name Like '%pentium%1405%' Or tblProcessor.Name Like
    '%pentium%G4%' Or tblProcessor.Name Like '%xeon%platinum%8___%' Or
    tblProcessor.Name Like '%xeon%gold%5___%' Or
    tblProcessor.Name Like '%xeon%gold%6___%' Or
    tblProcessor.Name Like '%xeon%silver%4___%' Or
    tblProcessor.Name Like '%xeon%bronze%3___%' Or
    tblProcessor.Name Like '%Xeon%W-2%' Or tblProcessor.Name Like '%Xeon%v5%e3%'
    Or tblProcessor.Name Like '%m7-6%' Or tblProcessor.Name Like '%m5-6%' Or
    tblProcessor.Name Like '%m3-6%' Or tblProcessor.Name Like '%Atom%Z%' Or
    tblProcessor.Name Like '%pentium%j2%' Or
    tblProcessor.Name Like '%pentium%n3%' Or
    tblProcessor.Name Like '%celeron%j1%' Or
    tblProcessor.Name Like '%celeron%n2%' Or
    tblProcessor.Name Like '%pentium%n3%' Or tblProcessor.Name Like '%4205U%' Or
    tblProcessor.Name Like '%5405U%') And tblState.Statename = 'Active' And
  tblProcessor.Manufacturer Like '%Intel%'
Union
Select Top 1000000 tblAssets.AssetID,
  tblAssets.AssetName,
  tblAssets.Domain,
  tblAssets.Username,
  tblAssets.Userdomain,
  Coalesce(tsysOS.Image, tsysAssetTypes.AssetTypeIcon10) As icon,
  tblAssets.IPAddress,
  tblMacHwOverview.CPUtype As CPU,
  tsysIPLocations.IPLocation,
  tblAssetCustom.Manufacturer,
  tblAssetCustom.Model,
  tblMacOSInfo.SystemVersion As OS,
  tblAssets.SP,
  tblAssets.Lastseen,
  tblAssets.Lasttried
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
  Left Join tsysOS On tsysOS.OScode = tblAssets.OScode
  Inner Join tblMacHwOverview On tblAssets.AssetID = tblMacHwOverview.AssetID
  Inner join tblMacOSInfo on tblassets.assetid = tblMacOSInfo.AssetID
Where (tblMacHwOverview.CPUtype Like '%8___Y%' Or tblMacHwOverview.CPUtype Like
    '%Pentium%J4%' Or tblMacHwOverview.CPUtype Like '%Pentium%N4%' Or
    tblMacHwOverview.CPUtype Like '%Pentium%J5%' Or
    tblMacHwOverview.CPUtype Like '%Pentium%N5%' Or
    tblMacHwOverview.CPUtype Like '%Celeron%J3%' Or
    tblMacHwOverview.CPUtype Like '%Celeron%N3%' Or
    tblMacHwOverview.CPUtype Like '%Celeron%J4%' Or
    tblMacHwOverview.CPUtype Like '%Celeron%N4%' Or
    tblMacHwOverview.CPUtype Like '%Atom%A3%' Or tblMacHwOverview.CPUtype Like
    '%Atom%E3%' Or tblMacHwOverview.CPUtype Like '%Atom%C2%' Or
    tblMacHwOverview.CPUtype Like '%Atom%C3%' Or tblMacHwOverview.CPUtype Like
    '%Xeon%D%' Or tblMacHwOverview.CPUtype Like '%i7-6%' Or
    tblMacHwOverview.CPUtype Like '%i5-5%' Or tblMacHwOverview.CPUtype
    Like '%i7-5%' Or tblMacHwOverview.CPUtype Like '%Xeon%E5%v4%' Or
    tblMacHwOverview.CPUtype Like '%Xeon%E7%v4%' Or
    tblMacHwOverview.CPUtype Like '%i3-5%' Or tblMacHwOverview.CPUtype
    Like '%pentium%3___U%' Or tblMacHwOverview.CPUtype Like '%Celeron%3___U%' Or
    tblMacHwOverview.CPUtype Like '%Xeon%e3%v4%' Or
    tblMacHwOverview.CPUtype Like '%M-5Y%' Or tblMacHwOverview.CPUtype
    Like '%Atom%z8%' Or tblMacHwOverview.CPUtype Like '%i9-8%' Or
    tblMacHwOverview.CPUtype Like '%i7-8%' Or tblMacHwOverview.CPUtype
    Like '%i5-8%' Or tblMacHwOverview.CPUtype Like '%i3-8%' Or
    tblMacHwOverview.CPUtype Like '%i9-9%' Or tblMacHwOverview.CPUtype
    Like '%i7-9%' Or tblMacHwOverview.CPUtype Like '%i5-9%' Or
    tblMacHwOverview.CPUtype Like '%Xeon%E-2%' Or tblMacHwOverview.CPUtype Like
    '%Pentium%G5%' Or tblMacHwOverview.CPUtype Like '%Celeron%G4%' Or
    tblMacHwOverview.CPUtype Like '%i3-2%' Or tblMacHwOverview.CPUtype
    Like '%i3-3%' Or tblMacHwOverview.CPUtype Like '%pentium%b9%' Or
    tblMacHwOverview.CPUtype Like '%celeron%725c%' Or
    tblMacHwOverview.CPUtype Like '%xeon%E3-1%' Or tblMacHwOverview.CPUtype Like
    '%i7-4%' Or tblMacHwOverview.CPUtype Like '%i5-4%' Or
    tblMacHwOverview.CPUtype Like '%i3-4%' Or tblMacHwOverview.CPUtype
    Like '%Pentium%g3%' Or tblMacHwOverview.CPUtype Like '%Pentium%3560M%' Or
    tblMacHwOverview.CPUtype Like '%celeron%2970M%' Or
    tblMacHwOverview.CPUtype Like '%Xeon%e5%v3%' Or
    tblMacHwOverview.CPUtype Like '%Xeon%e7%v3%' Or
    tblMacHwOverview.CPUtype Like '%Pentium%3___U%' Or
    tblMacHwOverview.CPUtype Like '%celeron%2___U%' Or
    tblMacHwOverview.CPUtype Like '%Pentium%3___Y%' Or
    tblMacHwOverview.CPUtype Like '%i7-3%' Or tblMacHwOverview.CPUtype
    Like '%i5-3%' Or tblMacHwOverview.CPUtype Like '%i3-3%' Or
    tblMacHwOverview.CPUtype Like '%pentium%14%v2%' Or
    tblMacHwOverview.CPUtype Like '%pentium%g2%' Or
    tblMacHwOverview.CPUtype Like '%pentium%2___M' Or
    tblMacHwOverview.CPUtype Like '%pentium%2___U' Or
    tblMacHwOverview.CPUtype Like '%pentium%2___Y' Or
    tblMacHwOverview.CPUtype Like '%Xeon%v2%e5%' Or
    tblMacHwOverview.CPUtype Like '%Xeon%e7%v2%' Or
    tblMacHwOverview.CPUtype Like '%Xeon%e3%v2%' Or
    tblMacHwOverview.CPUtype Like '%i7-7%' Or tblMacHwOverview.CPUtype
    Like '%i9-7%' Or tblMacHwOverview.CPUtype Like '%i5-7%' Or
    tblMacHwOverview.CPUtype Like '%i3-7%' Or tblMacHwOverview.CPUtype
    Like '%celeron%g3%' Or tblMacHwOverview.CPUtype Like '%celeron%3___U' Or
    tblMacHwOverview.CPUtype Like '%pentium%4___U' Or
    tblMacHwOverview.CPUtype Like '%Xeon%e3%v6%' Or
    tblMacHwOverview.CPUtype Like '%m3-7%' Or tblMacHwOverview.CPUtype
    Like '%pentium%4___Y' Or tblMacHwOverview.CPUtype Like '%celeron%3___Y' Or
    tblMacHwOverview.CPUtype Like '%i7-2%' Or tblMacHwOverview.CPUtype
    Like '%i5-2%' Or tblMacHwOverview.CPUtype Like '%i3-2%' Or
    tblMacHwOverview.CPUtype Like '%pentium%9__' Or
    tblMacHwOverview.CPUtype Like '%pentium%b9__' Or
    tblMacHwOverview.CPUtype Like '%pentium%g6__' Or
    tblMacHwOverview.CPUtype Like '%pentium%g8__' Or
    tblMacHwOverview.CPUtype Like '%celeron%b8__' Or
    tblMacHwOverview.CPUtype Like '%celeron%g4__' Or
    tblMacHwOverview.CPUtype Like '%celeron%g5__' Or
    tblMacHwOverview.CPUtype Like '%celeron%7__' Or
    tblMacHwOverview.CPUtype Like '%celeron%8__%' Or
    tblMacHwOverview.CPUtype Like '%Xeon%E5-2%' Or tblMacHwOverview.CPUtype Like
    '%Xeon%E5-1%' Or tblMacHwOverview.CPUtype Like '%Xeon%E5-4%' Or
    tblMacHwOverview.CPUtype Like '%Xeon%E3-2%' Or tblMacHwOverview.CPUtype Like
    '%Xeon%D-%' Or tblMacHwOverview.CPUtype Like '%i7-6%' Or
    tblMacHwOverview.CPUtype Like '%i5-6%' Or tblMacHwOverview.CPUtype
    Like '%i3-6%' Or tblMacHwOverview.CPUtype Like '%pentium%1405%' Or
    tblMacHwOverview.CPUtype Like '%pentium%G4%' Or
    tblMacHwOverview.CPUtype Like '%xeon%platinum%8___%' Or
    tblMacHwOverview.CPUtype Like '%xeon%gold%5___%' Or
    tblMacHwOverview.CPUtype Like '%xeon%gold%6___%' Or
    tblMacHwOverview.CPUtype Like '%xeon%silver%4___%' Or
    tblMacHwOverview.CPUtype Like '%xeon%bronze%3___%' Or
    tblMacHwOverview.CPUtype Like '%Xeon%W-2%' Or tblMacHwOverview.CPUtype Like
    '%Xeon%v5%e3%' Or tblMacHwOverview.CPUtype Like '%m7-6%' Or
    tblMacHwOverview.CPUtype Like '%m5-6%' Or tblMacHwOverview.CPUtype
    Like '%m3-6%' Or tblMacHwOverview.CPUtype Like '%Atom%Z%' Or
    tblMacHwOverview.CPUtype Like '%pentium%j2%' Or
    tblMacHwOverview.CPUtype Like '%pentium%n3%' Or
    tblMacHwOverview.CPUtype Like '%celeron%j1%' Or
    tblMacHwOverview.CPUtype Like '%celeron%n2%' Or
    tblMacHwOverview.CPUtype Like '%pentium%n3%' Or
    tblMacHwOverview.CPUtype Like '%4205U%' Or tblMacHwOverview.CPUtype Like
    '%5405U%') And tblState.Statename = 'Active'
  Union
  Select Top 1000000 tblAssets.AssetID,
  tblAssets.AssetName,
  tblAssets.Domain,
  tblAssets.Username,
  tblAssets.Userdomain,
  Coalesce(tsysOS.Image, tsysAssetTypes.AssetTypeIcon10) As icon,
  tblAssets.IPAddress,
  tblLinuxProcessors.version As CPU,
  tsysIPLocations.IPLocation,
  tblAssetCustom.Manufacturer,
  tblAssetCustom.Model,
  tblLinuxSystem.OSRelease As OS,
  tblAssets.SP,
  tblAssets.Lastseen,
  tblAssets.Lasttried
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
  Left Join tsysOS On tsysOS.OScode = tblAssets.OScode
  Inner Join tblLinuxProcessors On tblAssets.AssetID = tblLinuxProcessors.AssetID
  Inner join tblLinuxSystem on tblassets.assetid = tblLinuxSystem.AssetID
Where (tblLinuxProcessors.version Like '%8___Y%' Or tblLinuxProcessors.version Like '%Pentium%J4%'
    Or tblLinuxProcessors.version Like '%Pentium%N4%' Or tblLinuxProcessors.version Like
    '%Pentium%J5%' Or tblLinuxProcessors.version Like '%Pentium%N5%' Or
    tblLinuxProcessors.version Like '%Celeron%J3%' Or
    tblLinuxProcessors.version Like '%Celeron%N3%' Or
    tblLinuxProcessors.version Like '%Celeron%J4%' Or
    tblLinuxProcessors.version Like '%Celeron%N4%' Or tblLinuxProcessors.version Like '%Atom%A3%'
    Or tblLinuxProcessors.version Like '%Atom%E3%' Or tblLinuxProcessors.version Like '%Atom%C2%'
    Or tblLinuxProcessors.version Like '%Atom%C3%' Or tblLinuxProcessors.version Like '%Xeon%D%'
    Or tblLinuxProcessors.version Like '%i7-6%' Or tblLinuxProcessors.version Like '%i5-5%' Or
    tblLinuxProcessors.version Like '%i7-5%' Or tblLinuxProcessors.version Like '%Xeon%E5%v4%' Or
    tblLinuxProcessors.version Like '%Xeon%E7%v4%' Or tblLinuxProcessors.version Like '%i3-5%' Or
    tblLinuxProcessors.version Like '%pentium%3___U%' Or tblLinuxProcessors.version Like
    '%Celeron%3___U%' Or tblLinuxProcessors.version Like '%Xeon%e3%v4%' Or
    tblLinuxProcessors.version Like '%M-5Y%' Or tblLinuxProcessors.version Like '%Atom%z8%' Or
    tblLinuxProcessors.version Like '%i9-8%' Or tblLinuxProcessors.version Like '%i7-8%'
    Or tblLinuxProcessors.version Like '%i5-8%' Or tblLinuxProcessors.version Like '%i3-8%' Or
    tblLinuxProcessors.version Like '%i9-9%' Or tblLinuxProcessors.version Like '%i7-9%'
    Or tblLinuxProcessors.version Like '%i5-9%' Or tblLinuxProcessors.version Like '%Xeon%E-2%' Or
    tblLinuxProcessors.version Like '%Pentium%G5%' Or
    tblLinuxProcessors.version Like '%Celeron%G4%' Or tblLinuxProcessors.version Like '%i3-2%' Or
    tblLinuxProcessors.version Like '%i3-3%' Or tblLinuxProcessors.version Like '%pentium%b9%' Or
    tblLinuxProcessors.version Like '%celeron%725c%' Or tblLinuxProcessors.version Like
    '%xeon%E3-1%' Or tblLinuxProcessors.version Like '%i7-4%' Or
    tblLinuxProcessors.version Like '%i5-4%' Or tblLinuxProcessors.version Like '%i3-4%'
    Or tblLinuxProcessors.version Like '%Pentium%g3%' Or tblLinuxProcessors.version Like
    '%Pentium%3560M%' Or tblLinuxProcessors.version Like '%celeron%2970M%' Or
    tblLinuxProcessors.version Like '%Xeon%e5%v3%' Or
    tblLinuxProcessors.version Like '%Xeon%e7%v3%' Or
    tblLinuxProcessors.version Like '%Pentium%3___U%' Or tblLinuxProcessors.version Like
    '%celeron%2___U%' Or tblLinuxProcessors.version Like '%Pentium%3___Y%' Or
    tblLinuxProcessors.version Like '%i7-3%' Or tblLinuxProcessors.version Like '%i5-3%'
    Or tblLinuxProcessors.version Like '%i3-3%' Or
    tblLinuxProcessors.version Like '%pentium%14%v2%' Or tblLinuxProcessors.version Like
    '%pentium%g2%' Or tblLinuxProcessors.version Like '%pentium%2___M' Or
    tblLinuxProcessors.version Like '%pentium%2___U' Or tblLinuxProcessors.version Like
    '%pentium%2___Y' Or tblLinuxProcessors.version Like '%Xeon%v2%e5%' Or
    tblLinuxProcessors.version Like '%Xeon%e7%v2%' Or
    tblLinuxProcessors.version Like '%Xeon%e3%v2%' Or tblLinuxProcessors.version Like '%i7-7%' Or
    tblLinuxProcessors.version Like '%i9-7%' Or tblLinuxProcessors.version Like '%i5-7%'
    Or tblLinuxProcessors.version Like '%i3-7%' Or tblLinuxProcessors.version Like '%celeron%g3%'
    Or tblLinuxProcessors.version Like '%celeron%3___U' Or
    tblLinuxProcessors.version Like '%pentium%4___U' Or tblLinuxProcessors.version Like
    '%Xeon%e3%v6%' Or tblLinuxProcessors.version Like '%m3-7%' Or
    tblLinuxProcessors.version Like '%pentium%4___Y' Or tblLinuxProcessors.version Like
    '%celeron%3___Y' Or tblLinuxProcessors.version Like '%i7-2%' Or
    tblLinuxProcessors.version Like '%i5-2%' Or tblLinuxProcessors.version Like '%i3-2%'
    Or tblLinuxProcessors.version Like '%pentium%9__' Or tblLinuxProcessors.version Like
    '%pentium%b9__' Or tblLinuxProcessors.version Like '%pentium%g6__' Or
    tblLinuxProcessors.version Like '%pentium%g8__' Or
    tblLinuxProcessors.version Like '%celeron%b8__' Or
    tblLinuxProcessors.version Like '%celeron%g4__' Or
    tblLinuxProcessors.version Like '%celeron%g5__' Or
    tblLinuxProcessors.version Like '%celeron%7__' Or
    tblLinuxProcessors.version Like '%celeron%8__%' Or
    tblLinuxProcessors.version Like '%Xeon%E5-2%' Or tblLinuxProcessors.version Like '%Xeon%E5-1%'
    Or tblLinuxProcessors.version Like '%Xeon%E5-4%' Or tblLinuxProcessors.version Like
    '%Xeon%E3-2%' Or tblLinuxProcessors.version Like '%Xeon%D-%' Or
    tblLinuxProcessors.version Like '%i7-6%' Or tblLinuxProcessors.version Like '%i5-6%'
    Or tblLinuxProcessors.version Like '%i3-6%' Or
    tblLinuxProcessors.version Like '%pentium%1405%' Or tblLinuxProcessors.version Like
    '%pentium%G4%' Or tblLinuxProcessors.version Like '%xeon%platinum%8___%' Or
    tblLinuxProcessors.version Like '%xeon%gold%5___%' Or
    tblLinuxProcessors.version Like '%xeon%gold%6___%' Or
    tblLinuxProcessors.version Like '%xeon%silver%4___%' Or
    tblLinuxProcessors.version Like '%xeon%bronze%3___%' Or
    tblLinuxProcessors.version Like '%Xeon%W-2%' Or tblLinuxProcessors.version Like '%Xeon%v5%e3%'
    Or tblLinuxProcessors.version Like '%m7-6%' Or tblLinuxProcessors.version Like '%m5-6%' Or
    tblLinuxProcessors.version Like '%m3-6%' Or tblLinuxProcessors.version Like '%Atom%Z%' Or
    tblLinuxProcessors.version Like '%pentium%j2%' Or
    tblLinuxProcessors.version Like '%pentium%n3%' Or
    tblLinuxProcessors.version Like '%celeron%j1%' Or
    tblLinuxProcessors.version Like '%celeron%n2%' Or
    tblLinuxProcessors.version Like '%pentium%n3%' Or tblLinuxProcessors.version Like '%4205U%' Or
    tblLinuxProcessors.version Like '%5405U%') And tblState.Statename = 'Active' And
  tblLinuxProcessors.Manufacturer Like '%Intel%'
Order By tblAssets.Domain,
  tblAssets.AssetName