SQL Query to get Top 10 Processes

venh.123

I know there are builtin resources which provide Top 10 Processes. Also, in alerts for High CPU and Memory, we can get this. However, I would like to know how to achieve this using SQL query. Can anyone please let me know the SQL query to achieve this on a node?

venh.123

Ok I got the query. But I am not sure, if this entry is made into the table, after the alert is triggered.

Select AlertNote from AlertObjects where RelatedNodeId = ${NodeID}

I want to get this detail before the alert is triggered, because, I want to include this information in the alert email. Can anyone please help further?