Title
#fleet
a

abraham linkolan

06/15/2021, 11:00 AM
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?
Rachel Perkins

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
clong

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%”
5:16 PM
so if you use “slack” as an example and it returns
18
, it means since booting slack has used up 18% of all CPU cycles
a

abraham linkolan

06/16/2021, 6:12 AM
can you send it anyway ? until now i did a query that show only how much ram is used