Title
#general
Dan Achin

Dan Achin

11/11/2020, 9:42 PM
Is there a trick to being able to look at osquery schedule data using osqueryi? We are writing our results to Fleet, then to Splunk so I know we have the data, but osqueryi does not return data when running
SELECT * FROM osquery_schedule;
Is this by design and how can I look at the schedule data from the interactive shell?
zwass

zwass

11/11/2020, 9:48 PM
You can't. This is by design, but not intentional. The schedule information is stored in rocksdb and only one process can have this open at a time. The best way to address this is to live query or schedule a query for the
osquery_schedule
table.
Dan Achin

Dan Achin

11/11/2020, 10:06 PM
got it, thanks. are there other tables where this is true @zwass?
zwass

zwass

11/11/2020, 10:08 PM
Yes, any event-based tables (_events)
Dan Achin

Dan Achin

11/11/2020, 10:11 PM
got it, thanks
theopolis

theopolis

11/12/2020, 12:45 AM
I’ve always wanted a feature to do this type of “debugging” with osqueryi