‎05-07-2010 10:53 PM
SELECT TOP (1000000) dbo.tblComputers.Computername, dbo.tblComputers.ComputerUnique, dbo.tblComputers.Domain, dbo.tblADComputers.OU,
dbo.Web40OSName.OSname, dbo.TsysLastscan.Lasttime AS Lastscanned, dbo.Web40OSName.Compimage AS icon
FROM dbo.tblComputers INNER JOIN
dbo.TsysLastscan ON dbo.tblComputers.Computername = dbo.TsysLastscan.Computername LEFT OUTER JOIN
dbo.tblOperatingsystem ON dbo.tblComputers.Computername = dbo.tblOperatingsystem.Computername INNER JOIN
dbo.web40ActiveComputers ON dbo.tblComputers.Computername = dbo.web40ActiveComputers.Computername INNER JOIN
dbo.Web40OSName ON dbo.Web40OSName.Computername = dbo.tblComputers.Computername LEFT OUTER JOIN
dbo.tblADComputers ON dbo.tblComputers.Computername = dbo.tblADComputers.Computername
WHERE (dbo.tblComputers.Computername NOT IN
(SELECT Computername
FROM dbo.tblQuickFixEngineering
WHERE (HotFixID = 'KB958644'))) AND (dbo.TsysLastscan.CFGcode = 49) AND (CAST(LEFT(dbo.tblOperatingsystem.Version, 3) AS Decimal(3, 1))
< 6.1)
ORDER BY dbo.tblComputers.Computer
‎05-09-2010 10:27 PM
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now