→ Having trouble accessing our new support portal or creating a ticket? Please notify our team here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
kingoflilliput
Engaged Sweeper
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.
1 ACCEPTED SOLUTION
Hemoco
Lansweeper Alumni
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

View solution in original post

1 REPLY 1
Hemoco
Lansweeper Alumni
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