Community FAQ
cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
tallpr24
Engaged Sweeper II

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.

2 REPLIES 2
tallpr24
Engaged Sweeper II

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
Lansweeper Tech Support
Lansweeper Tech Support

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;
 

General Discussions

Find answers to technical questions about Lansweeper.

New to Lansweeper?

Try Lansweeper For Free

Experience Lansweeper with your own data.
Sign up now for a 14-day free trial.

Try Now