→ 🚀What's New? Join Us for the Fall Product Launch! Register Now !
‎06-14-2011 07:13 PM
Select tblComputers.Computer
From tblComputers
Where tblComputers.Computer != (Select tblComputers.Computer
From tblComputers Inner Join tblsoftware On tblsoftware.ComputerName =
tblComputers.Computername
Where tblsoftware.softwareName = 'Software package that needs to be checked')
Solved! Go to Solution.
‎06-14-2011 10:58 PM
Select tblComputers.Computer
From tblComputers
Where tblComputers.Computer Not In (Select ComputerName
From tblsoftware
Where softwareName = 'Software package that needs to be checked')
‎11-09-2011 09:12 PM
‎11-10-2011 02:50 PM
robintre wrote:
But I wonder if it's possible to have only one report where I could enter the software name as a parameter when I run it. This would avoid making a lot of reports.
robintre wrote:
Or even better, directly in the software overview, is it possible to view the computers where the software is not installed?
‎06-15-2011 11:07 AM
Select tblComputers.Computer
From tblComputers
Where tblComputers.Computer Not In (Select tblComputers.Computer
From tblComputers Inner Join tblsoftware On tblsoftware.ComputerName =
tblComputers.Computername
Where tblsoftware.softwareName = 'Software package that needs to be checked')
‎06-14-2011 10:58 PM
Select tblComputers.Computer
From tblComputers
Where tblComputers.Computer Not In (Select ComputerName
From tblsoftware
Where softwareName = 'Software package that needs to be checked')
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now