Linux Software Report Please

[ddarlage]

I have tried and failed creating a script that will show missing software from Linux boxes.

Below is what I have tried and all it does is return linux systems.


Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypename,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.IPAddress,
tblLinuxSystem.OSRelease,
tblLinuxSystem.KernelRelease,
tblAssets.Lastseen
From tblAssets
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tblLinuxSystem On tblAssets.AssetID = tblLinuxSystem.AssetID
Where tblAssets.AssetID Not In (Select Top 1000000 tblSoftware.AssetID
From tblSoftware Inner Join tblSoftwareUni On tblSoftwareUni.SoftID =
tblSoftware.softID
Where tblSoftwareUni.softwareName Like '%SOFTWARE HERE%')

[ddarlage]

I have tried and can not seem to figure it out. However, I can get the report to show the systems that do not have something installed. However, the issue is it still list the software installed on each system. meaning my avg. report is 55,000 lines when it should be around maybe 50 to 100.

I just need to report to list the name of each system that is missing the software.

[Esben_D]

Linux software is stored in it's own separate tables. In your query you're using the default software table which only stores Windows software. This also explains why no Linux assets show up.

The report below should give you an overview of all Linux assets which do not have the specified software scanned. It is based on the similar Windows report, but I've changed the tables to have the Linux software tables.

Windows report: https://www.lansweeper.com/Forum/yaf_postst10306_Windows-computers-that-do-not-have-a-specific-software-installed.aspx

Select Top 1000000 tblAssets.AssetID,
  tblAssets.AssetName,
  tblAssets.Domain,
  tsysAssetTypes.AssetTypename As AssetType,
  tblAssets.Username,
  tblAssets.Userdomain,
  tsysAssetTypes.AssetTypeIcon10 As icon,
  tblAssets.IPAddress,
  tsysIPLocations.IPLocation,
  tblAssetCustom.Manufacturer,
  tblAssetCustom.Model,
  tblLinuxSystem.OSRelease As OS,
  tblAssets.SP,
  tblAssets.Lastseen,
  tblAssets.Lasttried,
  tblSoftwareUni.softwareName As Software,
  tblLinuxSoftware.Version As Version,
  tblSoftwareUni.SoftwarePublisher As Publisher,
  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 tblAssets.AssetID Not In (Select Top 1000000 tblLinuxSoftware.AssetID
  From tblLinuxSoftware Inner Join tblSoftwareUni On tblSoftwareUni.SoftID =
      tblLinuxSoftware.SoftwareUniID
  Where tblSoftwareUni.softwareName Like '%YourSoftware%') And
  tblState.Statename = 'Active'
Order By tblAssets.Domain,
  tblAssets.AssetName,
  Software