1
select `cmp`.`ComputerID` AS `ComputerID`,`cmp`.`ClientID` AS `ClientID`,`cli`.`Name` AS `Client_Name`,`cli`.`Company` AS `Client_Company`,`loc`.`Name` AS `Location_Name`,`cmp`.`LocationID` AS `LocationID`,`cmp`.`Name` AS `Computer_Name`,`cmp`.`Domain` AS `Domain`,`cmp`.`Username` AS `UserName`,`cmp`.`OS` AS `OS`,`cmp`.`Version` AS `OS_Version`,`cmp`.`BiosName` AS `BiosName`,`cmp`.`BiosVer` AS `BiosVer`,`cmp`.`BiosMFG` AS `BiosMFG`,`cmp`.`BiosFlash` AS `BiosFlash`,`cmp`.`TimeZone` AS `TimeZone`,`cmp`.`CPUUsage` AS `CPUUsage`,`cmp`.`LocalAddress` AS `LocalAddress`,`cmp`.`RouterAddress` AS `InternetAddress`,`cmp`.`flags` AS `Flags`,`cmp`.`UpTime` AS `UpTime`,`cmp`.`tempfiles` AS `TempFiles`,`cmp`.`TotalMemory` AS `SystemMemory`,`cmp`.`MAC` AS `MAC`,`cmp`.`ServiceVersion` AS `ServiceVersion`,`cmp`.`LastContact` AS `LastContact`,`labtech`.`proc`.`CPU` AS `CPU`,`labtech`.`proc`.`ClockSpeed` AS `ClockSpeed`,`labtech`.`proc`.`Family` AS `Family`,`labtech`.`proc`.`Manufacturer` AS `CPUMFT`,`labtech`.`proc`.`Serial` AS `CPU_Serial`,count(distinct `labtech`.`proc`.`ProcessorHandle`) AS `ProccessorCount`,`labtech`.`vid`.`VideoCard` AS `VideoCard`,`cmp`.`RouterAddress` AS `RouterAddress` from ((((`labtech`.`computers` `cmp` join `labtech`.`clients` `cli` on((`cli`.`ClientID` = `cmp`.`ClientID`))) join `labtech`.`locations` `loc` on((`loc`.`LocationID` = `cmp`.`LocationID`))) left join `labtech`.`v_processors` `proc` on((`labtech`.`proc`.`computerid` = `cmp`.`ComputerID`))) left join `labtech`.`v_videocards` `vid` on((`labtech`.`vid`.`computerid` = `cmp`.`ComputerID`))) group by `cmp`.`ComputerID`