cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Esben_D
Lansweeper Employee
Lansweeper Employee
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
8 Comments
brianraley
Engaged Sweeper III
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
Lansweeper Employee
Lansweeper Employee
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:

Case
When tblProcessor.Name Like '%Celeron%J3%' Or tblProcessor.Name Like '%Celeron%N3%' Then 'Code name 1'
End as [Code name],
tcooper
Engaged Sweeper III
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
Engaged Sweeper II
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
Lansweeper Employee
Lansweeper Employee
tcooper wrote:
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.com/forum/yaf_postsm38385_Windows--Bios-Information--Built-in.aspx
If you check for new bios updates with your manufactures you can create your own progress report quite simple.

SBSTech wrote:
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
Engaged Sweeper III
Esben.D wrote:
tcooper wrote:
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
Champion Sweeper III
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
Lansweeper Employee
Lansweeper Employee
tcooper wrote:
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.

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


AZHockeyNut wrote:
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.

New to Lansweeper?

Try Lansweeper For Free

Experience Lansweeper with your own data.
Sign up now for a 14-day free trial.

Try Now