of the users mouse activity? applications? or just...
# linuxh
Hugh (Zercurity)
07/10/2020, 11:11 AMof the users mouse activity? applications? or just general system CPU usage?
b
binu
07/10/2020, 6:44 PMFor users mouse activity ,and application
h
Hugh (Zercurity)
07/10/2020, 6:49 PMsorry, couldn't help you with that use case.
b
binu
07/12/2020, 9:22 AMOk thanks
binu
07/15/2020, 4:14 PMMachine active/inactive(idle) times query available in osquery ?
h
Hugh (Zercurity)
07/15/2020, 4:15 PMSELECT (SUM(user) + SUM(nice) + SUM(system) + SUM(idle) * 1.0) AS tsb, SUM(COALESCE(idle, 0)) + SUM(COALESCE(iowait, 0)) AS itsb FROM cpu_time;Hugh (Zercurity)
07/15/2020, 4:16 PMfull example in the link to medium I posted
Hugh (Zercurity)
07/15/2020, 4:17 PMthough you will have to run this query periodically to check the difference in times. In order to correctly calculate usage.
b
binu
07/15/2020, 4:36 PMOk thanks for your help