hey everyone, I want to write a query on windows device that can show me the percentage of processes in CPU , dose someone have any query to recommend on?
r
Rachel Perkins
06/15/2021, 2:54 PM
I'm not quite sure what you're asking for. There's only a handful of percent columns on https://osquery.io/schema/4.8.0/#processes so maybe a quick command+f might help?
z
Zach Zeid
06/15/2021, 5:00 PM
This could be better answered in either #general or in #sql
c
clong
06/15/2021, 5:15 PM
@abraham linkolan so this is actually a tough problem with osquery. I’ve built a query that shows me what % of CPU cycles have been consumed by a process since booting, but not a realtime snapshot like “at 11:30 slack was using 15%”