cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Srikanth08
Engaged Sweeper II
Hi,

How to find two Ethernet cards that is wireless cards installed in a computer? i want that query to find
Regards, Srikanth08
1 REPLY 1
Hemoco
Lansweeper Alumni
Please try the report below.
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

New to Lansweeper?

Try Lansweeper For Free

Experience Lansweeper with your own data.
Sign up now for a 14-day free trial.

Try Now