1
select `lhr`.`TargetId` AS `ComputerID`,`lhr`.`DateGenerated` AS `HealthCheckDateGenerated`,`hc`.`CheckName` AS `HealthCheckName`,`hc`.`CheckCategoryId` AS `HealthCheckCategorySort`,`hc`.`CheckOrder` AS `HealthCheckSort`,elt(`hc`.`CheckCategoryId`,'Performance','Stability','Security') AS `HealthCheckCategory`,`hc`.`CheckDescription` AS `HealthCheckDescription`,`lhr`.`HealthScore` AS `HealthCheckScore`,`lhr`.`HealthMaxScore` AS `HealthCheckScoreMax`,`lhr`.`HealthMessage` AS `HealthCheckMessage`,`hr`.`HealthCalculation` AS `HealthCalculation`,`lhr`.`HealthCheckGuid` AS `HealthCheckGUID` from ((`labtech`.`plugin_sap_latesthealthresults` `lhr` join `labtech`.`plugin_sap_healthresults` `hr` on(((`lhr`.`TargetType` = `hr`.`TargetType`) and (`lhr`.`TargetId` = `hr`.`TargetId`) and (`hr`.`HealthCheckGuid` = `lhr`.`HealthCheckGuid`) and (`lhr`.`DateGenerated` = `hr`.`DateGenerated`)))) join `labtech`.`plugin_sap_healthchecks` `hc` on((`hr`.`HealthCheckGuid` = `hc`.`HealthCheckGuid`))) where (`lhr`.`TargetType` = 1)