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?
