@aldente my guess is you are not receiving any results because the query is running as the root user. Try it in

sudo osqueryi

and you'll see a warning (that warning is likely going to your status logs).