AnsweredAssumed Answered

OLEDB schema

Question asked by Ron_L on May 1, 2016
Latest reply on May 3, 2016 by Ron_L

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
someTable

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?

Thank You

Outcomes