‎01-05-2010 04:07 PM
‎01-06-2010 04:17 PM
CREATE VIEW dbo.web30repOSwinXP
AS
SELECT TOP 100 PERCENT dbo.tblComputers.Computername AS Computer, dbo.tblOperatingsystem.Description, dbo.tblComputers.Domain,
dbo.tblOperatingsystem.Caption, dbo.tblOperatingsystem.Lastchanged
FROM dbo.tblOperatingsystem INNER JOIN
dbo.tblComputers ON dbo.tblOperatingsystem.Computername = dbo.tblComputers.Computername
WHERE (dbo.tblOperatingsystem.Version = '5.1.2600')
ORDER BY dbo.tblComputers.Domain
GO
‎01-06-2010 02:56 PM
‎01-05-2010 08:38 PM
‎01-05-2010 05:28 PM
‎01-05-2010 05:01 PM
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now