Title
#general
Ayan

Ayan

10/09/2020, 4:48 PM
Hey all, I have been actively working with osquery and Kolide for over a few months now and I have come here multiple times for doubts and discussions. I want to thank you all especially @zwass, @seph and @fritz. To contribute back to the community I have a couple of custom osquery extensions, I just wanted to ask if custom tables are accepted as contributions or not.
zwass

zwass

10/09/2020, 4:50 PM
Thanks! We're glad to have you. It sounds like you are referring to tables you have implemented outside the osquery C++ codebase?
Ayan

Ayan

10/09/2020, 4:52 PM
yes. I am working on designing custom osquery tables using osquery-python, for which I have recently submitted a blueprint as well.
s

seph

10/09/2020, 4:53 PM
Aw, thanks for the shoutout!
4:53 PM
It’s great to have more people involved in osquery
zwass

zwass

10/09/2020, 4:53 PM
We don't have any way to bring extension tables into the osquery codebase, but we certainly encourage you to share those publicly any way you see fit. We also see extension tables as an opportunity to try out ideas before possibly implementing them in core osquery.
4:54 PM
I'm always happy to give a shout-out on Twitter if you build something cool you'd like to publicize.
s

seph

10/09/2020, 4:55 PM
Generally speaking, there aren’t central repositories of extensions. As Zach says, we encourage people to share things via github. Sometimes there’s interest in moving a table into core. Of if you’re working a lot with launcher (kolide’s endpoint agent), sometimes I’ll accept go based tables there. But both of these projects have their own criteria for acceptance.
Ayan

Ayan

10/09/2020, 5:05 PM
Thank you both. I have a custom table that collects outstanding/pending security updates on Debian systems which I think could be helpful to the community. I'll publish it on my git then!
r

Ryan

10/09/2020, 5:17 PM
sounds good!
zwass

zwass

10/09/2020, 5:19 PM
Certainly sounds like a very useful table! I'd be interested in seeing it in core assuming the functionality can be provided without shelling out to other tools. Will be curious to see your implementation.
Ayan

Ayan

10/09/2020, 5:25 PM
Thanks. Essentially it is an osquery wrapper around a debian command with some regex to feed the output into the table. It does require osquery python module but that is just it. With that out of the way, I use fleet to create a baseline on it and then get notified for every new entry=pending update.
s

seph

10/09/2020, 5:31 PM
Nice!
5:32 PM
IIRC that data is in some files somewhere, so you could imagine file parsing. But at least on ubuntu it’s also based on having an optional daemon running