v_ltcr_avthreats

select `labtech`.`antivirusthreats`.`ComputerId` AS `ComputerID`,`labtech`.`antivirusthreats`.`AvThreatId` AS `AVThreatID`,`labtech`.`antivirusthreats`.`ThreatLevel` AS `ThreatLevel`,`labtech`.`antivirusthreats`.`ThreatType` AS `ThreatType`,`labtech`.`antivirusthreats`.`ThreatTarget` AS `ThreatTarget`,`labtech`.`antivirusthreats`.`ThreatPath` AS `ThreatPath`,min(`labtech`.`antivirusthreats`.`DateOccurred`) AS `ThreatStart`,max(`labtech`.`antivirusthreats`.`DateOccurred`) AS `ThreatEnd`,max(`labtech`.`antivirusthreats`.`FoundThreatId`) AS `FoundThreatID` from `labtech`.`antivirusthreats` group by `labtech`.`antivirusthreats`.`ComputerId`,`labtech`.`antivirusthreats`.`AvThreatId`,`labtech`.`antivirusthreats`.`ThreatLevel`,`labtech`.`antivirusthreats`.`ThreatType`,`labtech`.`antivirusthreats`.`ThreatTarget`,`labtech`.`antivirusthreats`.`ThreatPath`