Find OpenSSL Installations and Version
OpenSSL is a very common package installed on Linux devices to provide secure communications over the network. It’s an open-source cryptography library of the Secure Sockets Layer (SSL) and Transport Layer Security (TLS) protocols. New versions are periodically released and with the report below, you can easily get an overview of the OpenSSL Linux software in your environment along with details like the version, description, and more.
OpenSSL Audit Lansweeper Classic Query
COPY
Select Top (1000000) tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.IPAddress,
tsysIPLocations.IPLocation,
tblAssetCustom.Manufacturer,
tblAssetCustom.Model,
tblLinuxSystem.OSRelease As OS,
tblSoftwareUni.softwareName As Software,
tblLinuxSoftware.Version,
tsysLinuxSoftwareType.Name As SoftwareType,
tblLinuxSoftware.Description,
tblSoftwareUni.SoftwarePublisher As Publisher,
tblLinuxSoftware.Architecture,
tblLinuxSoftware.Release,
tblLinuxSoftware.InstallDate,
tblLinuxSoftware.LastChanged,
tblAssets.Firstseen As [Created at],
tblAssets.Lastseen As [Last successful scan],
tblAssets.Lasttried As [Last scan attempt]
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
Inner Join tsysLinuxSoftwareType On tsysLinuxSoftwareType.Id =
tblLinuxSoftware.Type
Where tsysAssetTypes.AssetTypename = 'Linux' And tblState.Statename = 'Active'
And tblSoftwareUni.softwarename = 'openssl'
Order By tblAssets.IPNumeric,
tblAssets.Domain,
tblAssets.AssetName,
Software
