Generate a Customized Report

[jgessay]

My department has asked that I generate a report listing all the computers on our network with the latest version(s) of Adobe Flash and Java installed. Is this a report that already exists in Lansweeper? Or must I create a customized report to show just this information?

[Daniel_B · Accepted solution]

The built-in report "Software: List of software by computer" helps you to get a list of PCs with all software installed on them. You can filter in column Software for what you are interested in to see. If you would like to list all computers not having a specific version installed, use a custom report like the one below. It lists workstation computers not having one of the two defined software packages installed, together with what currently is installed on them.

Select Top 1000000 tblAssets.AssetID,
  tblAssets.AssetName,
  tblAssets.Lastseen,
  tSoftware.softwareName As [Software present on system],
  tSoftware.softwareVersion
From tblAssets
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
  Left Join (Select tblSoftware.AssetID,
    tblSoftwareUni.softwareName,
    tblSoftware.softwareVersion
  From tblSoftware
    Inner Join tblSoftwareUni On tblSoftware.softID = tblSoftwareUni.SoftID
  Where (tblSoftwareUni.softwareName Like 'adobe flash player%') Or
    (tblSoftwareUni.softwareName Like 'java %')) tSoftware
    On tSoftware.AssetID = tblAssets.AssetID
  Inner Join tblComputersystem On tblAssets.AssetID = tblComputersystem.AssetID
Where (tblAssets.AssetID Not In (Select tblSoftware.AssetID
    From tblSoftware Inner Join tblSoftwareUni On tblSoftware.softID =
        tblSoftwareUni.SoftID
    Where tblSoftwareUni.softwareName Like 'adobe flash player%' And
      tblSoftware.softwareVersion Like '16.0.0.235') Or
    tblAssets.AssetID Not In (Select tblSoftware.AssetID
    From tblSoftware Inner Join tblSoftwareUni On tblSoftware.softID =
        tblSoftwareUni.SoftID
    Where tblSoftwareUni.softwareName Like 'java 8 update 35%')) And
  tblAssetCustom.State = 1 And tblComputersystem.Domainrole < 2
Order By tblAssets.AssetName,
  [Software present on system]