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

Reference Software List Query

Select Top 1000000 tblSoftwareUni.softwareName,
  tNotInstalled.AssetID,
  tNotInstalled.AssetName
From tblSoftware
  Inner Join tblSoftwareUni On tblSoftware.softID = tblSoftwareUni.SoftID
  Inner Join tblAssets On tblAssets.AssetID = tblSoftware.AssetID
  Left Join (Select tblSoftwareUni.SoftID,
    tblAssets.AssetID,
    tblAssets.AssetName
  From tblSoftwareUni,
    tblAssets
    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 =
    tblSoftware.softID
Where tblAssets.AssetName = 'Reference'
Order By tblSoftwareUni.softwareName,
  tNotInstalled.AssetName

Audit and Take Action in 3 Easy Steps

Download-Install-Lansweeper

1. Download & Install Lansweeper

Save-and-Run-the-Report

3. Run the Audit & Take Action

Download Lansweeper to Run this Audit

Harness the Power of Reporting