Subscribing is a smart move!
You can subscribe to this forum after you log in or create your free account.
Geo SCADA Knowledge Base
Access vast amounts of technical know-how and pro tips from our community of Geo SCADA experts.
Originally published on Geo SCADA Knowledge Base by sbeadle1 | June 09, 2021 08:48 PM
SCX:///main/List/Title="Events"&System="main"&InitialSQL="SELECT ""RecordTime"" AS ""~RecordTime"", ""Source"", ""Message"" FROM CDBEVENTJOURNAL WHERE ( ""~RecordTime"" BETWEEN{ OPC 'H-23H' }AND{ OPC 'H+1H' }) AND ( ""Source"" LIKE '%Group1%' ) ORDER BY ""~RecordTime"" DESC"
'SCX:///main/List/Title="Events"&System="main"&InitialSQL="SELECT ""RecordTime"" AS ""~RecordTime"", ""Source"", ""Message"" FROM CDBEVENTJOURNAL WHERE ( ""~RecordTime"" BETWEEN{ OPC ''H-23H'' } AND { OPC ''H+1H'' } ) AND ( ""Source"" LIKE ''%Group1%'' ) ORDER BY ""~RecordTime"" DESC"'
'SCX:///main/List/Title="Events"&System="main"&InitialSQL="SELECT ""RecordTime"" AS ""~RecordTime"", ""Source"", ""Message"" FROM CDBEVENTJOURNAL WHERE ( ""~RecordTime"" BETWEEN { OPC ''H-23H'' }AND{ OPC ''H+1H'' }) AND ( ""Source"" LIKE ''%' + StringParam.String + '%'' ) ORDER BY ""~RecordTime"" DESC"'
Create your free account or log in to subscribe to the forum - and gain access to more than 10,000+ support articles along with insights from experts and peers.