I am looking to query tag history aggregates in order to drop into a flat SQL table on specific events. The dynamic portion here is allowing users to dynamically choose what base tags get queried.
The time span for the tag history query can be capped at a few hours to limit load and the specific aggregates will also be limited.
My first thought is to run a gateway script tied to the specific events and query all the tags for a given event at once.
Another option would be to do this at the individual tag level possibly inside a UDT with a tag change script at the tag level.
There are probably lots of other options too so open to all ideas at this point.
Thanks