→ 🚀What's New? Join Us for the Fall Product Launch! Register Now !
‎01-25-2011 09:59 AM
Solved! Go to Solution.
‎01-25-2011 10:10 AM
Select tblComputers.Computername, tblComputers.ComputerUnique,
tblComputers.Domain, Web40OSName.OSname, tblComputerSystemProduct.Name,
soft.softwareName As [Problem software], tblSoftware.softwareName As
[other software]
From tblComputers Inner Join
(Select tblsoftware.ComputerName, tblsoftware.softwareName
From tblsoftware
Where tblsoftware.softwareName Like 'Microsoft Outlook 2002') soft
On soft.ComputerName = tblComputers.Computername Inner Join
Web40OSName On Web40OSName.Computername = tblComputers.Computername Inner Join
tblComputerSystemProduct On tblComputers.Computername =
tblComputerSystemProduct.Computername Inner Join
tblSoftware On tblComputers.Computername = tblSoftware.ComputerName
Order By tblComputers.ComputerUnique, soft.softwareName
‎01-25-2011 11:24 AM
‎01-25-2011 10:10 AM
Select tblComputers.Computername, tblComputers.ComputerUnique,
tblComputers.Domain, Web40OSName.OSname, tblComputerSystemProduct.Name,
soft.softwareName As [Problem software], tblSoftware.softwareName As
[other software]
From tblComputers Inner Join
(Select tblsoftware.ComputerName, tblsoftware.softwareName
From tblsoftware
Where tblsoftware.softwareName Like 'Microsoft Outlook 2002') soft
On soft.ComputerName = tblComputers.Computername Inner Join
Web40OSName On Web40OSName.Computername = tblComputers.Computername Inner Join
tblComputerSystemProduct On tblComputers.Computername =
tblComputerSystemProduct.Computername Inner Join
tblSoftware On tblComputers.Computername = tblSoftware.ComputerName
Order By tblComputers.ComputerUnique, soft.softwareName
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now