‎09-04-2012 03:41 PM
‎09-05-2012 03:32 PM
Select Distinct Top 1000000 tblComputers.Computername, tblComputers.Computer, tblComputers.Domain, Web40OSName.Compimage As icon, tblComputers.Lastseen, tblNetwork.Description, tblNetwork.IPAddress, tblNetwork.MACaddress, tblNetwork.DHCPenabled, tblNetwork.DefaultIPGateway, tblNetwork.DNSServerSearchOrder, tblNetwork.IPSubnet, tblNetwork.Lastchanged From tblComputers Inner Join Web40OSName On Web40OSName.Computername = tblComputers.Computername Inner Join tblNetwork On tblComputers.Computername = tblNetwork.Computername Order By tblComputers.Domain, tblComputers.Computer, tblNetwork.Description
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now