03-27-2012 02:39 AM
Solved! Go to Solution.
03-27-2012 12:20 PM
Select Distinct tblComputers.Computername, tblComputers.ComputerUnique,
tblComputers.Domain, tblComputers.Firstseen, tblComputers.Lastseen,
tblComputers.LastknownIP
From tblComputers
Where tblComputers.Computername In (Select tblSoftware.ComputerName
From tblSoftware
Where tblSoftware.softwareName Like '%ApplicationA%') And
tblComputers.Computername In (Select tblSoftware.ComputerName From tblSoftware
Where tblSoftware.softwareName Like '%ApplicationB%')
Order By tblComputers.ComputerUnique
03-27-2012 07:24 PM
03-27-2012 12:20 PM
Select Distinct tblComputers.Computername, tblComputers.ComputerUnique,
tblComputers.Domain, tblComputers.Firstseen, tblComputers.Lastseen,
tblComputers.LastknownIP
From tblComputers
Where tblComputers.Computername In (Select tblSoftware.ComputerName
From tblSoftware
Where tblSoftware.softwareName Like '%ApplicationA%') And
tblComputers.Computername In (Select tblSoftware.ComputerName From tblSoftware
Where tblSoftware.softwareName Like '%ApplicationB%')
Order By tblComputers.ComputerUnique
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now