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