1 Reply Latest reply on Aug 8, 2017 6:38 AM by venh.123

    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?

        • Re: SQL Query to get Top 10 Processes
          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?