1
select sql_no_cache `labtech`.`inv_processor`.`ComputerID` AS `computerid`,`labtech`.`cim_processorfamily`.`Value` AS `CPU`,0 AS `Architecture`,`labtech`.`inv_processor`.`Speed` AS `ClockSpeed`,if((`labtech`.`inv_processor`.`64bit` = 1),64,32) AS `Bits`,`labtech`.`inv_processor`.`Family` AS `Family`,`labtech`.`inv_processor`.`L1Cache` AS `CacheSize`,`labtech`.`inv_processor`.`Manufacturer` AS `Manufacturer`,`labtech`.`inv_processor`.`SerialNumber` AS `Serial`,`labtech`.`inv_processor`.`Socket` AS `Socket`,`labtech`.`inv_processor`.`Enabled` AS `Enabled`,`labtech`.`inv_processor`.`L2Cache` AS `L2Cache`,`labtech`.`inv_processor`.`L3Cache` AS `L3Cache`,`labtech`.`inv_processor`.`PartNumber` AS `PartNumber`,`labtech`.`inv_processor`.`Cores` AS `Cores`,`labtech`.`inv_processor`.`Threads` AS `Threads`,`labtech`.`inv_processor`.`64bit` AS `64bit`,`labtech`.`inv_processor`.`DEP` AS `DEP`,`labtech`.`inv_processor`.`Virutalization` AS `Virtualization`,`labtech`.`inv_processor`.`PowerControl` AS `PowerControl`,`labtech`.`inv_processor`.`HardwareThread` AS `HardwareThread`,`labtech`.`inv_processor`.`ProcessorHandle` AS `ProcessorHandle`,`labtech`.`inv_processor`.`Name` AS `Name` from (`labtech`.`inv_processor` join `labtech`.`cim_processorfamily` on((`labtech`.`inv_processor`.`Family` = `labtech`.`cim_processorfamily`.`ID`))) where (`labtech`.`inv_processor`.`Enabled` = 1)