| installed_homebrew_packages_1 | SELECT name, version from homebrew_packages order by name limit 25; | 14400 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
, you don't actually have any queries scheduled. You'd also have to pass a config file with the scheduled queries to osqueryi (or tls config) and wait for it to execute those queries before you get data on scheduled query execution.
osqueryi --json "select * from osquery_schedule;"
sudo osqueryi --profile 2 --profile-delay 1 "select * from users;" --json
after grepping for
such that you could inspect the runtime status of an
osqueryi --connect /path/to/osqueryd/extension/socket.em
process. It sounds like that would be helpful here.