Notification

Icon
Error

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

Posted: Wednesday, May 15, 2019 11:10:21 AM(UTC)
Esben.D

Esben.D

Member Administration Original PosterPosts: 1,685
4
Like
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.c...How-to-run-a-report.aspx

Code:
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
brianraley
#1brianraley Member Posts: 29  
posted: 5/15/2019 2:58:47 PM(UTC)
Esben I've appreciated your recent vulnerability report additions. Do you know if the Intel "code name" such as Kaby Lake is located anywhere where we can generate a report grouping by this code name? Thanks again!
Esben.D
#2Esben.D Member Administration Original PosterPosts: 1,685  
posted: 5/15/2019 3:47:30 PM(UTC)
Unfortunately that information is not available easily. You can add it to the report, but you would have to manually list the conditions for a specific code name. This source lists I used does have the code names with it, adding them would take longer than I have the time for currently.

It would basically be a long case in the report which would take several hours:

Quote:
Case
When tblProcessor.Name Like '%Celeron%J3%' Or tblProcessor.Name Like '%Celeron%N3%' Then 'Code name 1'
End as [Code name],
tcooper
#3tcooper Member Posts: 15  
posted: 5/15/2019 4:34:04 PM(UTC)
Will this report show any devices that won't be getting a microcode update? Also, is there a way to tell if a microcode update has been applied so the device is no longer vulnerable?
SBSTech
#4SBSTech Member Posts: 4  
posted: 5/15/2019 6:59:09 PM(UTC)
Is anyone's report generating results for Mac computers? They don't appear on my report. The only thing I can think of is that the CPU type (for my apple systems) is listed as "Intel Core i5" and "Intel Core i7" without specifying the generation... Is this a universal experience or do I have a configuration issue?
Esben.D
#5Esben.D Member Administration Original PosterPosts: 1,685  
posted: 5/16/2019 9:35:26 AM(UTC)
Originally Posted by: tcooper Go to Quoted Post
Will this report show any devices that won't be getting a microcode update? Also, is there a way to tell if a microcode update has been applied so the device is no longer vulnerable?


It does not include devices that won't be getting an update. As for a report about the microcode being applied or not, If I'm not mistaken, microcode updates can only be done with a BIOS update.
You can report on your bios version with this report: https://www.lansweeper.c...formation--Built-in.aspx
If you check for new bios updates with your manufactures you can create your own progress report quite simple.

Originally Posted by: SBSTech Go to Quoted Post
Is anyone's report generating results for Mac computers? They don't appear on my report. The only thing I can think of is that the CPU type (for my apple systems) is listed as "Intel Core i5" and "Intel Core i7" without specifying the generation... Is this a universal experience or do I have a configuration issue?


In the limited pool of Macs I had I got a similar result. Macs don't seem to provide the same level of detail about CPU model as Windows or Linux.
tcooper
#6tcooper Member Posts: 15  
posted: 5/16/2019 4:11:11 PM(UTC)
Originally Posted by: Esben.D Go to Quoted Post
Originally Posted by: tcooper Go to Quoted Post
Will this report show any devices that won't be getting a microcode update? Also, is there a way to tell if a microcode update has been applied so the device is no longer vulnerable?

It does not include devices that won't be getting an update.

How would I make a report of just the devices that won't be receiving an update? Is there a way to make a report that will report any devices that are not part of another report?
AZHockeyNut
#7AZHockeyNut Member Alpha Tester Posts: 230  
posted: 5/16/2019 7:52:17 PM(UTC)
Great work as usual!
I would love to see this report tied to that Bios report so we can have the current bios and loaded/installed bios and know if the indicated systems are up to date.
If I recall correctly though, that would be this report querying another report/view and a bit tricky for most no?
Esben.D
#8Esben.D Member Administration Original PosterPosts: 1,685  
posted: 5/17/2019 12:18:51 PM(UTC)
Originally Posted by: tcooper Go to Quoted Post
How would I make a report of just the devices that won't be receiving an update? Is there a way to make a report that will report any devices that are not part of another report?


For a very basic version copy and paste the report above into this report. It will just list all the Windows/Linux/Mac machines not included in the original report.

Quote:
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypename,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.IPAddress,
tblAssets.Lastseen,
tblAssets.Lasttried
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Left Join (Paste entire report here) And tblState.Statename =
'Active' And tblLinuxProcessors.Manufacturer Like '%Intel%'
Order By tblAssets.Domain,
tblAssets.AssetName) As Zombieload On Zombieload.AssetID =
tblAssets.AssetID
Where tsysAssetTypes.AssetTypename In ('Windows', 'Mac', 'Linux') AND
tblAssetCustom.State = 1 AND Zombieload.AssetID <>
tblAssets.AssetID


Originally Posted by: AZHockeyNut Go to Quoted Post
Great work as usual!
I would love to see this report tied to that Bios report so we can have the current bios and loaded/installed bios and know if the indicated systems are up to date.
If I recall correctly though, that would be this report querying another report/view and a bit tricky for most no?


Problem is that doing bios version checks isn't hard if it's for one specific manufacturer and a handful of models. Including a check for even the big manufacturers would still include way to many models.
I linked the bios report earlier which should be a good start for people who want to do that for their environment.

Active Discussions

Lansweeper Report for SSAS and SSIS
by  The Boss   Go to last post Go to first unread
Last post: Yesterday at 6:53:21 PM(UTC)
Lansweeper Firefox 67.0.3 zero-day vulnerability
by  Esben.D  
Go to last post Go to first unread
Last post: Yesterday at 3:34:44 PM(UTC)
Lansweeper PO Box Query
by  kmoc   Go to last post Go to first unread
Last post: Yesterday at 11:16:28 AM(UTC)
Lansweeper Computer Age Chart Report
by  CyberCitizen  
Go to last post Go to first unread
Last post: Yesterday at 8:40:47 AM(UTC)
Lansweeper User association report query
by  dan508   Go to last post Go to first unread
Last post: 6/24/2019 5:38:51 PM(UTC)
Lansweeper Dell SupportAssist CVE-2019-12280
by  Esben.D  
Go to last post Go to first unread
Last post: 6/24/2019 9:15:20 AM(UTC)
Lansweeper Office 365 OneDrive Usage and Sync
by  brodiemac   Go to last post Go to first unread
Last post: 6/21/2019 3:51:36 PM(UTC)
Lansweeper BlueKeep Vulnerability
by  Esben.D  
Go to last post Go to first unread
Last post: 6/21/2019 9:52:22 AM(UTC)