‎07-15-2009 09:48 PM
‎07-15-2009 10:55 PM
SELECT dbo.tblComputers.Computername, dbo.tblOperatingsystem.Version, dbo.tblOperatingsystem.SerialNumber,
dbo.tblADComputers.OperatingSystemServicePack, dbo.tblADComputers.OperatingSystem, dbo.tblComputers.Username
FROM dbo.tblComputers LEFT OUTER JOIN
dbo.tblOperatingsystem ON dbo.tblComputers.Computername = dbo.tblOperatingsystem.Computername LEFT OUTER JOIN
dbo.tblADComputers ON dbo.tblComputers.Computername = dbo.tblADComputers.Computername
‎07-15-2009 10:38 PM
‎07-15-2009 10:37 PM
‎07-15-2009 10:36 PM
‎07-15-2009 10:12 PM
‎07-15-2009 10:04 PM
SELECT dbo.tblComputers.Computername, dbo.tblOperatingsystem.Version, dbo.tblOperatingsystem.SerialNumber,
dbo.tblADComputers.OperatingSystemServicePack, dbo.tblADComputers.OperatingSystem, dbo.tblComputers.Username
FROM dbo.tblComputers INNER JOIN
dbo.tblOperatingsystem ON dbo.tblComputers.Computername = dbo.tblOperatingsystem.Computername INNER JOIN
dbo.tblADComputers ON dbo.tblComputers.Computername = dbo.tblADComputers.Computername
‎07-15-2009 10:01 PM
‎07-15-2009 09:59 PM
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now