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

    chr@draware.dk

      CAN ANYONE HELP ME OUT PLEASE?

       

      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