Need to do a very simple query from a PI Archive over OLEDB,
need to query recorded values by PI Tag and data range. Something like:
select value where PITag=’mytag’
and time < ‘1/1/2015 23:59:59’ and time > ‘1/1/2015 00:00:00’ from
I have successfully install the OLEDB client and PI SQL
Commander Lite, however, I cannot find any documentation on the schema
presented for “PI Servers”. I am guessing these tables are wrappers around some
older API’s like DataLink or PI SDK, however, the documentation library does
not appear to have those documents.
Can somebody point me to the documentation for the schema or
the underlying API?