‎03-26-2009 03:05 PM
‎04-16-2009 05:24 PM
‎04-16-2009 04:52 PM
‎04-08-2009 08:42 PM
‎04-08-2009 05:21 PM
‎04-08-2009 05:13 PM
‎04-02-2009 04:22 PM
‎04-02-2009 05:16 PM
Pollak wrote:
OKkay I imported this script, but I do not see anything seperating by OU.
Thanks,
Niles
‎03-31-2009 02:09 PM
SELECT TOP 100 PERCENT dbo.tblADComputers.OU, dbo.tblSoftware.softwareName, COUNT(dbo.tblADComputers.Computername) AS Total
FROM dbo.tblADComputers INNER JOIN
dbo.tblComputers ON dbo.tblADComputers.Computername = dbo.tblComputers.Computername INNER JOIN
dbo.tblSoftware ON dbo.tblComputers.Computername = dbo.tblSoftware.ComputerName
GROUP BY dbo.tblADComputers.OU, dbo.tblSoftware.softwareName
ORDER BY dbo.tblADComputers.OU, dbo.tblSoftware.softwareName
‎03-31-2009 01:19 PM
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now