3 Replies Latest reply on Oct 12, 2015 9:50 AM by jm_sysadmin

    Query SWQL Studio

    remi f

      Hi,

       

      I want to make a report which combines two queries together can anyone tell me if that is possible?

       

      These are the 2 querys:

       

      SELECT Name, Enabled, Trigger, Reset, TriggerSubjectTemplate, TriggerMessageTemplate, ResetSubjectTemplate, ResetMessageTemplate, LogMessage

      FROM Orion.Alerts

       

      SELECT Name, Description

      FROM Orion.AlertDefinitions

      I need this report to get a overall view of the name and description of an alert and what the messages are that will be triggered when.