Ethernet Cards

[Srikanth08]

Hi,

How to find two Ethernet cards that is wireless cards installed in a computer? i want that query to find

[Hemoco]

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