Hi everyone I wrote a custom table plugin that s working wit

Question

Hi everyone I wrote a custom table plugin that s working with osqueryi locally but fleet is failing to query that table returns 0 results says 1 failed What s the best way to debug this

zwass · Answer

Live query `select from osquery extensions` to see if your extension is loaded

grant seltzer · Answer

I do see it loaded properly

grant seltzer · Answer

Using that query

grant seltzer · Answer

I also tried doing the auto table construction option and the results from those tables don t work either

grant seltzer · Answer

i e <https blog kolide com build custom osquery tables using atc ab112a30674c>

grant seltzer · Answer

Does fleet have to know about the schema of these tables somehow

zwass · Answer

Nope fleet just sends the query to osquery

zwass · Answer

You can use ` verbose tls dump` with osquery to see what they are sending each other

grant seltzer · Answer

Hm yea I do get log message for ` NewDistributedQueryCampaign `

grant seltzer · Answer

and the query is correct but no error messages

grant seltzer · Answer

I just get the 1 Failure in the UI

grant seltzer · Answer

Should the auto tables show up as a result in `osquery registry`

grant seltzer · Answer

They don t although the custom extension one does

zwass · Answer

That I don t know Maybe try another channel if Fleet is sending the correct query but osquery is not returning results

grant seltzer · Answer

Got it thank you for your help

zwass · Answer

What was the issue