is there any difference in the queries for policies and live queries?(i assume no) I am running a query to remove certain test hosts from a policy and the host keeps showing up. when i run a live query, it does not show but when i run the same query in the policy editor, the host "penguin" keeps showing as a failed policy. Do i need to save and let the policy run again to clear previous results? is there a better way to do this rather than join these tables? i tried doing via the uuid thinking maybe it was a hidden attribute since the host name always shows in the results for any table. thanks in advance for any assitance
SELECT * FROM deb_packages
full outer join system_info
WHERE system_info.hostname not like 'penguin' AND name LIKE 'REDACTED_DEB_NAME...' AND status='install ok installed'
limit 1;