‎02-17-2010 07:46 PM
SELECT dbo.tblADComputers.Computername, dbo.tblADComputers.OperatingSystem, dbo.tblADComputers.OU, Query.Software, Query.Version
FROM dbo.tblADComputers LEFT OUTER JOIN
(SELECT TOP (100) PERCENT tblADComputers_1.OU, tblADComputers_1.Computername, dbo.tblSoftware.softwareName AS Software,
dbo.tblSoftware.softwareVersion AS Version, dbo.tblSoftware.SoftwarePublisher AS Publisher
FROM dbo.tblSoftware RIGHT OUTER JOIN
dbo.tblComputers ON dbo.tblComputers.Computername = dbo.tblSoftware.ComputerName RIGHT OUTER JOIN
dbo.tblADComputers AS tblADComputers_1 ON tblADComputers_1.Computername = dbo.tblComputers.Computername
GROUP BY tblADComputers_1.OU, tblADComputers_1.Computername, dbo.tblSoftware.softwareName, dbo.tblSoftware.softwareVersion,
dbo.tblSoftware.SoftwarePublisher
HAVING (dbo.tblSoftware.softwareName LIKE 'Adobe Flash%')) AS Query ON dbo.tblADComputers.Computername = Query.Computername
WHERE (NOT (Query.Version = '10.0.45.2'))
‎02-17-2010 07:55 PM
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now