osQuery Management Server (Prime).Osquery Antivirus Status (SQLite SQL Statements)

SELECT score FROM (SELECT case when COUNT(*) = 2 then 1 ELSE 0 END AS score FROM processes WHERE (name = 'clamd') OR (name = 'freshclam')) WHERE score == 1;