3 Replies Latest reply on Jan 15, 2015 2:45 PM by tdanner

    Help with SWQL query for getting Nodes.CPULoad value out of TriggerQuery table in a filter.

    kbailey@tivo.com

      I want to put into the trigger action notification as a variable; in this case I want the Nodes.CPULoad 95 out of the TriggerQuery. Can you do it with SWQL query?

       

      SELECT TriggerQuery FROM Orion.AlertDefinitions WHERE Name = '_IT-Windows_CPU_CRITICAL_24x7'

       

      Output:

       

      SELECT DISTINCT Nodes.NodeID AS NetObjectID, Nodes.Caption AS Name

      FROM Nodes

      WHERE 

      (

        (Nodes.Status <> '2') AND

        (Nodes.SystemOwner = 'IT-Windows') AND

        (Nodes.BusinessCriticality = '24x7') AND

        (Nodes.CPULoad >= 95)

      )