‎09-08-2009 05:07 AM
‎09-09-2009 09:58 PM
‎09-09-2009 09:55 PM
‎09-09-2009 09:01 PM
‎09-09-2009 08:50 PM
‎09-09-2009 08:29 PM
‎09-09-2009 07:50 PM
‎09-09-2009 07:06 PM
INSERT INTO dbo.tsysreports
(Reportquery, Reporttitle)
SELECT 'web30repsoftwaretotal' AS Expr1, 'All installed software' AS Expr2
‎09-09-2009 06:24 PM
‎09-09-2009 06:20 AM
alter 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