Reference Software Audit

Find Computers Missing Software

List all computers which are missing software compared to a reference computer entered. Maybe you've finally finished perfect Windows image, with all the software anyone in your organization should have. The only problem is that every one that is currently already working, might have bits and pieces of the list of software as it has grown over time. Check easily whether computers are missing software compared to your reference machines so you know exactly what is missing and where. Once identified you can take action and start deploying missing software.

Before running the report, replace "Reference" in the report below with the computer name as shown in Lansweeper of your reference computer.

Reference Software List Query

Select Top 1000000 tblSoftwareUni.softwareName,
From tblSoftware
  Inner Join tblSoftwareUni On tblSoftware.softID = tblSoftwareUni.SoftID
  Inner Join tblAssets On tblAssets.AssetID = tblSoftware.AssetID
  Left Join (Select tblSoftwareUni.SoftID,
  From tblSoftwareUni,
    Inner Join tblComputersystem
      On tblAssets.AssetID = tblComputersystem.AssetID
  Where tblAssets.Assettype = -1 And tblComputersystem.Domainrole < 2 And
    Not Exists(Select tblSoftware.softID,
      tblSoftware.AssetID From tblSoftware
    Where tblSoftware.softID = tblSoftwareUni.SoftID And tblSoftware.AssetID =
      tblAssets.AssetID)) tNotInstalled On tNotInstalled.SoftID =
Where tblAssets.AssetName = 'Reference'
Order By tblSoftwareUni.softwareName,

Audit and Take Action in 3 Easy Steps


1. Download & Install Lansweeper


3. Run the Audit & Take Action

Download Lansweeper to Run this Audit

Harness the Power of Reporting