Channels
doorman
zercurity
infrastructure
code-review
queryhub
apple-silicon
carving
goquery
aws
querycon
golang
file-carving
fuzzing
help-proxy
darkbytes
process-auditing
general
windows
random
fleet-dev
tls
fim
awallaby
zentral
zeek
auditing-warroom
linen-dev
fleetosquery
plugins
jobs
arm-architecture
uptycs
android_tests
selfgroup
vendor-feeds
fleet
eclecticiq-polylogyx-extension
ebpf
website
core
macos
kolide
osctrl
extensions
foundation
sql
officehours
linux
community-feeds
Powered by
#sql
Title
# sql
w
Will Sheldon
10/27/2021, 8:57 PM
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
s
seph
10/27/2021, 9:10 PM
Osquery itself operates on a single host. You'd need to do correlation in whatever processes your logs. Which might not be sql
w
Will Sheldon
10/27/2021, 9:26 PM
What would be the best table to do that correlation?
s
seph
10/27/2021, 9:36 PM
Probably logged_in_users
z
zwass
10/27/2021, 10:31 PM
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.
7 Views
Post