So we are new to PI. We have installed RQTP Data Engine and I can query through SQL Client to get values from AF database. How do I use PI SQL Client to query tags that are not in the AF but are solely in ... Hi Everyone, We have been using PI JDBC to retrieve data from PI AF via DAS into R. Everything is working great until one of the function's table in an AF database becomes invalid (e.g. due to amendment/remova... Hi， I always report errors when inquiring with ODBC "select * FROM piarchive..piinterp WHERE tag='xxx' and time between '2019-09-06' and '2019-09-09' " Or&... To get all milliseconds interval data from query. For eg: I want to fetch data of time '2018-07-26 07:15:00.543' But when i try to execute query : SELECT tag, time, DIGSTRING(CAST(status AS Int32)) digsta... Hi Everyone, I really need help! I am very new to this and spent very long time with no success yet. I need to retrieve data from the archive editor in the PI System Management Tools. I want to be able to upd... Hello, I'm trying to do what Ithought was a simple query but I've already spent way to much time trying to get it to work. I feel like I'm just running into a syntax problem and am hoping to get some help with ... We have a day and a half gap for 2800 tags. I was asked to read the data from PHD and write to PI. I am using a Python script to get the data for each tag (iterate through list of tags) then write it to PI. The data w... Hi, I need help to find a way to efficiently get the last value of a two AF attributes (PI tags) before a given point in time, i.e. I want to get the PrevVal for a set of AF Attributes The constraints are I... Hi I am using PI Datalink with “Calculated Data in max mode” and have it set up as follows Data Item = ‘Tag name’ Start Time = today End time = -1year Mode = Max ... Im not sure if its because osisoft have changed their landing page, but i cannot find the customer portal log in url . Can someone please post a link thank you Hi, Do there exist some kind of overview on which versions of PI JDBC Driver is compatible with which version of Java (Java 8, Java 11 etc)? Thanks, Erik pi jdbc driver java Hello, I am having trouble trying to figure out how to get one-minute average values once an hour. Specifically I'm hoping to extract a one minute average from 18 after the top of the hour each hour (at 09:18, ... Hi PI Friends. I have a question. How I can to generate a SQL query in order to consume the data of event frames directly from AF database? I need event frames name, startime, endtime, duration, and the rest o... Hello Everyone! I need to install PI OLEDB ENTERPRISE 2017 R2, I have search in product list but I couldn't see install KIT separately, also this is not included in AF service 2017 R2 update, please check... I'm using pi sql commander but I'm not sure if this is the best solution. But I'm having timeout issues because of the large amount of records Here is an sample query I'm using in Pi SQL Commander. It is an insert wi... Hi I have a Linked Server built in SQL Server, which I am using to run queries on piarchive, however the connection fails intermittently with the error: "OLE DB provider "PIOLEDB" for linked server "WI... We have had this job running for over two years now but suddenly I am getting this error and job is failing. OLE DB provider "PIOLEDB" for linked server "xxxxx" returned message "Timeout has expired.". Msg 732... Hola, he intentado utilizar los datos de un PI Server desde un servidor web en Centos 7 y no he logrado la conexión. Así retomando el caso lo que necesito hacer es realizar una conexión utiliz... I'm looking for the syntax to SUM a TAG given a Start and End date time... (pi oledb) I have tried, I have come the conclusion that I have just lost my mind.. help please.. Daniel.