Osquery uses basic SQL commands to leverage a relational data-model to describe a device.

osquery

Hey y'all, if anyone is wondering what new features are coming in osquery 4.2.0, I've got a post with demonstrations of all of them:
<https://www.dactiv.llc/blog/new-in-osquery-4.2/>

Nice. THough the coloring on <https://www.dactiv.llc/blog/new-in-osquery-4.2/#community_id_v1> looks suspect

Yeah the coloring is all wrong for sure. Not really sure the best way to handle it. I like colors though.

I keep trying to read the orange as the new stuff.

I was actually contemplating how to do community ID with some sort of post processing

what does community id mean in osquery-land?

<@UNNGYHBE1> As mentioned in the changelog, and that blog post, it’s an implementation of <https://github.com/corelight/community-id-spec>

Its a really easy way of correlating network flows to each other. In the context of osquery, you can look at a socket and correlate it to a PID/UID. But also correlate it to network forensics/alerting like Snort/Suricata/Bro/Zeek.