2. Display the name of all processes running on the current Prognosis node without repetition
SELECT ProcessName FROM NtProcess GROUP BY ProcessName
3. Display the busiest Prognosis process in all Prognosis nodes, showing the node name, Prognosis process name without the initial ‘ir’ (example: pqlsrv instead of irpqlsrv), and the busy percentage of the process.
SELECT TOP 1 Meta.Node, substring(ProcessName, 3), BusyPercent
WHERE ProcessName MATCHES 'ir*'
LIMIT 1 BY BusyPercent DESC
ORDER BY BusyPercent DESC
4. Display the busiest, excluding the idle process, and the least busy process in the current Prognosis node, with the busiest process in the first row and the least busy process in the second row. The first how must contain the text ‘Busiest’, followed by the process name and the busy percentage. The second row must contain the word ‘Least Busy’, followed by the process name and busy percent