Linux Software Installed Reporting

[kingoflilliput]

Hi,

I'm currently evaluating Lansweeper for our company.I'm new so please forgive me if this question is not the smartest one.

I've searched the forums and could not find an answer.

I'm running the standard report for "Software: All Installed Software". I'm failing to view installed software for a linux asset in the report. The asset has been scanned successfully and the software appears under the asset. Does this report only apply to Windows assets?

Is there an alternative report to show software installed of that is not OS specific?

Thanks for your help,

Jonathan.

[Hemoco · Accepted solution]

We answered some of your questions via email as well, but for anyone interested: a sample Linux software report can be seen below. Some of the built-in software reports (like the "Software: All installed software" report) only list Windows software. It's somewhat complicated to build a report that includes both Linux and Windows software, as Linux has its own database tables. You would have to create a union query. We therefore recommend running separate reports for Linux instead.

Select Top 1000000 tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tsysAssetTypes.AssetTypename As Type,
tblAssets.IPAddress,
tblAssets.Firstseen,
tblAssets.Lastseen,
tblAssets.Lasttried,
tblSoftwareUni.softwareName,
tblLinuxSoftware.Version,
tblSoftwareUni.SoftwarePublisher,
tblLinuxSoftware.InstallDate
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType =
tblAssets.Assettype
Inner Join tblLinuxSoftware On tblAssets.AssetID =
tblLinuxSoftware.AssetID
Inner Join tblSoftwareUni On tblSoftwareUni.SoftID =
tblLinuxSoftware.SoftwareUniID
Where tsysAssetTypes.AssetTypename = 'linux' And tblAssetCustom.State = 1
Order By tblAssets.IPNumeric,
tblSoftwareUni.softwareName