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
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