‎01-12-2018 05:54 AM
‎01-19-2018 02:09 PM
‎01-15-2018 05:43 PM
‎01-15-2018 11:16 AM
We did consider adding reports for other asset types such as VMware and Linux, unfortunately it's impractical to create a unified report to cover the entirety of all Linux assets, as the patched kernel version required will vary very greatly depending on which OS release and version is being used. There are too many divergences in Linux assets to create a "one size fits all" report. As such a report would need to be tailored for every environment.
For VMware a similar issue exists, where the VMware OS build could indicate vulnerability or non-vulnerability. Unfortunately, there are quite a large number of builds out there for each ESXi version, VMware proper builds, and OEM builds such as Dell, HP, etc. with this OEM builds using different build numbering.
That said, we did add 2 reports below that will list the relevant data for VMware and Linux assets, which can aid you in your research for determining which assets require further attention.
Linux:
Select Distinct Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Processor,
tblLinuxSystem.OperatingSystem,
tblLinuxSystem.OSRelease,
tblSoftwareUni.softwareName,
tblLinuxSoftware.Version As KernelVersion,
tblLinuxSoftware.Release As KernelRelease,
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
Inner Join tblLinuxSystem On tblAssets.AssetID = tblLinuxSystem.AssetID
Inner Join tblLinuxSoftware On tblAssets.AssetID = tblLinuxSoftware.AssetID
Inner Join tblSoftwareUni On tblSoftwareUni.SoftID =
tblLinuxSoftware.SoftwareUniID
Where tblSoftwareUni.softwareName = 'Kernel' And tblAssetCustom.State = 1
VMware:
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblVmwareInfo.Version,
tblAssets.Processor,
tblVmwareInfo.BiosVersion,
tblVmwareInfo.BiosDate,
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
Inner Join tblVmwareInfo On tblAssets.AssetID = tblVmwareInfo.AssetID
Where tblAssetCustom.State = 1
Order By tblAssets.AssetName
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now