‎09-08-2009 05:07 AM
‎09-08-2009 11:00 PM
‎09-08-2009 10:07 PM
create view web30repsoftwaretotal as SELECT TOP 100 PERCENT dbo.tblSoftware.softwareName AS Software, dbo.tblSoftware.softwareVersion AS Version,
dbo.tblSoftware.SoftwarePublisher AS Publisher, COUNT(dbo.tblSoftware.ComputerName) AS Total
FROM dbo.tblSoftware INNER JOIN
dbo.tblComputers ON dbo.tblSoftware.ComputerName = dbo.tblComputers.Computername
GROUP BY dbo.tblSoftware.softwareName, dbo.tblSoftware.softwareVersion, dbo.tblSoftware.SoftwarePublisher
ORDER BY COUNT(dbo.tblSoftware.ComputerName) DESC
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now