Kaseya Community

SQL Query to find unhealed threats

  • Has anyone figured out where open threats from AVG are stored in the Database?  I am pretty sure I've got active threats handled with KAV and KAM, but I'm struggling to find KES threats.  I see the table AVAlertlog has what appears to be the Alarm that comes from an unhealed threat, but I'm not confident that this is the table I should be scouring.  Initially I only want to see any threats that weren't taken care of, but once I have that, I might also want to collect the last 30 days of history for reporting purposes.



  • Hi..

    did you ever get anywhere with this? dbo.AVHistoricalThreat seems to be the place to look - look for Quarantined column != 1 ?