Having issues creating a report that will display assets with missing a specific application

[tallpr24]

For instance, I have reports that display assets using Firefox along with their version numbers; however, I am unable to reverse this process.

I require a report detailing the computers that lack corporate applications, such as Firefox or Sentinel One.

Could someone provide me with some advice?

I have attempted the following without success, and ChatGPT also seems unable to assist.

[tallpr24]

i know how to do it with sql on the on prem server, the issue is getting this to work on the cloud version 

[DavidPK]

Hi,

We've created a sample report for missing software on assets. Instructions for adding this report to your Lansweeper installation can be found here: https://www.lansweeper.com/knowledgebase/how-to-add-a-report-to-your-lansweeper-installation/

If you are interested in building or modifying reports, we do recommend:
• Reviewing some SQL tutorials, as the Lansweeper report builder is a standard SQL editor. If you know SQL, you know how to build Lansweeper reports as well. This seems like a good tutorial: https://www.w3schools.com/sql/
• Making use of our database dictionary, which explains in great detail what each database table and field stores. More information on the dictionary can be found here: https://www.lansweeper.com/knowledgebase/accessing-the-lansweeper-database-documentation/
Checking out our report library: https://www.lansweeper.com/report/

SELECT DISTINCT TOP 1000000 tblAssets.AssetID,
                           tblAssets.AssetName,
                           tblAssets.Domain,
                           tblAssets.Username,
                           tblAssets.Userdomain,
                           COALESCE(tsysOS.Image, tsysAssetTypes.AssetTypeIcon10) AS icon,
                           tblAssets.IPAddress,
                           tsysIPLocations.IPLocation,
                           tblAssetCustom.Manufacturer,
                           tblAssetCustom.Model,
                           tsysOS.OSname AS OS,
                           tblAssets.SP,
                           tblAssets.Lastseen,
                           tblAssets.Lasttried
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 tblSoftware ON tblAssets.AssetID = tblSoftware.AssetID
    INNER JOIN tblSoftwareUni ON tblSoftwareUni.SoftID = tblSoftware.softID
    LEFT JOIN tsysOS ON tsysOS.OScode = tblAssets.OScode
WHERE tblAssets.AssetID NOT IN
(
   SELECT tblSoftware.AssetID
   FROM tblSoftware
Inner Join tblsoftwareuni on tblsoftware.softID = tblsoftwareuni.softid
    WHERE tblSoftwareUni.softwareName LIKE '%Lansweeper%'
)
ORDER BY tblAssets.AssetName;