you might already know it but, to test in

osqueryi

you will have to issue the query yourself, I believe it does not run the scheduled query