Say I wanted to write a detection for "one user logged into 10k hosts at one time over SSH", how would I do that in OSQuery? • https://osquery.io/schema/5.0.1/#logged_in_users • https://osquery.io/schema/5.0.1/#users

Osquery itself operates on a single host. You'd need to do correlation in whatever processes your logs. Which might not be sql

What would be the best table to do that correlation?

Probably logged_in_users

Would be interesting to see an example of how to do this in a Spunk/ELK/Panther setup. Osquery can definitely generate the logs.

user_events

could also be useful.