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.


      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'




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

      FROM Nodes



        (Nodes.Status <> '2') AND

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

        (Nodes.BusinessCriticality = '24x7') AND

        (Nodes.CPULoad >= 95)