Testing out fleet using osquery-in-a-box and I’m noticing that some policies are showing an incorrect status. I only have one macOS device host currently, an example policy is

Automatic installation of operating system updates is enabled (macOS)

. How would I go about troubleshooting?

Hey @jamescapen! That query is set up assuming that the host is enrolled in MDM and has a policy that sets up Automatic Updates:

SELECT 1 FROM managed_policies WHERE domain='com.apple.SoftwareUpdate' AND name='AutomaticCheckEnabled' AND value=1 LIMIT 1;

If you aren’t using MDM/aren’t using a profile to enforce that setting, you’ll need to tweak the query a bit to actually check the current setting instead.