1
select `hr`.`ClientID` AS `ClientID`,`hr`.`DateGenerated` AS `DateGenerated`,`hr`.`HealthCheckGuid` AS `HealthCheckGUID`,round(avg(((`hr`.`HealthScore` / `hr`.`HealthMaxScore`) * 100)),0) AS `StraightScore`,round(((sum(`hr`.`HealthScore`) / sum(`hr`.`HealthMaxScore`)) * 100),0) AS `WeightedScore` from (`labtech`.`plugin_sap_healthresults` `hr` join `labtech`.`plugin_sap_appliedhealthchecks` `ahc` on(((`hr`.`TargetType` = `ahc`.`TargetType`) and (`hr`.`TargetId` = `ahc`.`TargetId`) and (`hr`.`HealthCheckGuid` = `ahc`.`HealthCheckGuid`)))) where ((`hr`.`TargetType` = 1) and (`ahc`.`CheckEnabled` = 1) and (`hr`.`HealthCheckGuid` = '1750358c-8530-11e3-bd6a-001fd09ac72c')) group by `hr`.`ClientID`,`hr`.`DateGenerated`,`hr`.`HealthCheckGuid`