‎09-04-2008 04:29 PM
‎12-02-2008 11:24 PM
‎09-04-2008 06:25 PM
‎09-04-2008 06:19 PM
‎09-04-2008 05:11 PM
‎09-04-2008 04:59 PM
SELECT dbo.tblComputers.Computername, dbo.tblNetwork.IPAddress, dbo.tblNetwork.IPSubnet
FROM dbo.tblComputers INNER JOIN
dbo.tblNetwork ON dbo.tblComputers.Computername = dbo.tblNetwork.Computername
WHERE (dbo.tblNetwork.IPAddress <> '') AND (dbo.tblNetwork.IPAddress <> '0.0.0.0')
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now