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,
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
