1
select sql_no_cache `labtech`.`inv_networkcard`.`ComputerID` AS `computerid`,`labtech`.`inv_networkcard`.`AdapterType` AS `AdapterType`,ifnull(`labtech`.`inv_devices`.`Name`,'') AS `AdapterName`,`labtech`.`inv_networkcard`.`IPAddress` AS `IPAddress`,`labtech`.`inv_networkcard`.`Gateway` AS `Gateway`,`labtech`.`inv_networkcard`.`MAC` AS `Mac`,`labtech`.`inv_networkcard`.`NetMask` AS `NetMask`,`labtech`.`inv_networkcard`.`IPv6` AS `IPv6`,`labtech`.`inv_networkcard`.`Status` AS `Status`,`labtech`.`inv_networkcard`.`Speed` AS `Speed`,`labtech`.`inv_networkcard`.`Description` AS `Description`,`labtech`.`inv_networkcard`.`BytesRec` AS `BytesRec`,`labtech`.`inv_networkcard`.`BytesSent` AS `BytesSent`,`labtech`.`inv_networkcard`.`PnPDeviceID` AS `PNPDeviceID`,ifnull(`labtech`.`inv_devices`.`DeviceType`,'') AS `DeviceType`,ifnull(`labtech`.`inv_devices`.`DriverVersion`,'') AS `DriverVersion`,ifnull(`labtech`.`inv_devices`.`DriverDate`,'') AS `DriverDate`,ifnull(`labtech`.`inv_devices`.`DriverName`,'') AS `DriverName`,ifnull(`labtech`.`inv_devices`.`DriverFile`,'') AS `DriverFile`,ifnull(`labtech`.`inv_devices`.`Manufacturer`,'') AS `Manufacturer` from (`labtech`.`inv_networkcard` left join `labtech`.`inv_devices` on(((`labtech`.`inv_devices`.`ComputerID` = `labtech`.`inv_networkcard`.`ComputerID`) and (`labtech`.`inv_devices`.`PNPDeviceID` = `labtech`.`inv_networkcard`.`PnPDeviceID`))))