REVIEWED by Sophos
Been playing with live discover, which seems to be all I'm doing at the moment, it's a little addictive! Anyway wrote a simple query to collect the most active processes on devices. Unlike the cpu_time table, this query will work on Windows as well as Mac and Linux > So should be good for the entire estate!
SELECT p.name AS Name, p.pid AS ProcessID, p.uid, u.username AS Username, printf("%.2f", ((p.user_time + p.system_time) / (process_cpu_time.total_cpu_usage)) * 100) || "%" AS CPU_Percentage_WeightedFROM processes p, ( SELECT (SUM(user_time) + SUM(system_time) * 1.0) AS total_cpu_usage FROM processes ) AS process_cpu_timeJOIN users u ON p.uid = u.uidORDER BY p.user_time+p.system_time DESCLIMIT "$$Number of Processes to Show$$";
There's a variable call $$Number of Processes to Show$$ which limits the top number of processes returned. I'd recommend something less than 10
$$Number of Processes to Show$$