→ The Lansweeper Customer Excellence Awards 2024 - Submit Your Project Now! Learn More & Enter Here
‎07-08-2009 07:01 PM
Solved! Go to Solution.
‎07-13-2009 11:23 AM
‎07-22-2009 12:16 PM
‎07-22-2009 01:08 PM
Lansweeper wrote:
Do you get an error when you run it? or command completed successfully
‎07-21-2009 01:02 PM
alter view web30OScount AS SELECT TOP 100 PERCENT ISNULL(dbo.tblOperatingsystem.Caption, 'Not scanned') AS OS, COUNT(dbo.tblComputers.Computername) AS Total
FROM dbo.tblComputers LEFT OUTER JOIN
dbo.tblOperatingsystem ON dbo.tblComputers.Computername = dbo.tblOperatingsystem.Computername
GROUP BY ISNULL(dbo.tblOperatingsystem.Caption, 'Not scanned')
ORDER BY COUNT(dbo.tblComputers.Computername) DESC, ISNULL(dbo.tblOperatingsystem.Caption, 'Not scanned')
‎07-21-2009 01:27 PM
Lansweeper wrote:
try from the sql execute console:alter view web30OScount AS SELECT TOP 100 PERCENT ISNULL(dbo.tblOperatingsystem.Caption, 'Not scanned') AS OS, COUNT(dbo.tblComputers.Computername) AS Total
FROM dbo.tblComputers LEFT OUTER JOIN
dbo.tblOperatingsystem ON dbo.tblComputers.Computername = dbo.tblOperatingsystem.Computername
GROUP BY ISNULL(dbo.tblOperatingsystem.Caption, 'Not scanned')
ORDER BY COUNT(dbo.tblComputers.Computername) DESC, ISNULL(dbo.tblOperatingsystem.Caption, 'Not scanned')
‎07-20-2009 09:19 PM
SELECT TOP 100 PERCENT ISNULL(dbo.tblOperatingsystem.Caption, 'Not scanned') AS OS, COUNT(dbo.tblComputers.Computername) AS Total
FROM dbo.tblComputers LEFT OUTER JOIN
dbo.tblOperatingsystem ON dbo.tblComputers.Computername = dbo.tblOperatingsystem.Computername
GROUP BY ISNULL(dbo.tblOperatingsystem.Caption, 'Not scanned')
ORDER BY COUNT(dbo.tblComputers.Computername) DESC, ISNULL(dbo.tblOperatingsystem.Caption, 'Not scanned')
‎07-21-2009 12:10 PM
Lansweeper wrote:
change to thisSELECT TOP 100 PERCENT ISNULL(dbo.tblOperatingsystem.Caption, 'Not scanned') AS OS, COUNT(dbo.tblComputers.Computername) AS Total
FROM dbo.tblComputers LEFT OUTER JOIN
dbo.tblOperatingsystem ON dbo.tblComputers.Computername = dbo.tblOperatingsystem.Computername
GROUP BY ISNULL(dbo.tblOperatingsystem.Caption, 'Not scanned')
ORDER BY COUNT(dbo.tblComputers.Computername) DESC, ISNULL(dbo.tblOperatingsystem.Caption, 'Not scanned')
‎07-18-2009 02:58 PM
‎07-20-2009 06:01 PM
Lansweeper wrote:
You will need to change the stored procedure "web30OScount"
‎07-14-2009 05:39 PM
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now