0 Replies Latest reply on Oct 23, 2016 3:51 AM by rzkoohi

    sql query to swql

    rzkoohi

      hi everyone

      i want to make a simple sql query to work in custom query in orion

      here is sql query:

       

      select Events.EventTime, NodesData.Caption, NodesData.Status

      from Events

      join NodesData

      on events.Message like 'anbar3 has stopped responding (Timeout)'

      order by Events.EventTime desc

       

      i tried many ways and still cant figur it out how to write it in solar.

      any ideas?