‎03-18-2010 08:46 PM
SELECT TOP (1000000) dbo.tblerrors.Computername, dbo.tblComputers.ComputerUnique, dbo.tblerrors.ErrorText, MAX(dbo.tblerrors.Lastchanged)
AS [Last changed]
FROM dbo.tblerrors INNER JOIN
dbo.tblComputers ON dbo.tblerrors.Computername = dbo.tblComputers.Computername INNER JOIN
dbo.web40ActiveComputers ON dbo.tblComputers.Computername = dbo.web40ActiveComputers.Computername
GROUP BY dbo.tblerrors.Computername, dbo.tblComputers.ComputerUnique, dbo.tblerrors.ErrorText
HAVING (dbo.tblerrors.ErrorText = 'like %dns redirected%')
ORDER BY [Last changed] DESC
SELECT TOP (1000000) dbo.tblerrors.Computername, dbo.tblComputers.ComputerUnique, dbo.tblComputers.Domain, dbo.tblerrors.ErrorText, MAX(dbo.tblerrors.Lastchanged)
AS [Last changed]
FROM dbo.tblerrors INNER JOIN
dbo.tblComputers ON dbo.tblerrors.Computername = dbo.tblComputers.Computername INNER JOIN
dbo.web40ActiveComputers ON dbo.tblComputers.Computername = dbo.web40ActiveComputers.Computername
GROUP BY dbo.tblerrors.Computername, dbo.tblComputers.ComputerUnique, dbo.tblComputers.domain, dbo.tblerrors.ErrorText
HAVING (dbo.tblerrors.ErrorText like '%dns redirected%')
ORDER BY [Last changed] DESC
‎03-22-2010 10:24 AM
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now