AnsweredAssumed Answered

Good way to copy Events into Event Frames? (from a non-pi system)

Question asked by ryland Champion on May 26, 2015
Latest reply on Jun 10, 2015 by pthivierge

We have a system where we monitor, categorize and track downtime events on manufacturing equipment. It is a SQL based system and   I can easily write a T-SQL query to give me a list of events, their start times, end-times, reasons and catagories.  Is their a good way to use this information to create event frames in AF?  I was hoping it would be as easy as writing a query using PI Enterprise OLEDB to create the eventframes, but the documentation that I've looked at so far didn't have any examples for creating event frames using the OLEDB tools.

 

I would prefer to have the system where downtimes are created to be authoritative.  By this I don't want to try and recreate the logic that we are using to monitor and capture the downtime, using the eventframes generator.

Outcomes