AnsweredAssumed Answered

How to add eventframe attributes into SQL view

Question asked by AKASH MISAL on May 2, 2018
Latest reply on May 3, 2018 by AKASH MISAL

Hello Everyone!

 

I am working on Event Frames (AF 2016 R2) and I have created view into PI SQL commander as shown in below picture, right now I am getting output into view is "Event Name" , "Start time" and "End time".

 

Now I need event frame attributes into same view, how would I get other attributes into view. I know for this I need to join two tables into this view but where I would get event frames attributes, please check below query which I have used in view.

 

 

 

 

Regards,

Akash.

Outcomes