osisoftpi-grafana icon indicating copy to clipboard operation
osisoftpi-grafana copied to clipboard

Features request : Event Frames with attibute value to a table

Open bujos opened this issue 9 months ago • 6 comments

It would be great to extract event frames with attribute values into a table to generate reports in Grafana. Is this planned for the future?

bujos avatar Feb 20 '25 12:02 bujos

All event frames are in a MS SQL database. You can use Grafana's MS SQL datasource to achieve this. How would the current plugin add to this?

pvmagacho-nde avatar Feb 20 '25 13:02 pvmagacho-nde

everything is already accessible in the annotations, we just need to make them available in the datasource.

bujos avatar Feb 20 '25 14:02 bujos

What is the PiWebAPI call to get the data you need?

coderReview avatar Feb 20 '25 17:02 coderReview

Assetdatabases? I simply want to retrieve data that can be easily extracted using your plugin as annotations for event frames, in the data source for Grafana panels, in order to compile them with the results of the associated attributes.

bujos avatar Feb 20 '25 18:02 bujos

Image

For example, I want to compile the information that can be extracted from the attributes of the Event Frames, as shown in the attached photo, but currently, it is only annotations.

bujos avatar Feb 20 '25 18:02 bujos

reference : https://docs.aveva.com/bundle/pi-web-api-reference/page/help/controllers/eventframe/actions/geteventframesquery.html

bujos avatar Feb 20 '25 19:02 bujos