Intel CPU Zombieload / RIDL / Fallout Exploit Audit

Hardware Hardware Components Security Vulnerability
Discover Affected Intel Processors That Need CPU Microcode Updates

Detect all computers which require a microcode update to protect them from the new Intel-SA-00233 vulnerabilities. INTEL-SA-00233 includes Zombieload, RIDL and Fallout vulnerabilities or CVE-2018-12126, CVE-2018-12127, CVE-2018-12130. The audit below provides an overview of all assets that will be getting a microcode update according to Intel’s microcode update guidance. You can learn more about this vulnerability in our Zombieload blog post.
Intel CPU Vulnerability - Zombieload - Fallout - RIDL
Intel Zombieload/RIDL/Fallout Query

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
Show
Hide
NO CREDIT CARD REQUIRED
Ready to get started? You'll be up and running in no time.

Explore all our features, free for 14 days.
TRY NOW FOR FREE TALK TO SALES
Audit and Take Action in 3 Easy Steps

1. Start Your Free Trial

Experience all Lansweeper features: start your free 14-day trial.
2. Discover All Assets

Discover all IT, OT, and IoT devices from all environments and get a complete asset inventory.
3. Run the Audit & Take Action

Run the audit report and see which devices require your attention.
NO CREDIT CARD REQUIRED
Ready to get started?
You’ll be up and running in no time.

Explore all our features, free for 14 days.
TRY NOW TALK TO SALES
Intel CPU Zombieload / RIDL / Fallout Exploit Audit

Discover Affected Intel Processors That Need CPU Microcode Updates

Intel Zombieload/RIDL/Fallout Query

Ready to get started? You’ll be up and running in no time.

Ready to get started?
You’ll be up and running in no time.
