1 Reply Latest reply on Sep 24, 2013 7:06 AM by njoylif

    Using SQL Statements to reference specific fields in the database for advanced alerts




      I'm trying to reference the following unique fields in AlertStatus table to forward when I send an alert:


      AlertDefID, TriggerTimeOffset


      Using i.e. ${AlertStatus.AlertDefID} does not seem to work and I cannot figure out what to put in an

      SQL statement as something like "“${SQL:Select * From AlertStatus where NodeID = ${NodeName}}”…" does not seem to work.


      I'm trying to parse information to a helpdesk system that allows me to reference a unique record back from the helpdesk system

      into the Orion database to populate the field Notes with the ticket ID from the help desksystem.


      Also, when were on the subject, what is the difference between the fields Notes and AlertNotes in the Orion DB