1
select `cmp`.`ComputerID` AS `ComputerID`,`cmp`.`ClientID` AS `ClientID`,`cmp`.`LocationID` AS `LocationID`,`cmp`.`Name` AS `ComputerName`,max(`avt`.`FoundThreatId`) AS `FoundThreatID`,`avt`.`AvThreatId` AS `AVThreatID`,ifnull(`avtl`.`ThreatName`,'Unknown') AS `ThreatName`,ifnull(`avtl`.`ThreatDescription`,'No Description') AS `ThreatDescription`,min(`avt`.`DateOccurred`) AS `ThreatStart`,max(`avt`.`DateOccurred`) AS `ThreatEnd`,`avt`.`ThreatLevel` AS `ThreatLevel`,`avt`.`ThreatType` AS `ThreatType`,`avt`.`ThreatTarget` AS `ThreatTarget`,`avt`.`ThreatPath` AS `ThreatPath`,trim(`avt`.`ActionTaken`) AS `ActionTaken` from ((`labtech`.`antivirusthreats` `avt` join `labtech`.`computers` `cmp` on((`avt`.`ComputerId` = `cmp`.`ComputerID`))) left join `labtech`.`antivirusthreatlookup` `avtl` on((`avt`.`AvThreatId` = `avtl`.`AvThreatId`))) group by `avt`.`ComputerId`,`avt`.`AvThreatId`,`avt`.`ThreatLevel`,`avt`.`ThreatType`,`avt`.`ThreatTarget`,`avt`.`ThreatPath`