Plugins 〉OSIsoft-PI
OSIsoft-PI
PI Web API Datasource for Grafana
This data source provides access to OSIsoft PI and PI-AF data through PI Web API.
Usage
Datasource Configuration
Create a new instance of the data source from the Grafana Data Sources administration page.
It is recommended to use "proxy" access settings. You may need to add "Basic" authentication to your PIWebAPI server configuration and add credentials to the data source settings.
NOTE: If you are using PI-Coresight, it is recommended to create a new instance of PI Web API for use with this plugin.
See PI Web API Documentation for more information on configuring PI Web API.
Querying via the PI Asset Framework
- Verify that the
PI Point Search
toggle is greyed off - In
Element
clickSelect AF Database
and choose desired database in list- A new ui segment should appear:
Select AF Element
- A known bug currently exists where this new ui segment fails. In this case select the
+
inAttributes
and it will force create the ui segment
- A new ui segment should appear:
- Click
Select AF Element
and select the desired AF element - Repeat step 3 until the desired element is reached
- Under
Attributes
click the+
icon to list attributes found in selected element; select attribute from dropdown- If list of attributes does not appear begin typing attribute name and attributes should appear
- This method can also be used to filter through long lists of attributes
- Repeat step 5 as many times as desired
Querying via the PI Dataserver (PI Points)
- Toggle the
Pi Point Search
on - Under
Data Server
clickSelect Dataserver
and select desired PI Dataserver - Under
PI Points
click the+
icon to open a text entry field - Type the exact name of the desired PI Point; it is NOT case sensitive (
sinusoid
===SINUSOID
===sInUsOiD
) - Repeat steps 3 - 4 for as many PI Points as desired
Template Variables
Child elements are the only supported template variables. Currently, the query interface requires a json query.
An example config is shown below.{"path": "PISERVER\\DatabaseName\\ElementNameWithChildren"}
Event Frames and Annotations
This datasource can use AF Event Frames as annotations.
Creating an annotation query and use the Event Frame category as the query string. Color and regex replacement strings for the name are supported.
For example:
Installation
Install using the grafana-cli or clone the repository directly into your Grafana plugin directory.
grafana-cli plugins install gridprotectionalliance-osisoftpi-datasource
Trademarks
All product names, logos, and brands are property of their respective owners. All company, product and service names used in this website are for identification purposes only. Use of these names, logos, and brands does not imply endorsement.
OSIsoft, the OSIsoft logo and logotype, and PI Web API are all trademarks of AVEVA Group plc.
Grafana Cloud Free
- Free tier: Limited to 3 users
- Paid plans: $55 / user / month above included usage
- Access to all Enterprise Plugins
- Fully managed service (not available to self-manage)
Self-hosted Grafana Enterprise
- Access to all Enterprise plugins
- All Grafana Enterprise features
- Self-manage on your own infrastructure
Grafana Cloud Free
- Free tier: Limited to 3 users
- Paid plans: $55 / user / month above included usage
- Access to all Enterprise Plugins
- Fully managed service (not available to self-manage)
Self-hosted Grafana Enterprise
- Access to all Enterprise plugins
- All Grafana Enterprise features
- Self-manage on your own infrastructure
Grafana Cloud Free
.h4 . .mb-0 }
- Free tier: Limited to 3 users
- Paid plans: $55 / user / month above included usage
- Access to all Enterprise Plugins
- Fully managed service (not available to self-manage)
Self-hosted Grafana Enterprise
- Access to all Enterprise plugins
- All Grafana Enterprise features
- Self-manage on your own infrastructure
Grafana Cloud Free
- Free tier: Limited to 3 users
- Paid plans: $55 / user / month above included usage
- Access to all Enterprise Plugins
- Fully managed service (not available to self-manage)
Self-hosted Grafana Enterprise
- Access to all Enterprise plugins
- All Grafana Enterprise features
- Self-manage on your own infrastructure
Grafana Cloud Free
- Free tier: Limited to 3 users
- Paid plans: $55 / user / month above included usage
- Access to all Enterprise Plugins
- Fully managed service (not available to self-manage)
Self-hosted Grafana Enterprise
- Access to all Enterprise plugins
- All Grafana Enterprise features
- Self-manage on your own infrastructure
Installing OSIsoft-PI on Grafana Cloud:
Installing plugins on a Grafana Cloud instance is a one-click install; same with updates. Cool, right?
Note that it could take up to 1 minute to see the plugin show up in your Grafana.
Installing plugins on a Grafana Cloud instance is a one-click install; same with updates. Cool, right?
Note that it could take up to 1 minute to see the plugin show up in your Grafana.
Installing plugins on a Grafana Cloud instance is a one-click install; same with updates. Cool, right?
Note that it could take up to 1 minute to see the plugin show up in your Grafana.
Installing plugins on a Grafana Cloud instance is a one-click install; same with updates. Cool, right?
Note that it could take up to 1 minute to see the plugin show up in your Grafana.
Installing plugins on a Grafana Cloud instance is a one-click install; same with updates. Cool, right?
Note that it could take up to 1 minute to see the plugin show up in your Grafana.
Installing plugins on a Grafana Cloud instance is a one-click install; same with updates. Cool, right?
Note that it could take up to 1 minute to see the plugin show up in your Grafana.
Installing plugins on a Grafana Cloud instance is a one-click install; same with updates. Cool, right?
Note that it could take up to 1 minute to see the plugin show up in your Grafana.
For more information, visit the docs on plugin installation.
Installing on a local Grafana:
For local instances, plugins are installed and updated via a simple CLI command. Plugins are not updated automatically, however you will be notified when updates are available right within your Grafana.
1. Install the Data Source
Use the grafana-cli tool to install OSIsoft-PI from the commandline:
grafana-cli plugins install
The plugin will be installed into your grafana plugins directory; the default is /var/lib/grafana/plugins. More information on the cli tool.
Alternatively, you can manually download the .zip file for your architecture below and unpack it into your grafana plugins directory.
Alternatively, you can manually download the .zip file and unpack it into your grafana plugins directory.
2. Configure the Data Source
Accessed from the Grafana main menu, newly installed data sources can be added immediately within the Data Sources section.
Next, click the Add data source button in the upper right. The data source will be available for selection in the Type select box.
To see a list of installed data sources, click the Plugins item in the main menu. Both core data sources and installed data sources will appear.
Changelog
1.0.0
- Initial release.
2.0.0
- Move to React based framework.
3.1.0
- Added calculation to PI Points
- Added PI point configuration (thanks to @TheFern2)
- Added option to use last value from PiWebAPI
- Updated to Grafana plugin SDK v9.3.6
4.0.0
- Added a new dataframe label format. It can be disabled in the configuration page for backward compatibility
- Added engineering units to Dataframe field. This can be globaly disabled in the configuration page
- Optimized queries using PIWebAPI batch endpoint
- Improved raw query processing
- Added variable support in raw query
- Fixed annotations support
- Updated to Grafana plugin SDK v9.4.7
- Fixed PI AF calculation
- Added plugin screenshots
4.1.0
- Modified the PI Webapi controller endpoints used when calculation is selected
- Allow calculation when last value option is selected
- When calculation is selected, change label from Interpolated to Interval
- Fixed issue with variable in Element Path
4.2.0
- Fixed issue that only odd attributes were been shown
- Fixed issue when fetching afServerWebId
5.0.0
- Migrated backend to Go language
- Changed the query editor layout
- Support Grafana version 11
- Drop support for Grafana 8.x and 9.x
5.1.0
Add units and description to new format - issue #154
Fixed digital state - issue #159
Fixed summary data - issue #160
Fixed an error in recorded max number of points - issue #162
Fix issue with summary when migrating from previous versions - issue $160
Updated the query editor layout
Added boundary type support in recorded values
Recognize partial usage of variables in elements
Added configuration to hide API errors in panel
Truncate time from grafana date time picker to seconds
Fixed warnings during deploy
Fixed LICENSE file