That's not what scripting is for, it is single threaded and can be aborted by another scripting running.   What is the SQL doing/showing? If you're referencing database objects and include the id field the row content should update automatically. If its a data table/grid then it won't auto update.     ... View more

\n works in the column header, not the content, e.g.   SELECT 'Hello' || '\n' || 'Bevan' FROM CROOTGROUP   Can't work it out either, pretty sure you used to be able to do something. $n is for logic (and tooltips apparently) ... View more

Also worth noting that with services like Twilio its pretty straightforward to write a driver to interface with it using JSON or some libraries, I think Steve posted some code on his gitlab page.   Whilst calling an exe may work, a better integration will give you feedback such messages sent, read and if they reply. ... View more

No simple way, typically I do what you propose and query each table and union them all together. I once tried to write a program to find all fields call "Severity" and auto generate some SQL but I don't think I ever finished it.   The way the ClearSCADA database is structured does make some thing much easier... however in cases such as this it can be unhelpful. ... View more

Yeah, but then on the high tuned systems you had the impact of cache thrashing, so do you go more cores are lower performance or less cores with better performance. I don't miss those days, much easier now!   I did have a build from 2002 saved once with intentions of running it up in the future, but the NAS it was on failed so I lost it. ... View more

One of the drivers behind channel to OS ratio in the past was the number of cores in the server. A channel is a thread in the driver, so the more channels the more threads.   In the past with slow processors and limited processing cores having hundreds or thousands of threads was a significant performance hit as threads all competed for a time slice. I first ran a production version of ClearSCADA (SCX6) on a PIII-450MHz and then it was really important to get it right as that machine would get hammered with comms and be unusable if things were wrong.   These days, along with the new async processing, I doubt it really matters and the focus can be on other things. The only impact I syspect will be on virtual/cloud systems where the number of cores can have a direct impact on cost so the less cores needed the lower the hosting costs. ... View more

Yeah, what Bevan said 🙂   Regarding validating ClearSCADA (and anything else on the system you may manage) I don't think you should be checking the product as such, you should be checking your domain logs to see what is triggering any entry. That last link has info on what logging you need to set (not enabled by default) and then what to parse in your domain logs to identify sources.   For example some network devices, PLCs and RTUs support LDAP authentication and may be affected if not using SSL/TLS.   The logging only appears every 24 hours so its a case of set it going and wait a day or two. ... View more

Probably need a IANACSD (ClearSCADA developer) disclaimer here 🙂   Database consistency is king, but in my head linked tables may not fit under that strict consistency rule so maybe they could modify the logic engine to be outside of a lock. It probably adds a new dynamic here with asynchronous execution, you need to hold up the logic until query has returned and a database lock is a "simple" method to achieve that.   Would they allow other logic to run in the mean time? What happens when a backlog happens? Logic is designed to be quick, efficient and predictable and if they were to implement something like this is can see a knock-on effect that could be quite problematic for both developers and users.   18 odd years ago there was a registry setting to control how many threads there were for logic, but that got removed and I can only speculate it was to help with the whole database consistency, although back then testing to see if made a difference was a lot harder.   I couldn't see any requests for this in the issue system, so you may want to officially request via support. ... View more