Querying Orion.Events

svindler

Can anyone confirm whether this looks like a reasonable way to query for all events belonging to the devices named 'TIA_RT%'

select caption, eventtime,message from orion.events as ev, orion.nodes as n where networknode=n.nodeid and caption like 'TIA_RT%' order by eventtime

tdanner

Looks fine to me. You might want to put a TOP clause or a condition on the EventTime to avoid returning too many events.