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.