AnsweredAssumed Answered

SQL queries to retrieve Event Frame data from PI

Question asked by Sriram_amirapu on Apr 18, 2019
Latest reply on Apr 19, 2019 by Sriram_amirapu


We want to retrieve Event Frames data with all tag values using SQL scripts. can you please suggest us the appropriate query or the procedure to get this. we have already got this data using 'Explore Events' function in PI DataLink.

Now we want the same to be shown in JMP software using SQL queries. we have established PI ODBC connection for this purpose using PI OLEDB Enterprise. so, the only thing is to run a SQL query to retrieve the Event Frame data into JMP software.

I have attached the screenshot of PI DataLink with Event Frame data. the same format should be applied to view the data in JMP using SQL queries.