‎02-02-2010 03:28 PM
‎02-02-2010 04:50 PM
‎02-02-2010 04:46 PM
CREATE VIEW dbo.Web30repAllWorkstations
AS
SELECT dbo.tblComputers.Computername, dbo.tblComputers.Domain, dbo.tblComputersystem.Domainrole, dbo.tblComputersystem.Lastchanged
FROM dbo.tblComputersystem INNER JOIN
dbo.tblComputers ON dbo.tblComputersystem.Computername = dbo.tblComputers.Computername
WHERE (dbo.tblComputersystem.Domainrole < '2')
GO
‎02-02-2010 03:41 PM
‎02-02-2010 03:35 PM
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now