→ 🚀What's New? Join Us for the Fall Product Launch! Register Now !
‎09-30-2011 11:13 AM
Select Top 1000000 dbo.tblSoftware.softwareName As Software,
dbo.tblSoftware.softwareVersion As Version, Count(tblComputers.Computer) As
Number
From dbo.tblSoftware Inner Join
tblComputers On tblComputers.Computername = dbo.tblSoftware.ComputerName
Group By dbo.tblSoftware.softwareName, dbo.tblSoftware.softwareVersion
Having dbo.tblSoftware.softwareName Like 'Adobe Reader%'
Solved! Go to Solution.
‎09-30-2011 06:05 PM
‎09-30-2011 06:11 PM
‎09-30-2011 06:05 PM
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now