1
select `ave`.`ComputerID` AS `ComputerID`,(select `labtech`.`plugins`.`Name` from `labtech`.`plugins` where (`labtech`.`plugins`.`GUID` = `avt`.`AvPluginGUID`)) AS `AVProductName`,`ave`.`AVThreatID` AS `AVThreatID`,ifnull(`avtl`.`ThreatName`,'Unknown') AS `ThreatName`,ifnull(`avtl`.`ThreatDescription`,'No Description') AS `ThreatDescription`,`ave`.`ThreatStart` AS `ThreatStart`,`ave`.`ThreatEnd` AS `ThreatEnd`,`ave`.`ThreatLevel` AS `ThreatLevel`,`ave`.`ThreatType` AS `ThreatType`,`ave`.`ThreatTarget` AS `ThreatTarget`,`ave`.`ThreatPath` AS `ThreatPath`,trim(`avt`.`ActionTaken`) AS `ActionTaken` from ((`labtech`.`v_ltcr_avthreats` `ave` join `labtech`.`antivirusthreats` `avt` on((`ave`.`FoundThreatID` = `avt`.`FoundThreatId`))) left join `labtech`.`antivirusthreatlookup` `avtl` on((`ave`.`AVThreatID` = `avtl`.`AvThreatId`))) order by `ave`.`ComputerID`,`ave`.`AVThreatID`,`ave`.`ThreatStart`