I have a related question. I am using PI linked through the OLEDB driver to SQL and passing through queries in PI Syntax. How can one efficiently query the top of the hour value for all points? Can this be queried from one of the "tables" using a timestep of '1h'?
Thanks in advance.