The report below will provide you with an overview of all Samba Linux software along with the basic asset details like the asset name, IP address, and critically the software version. The report provides data specifically on software that is named “samba-common” or “samba” as these are the most commonly used Linux package names for Samba installations. Using the report below, you’ll be able to identify which devices still have an outdated Samba version and require an update to be fully secure. Since the Samba team regularly updates Samba to include security updates, it is essential you monitor what the latest samba version for your Linux distributions are so you can play your updates when too many devices become outdated.
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypename As AssetType,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.IPAddress,
tblSoftwareUni.softwareName As Software,
tblLinuxSoftware.Version As Version,
tsysIPLocations.IPLocation,
tblAssetCustom.Manufacturer,
tblAssetCustom.Model,
tblLinuxSystem.OSRelease As OS,
tblLinuxSystem.KernelRelease,
tblAssets.Lastseen,
tblAssets.Lasttried,
tblLinuxSoftware.LastChanged
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
Inner Join tblLinuxSoftware On tblAssets.AssetID = tblLinuxSoftware.AssetID
Inner Join tblSoftwareUni On
tblSoftwareUni.SoftID = tblLinuxSoftware.SoftwareUniID
Inner Join tblLinuxSystem On tblAssets.AssetID = tblLinuxSystem.AssetID
Where tblSoftwareUni.softwareName IN ('Samba', 'samba-common') And
tblState.Statename = 'Active'
Order By tblAssets.Domain,
tblAssets.AssetName,
Software
