Skip to main content

PI SQL Scripts

Contributors:
Tyler EngelhardtTyler Engelhardt

Overview​

PI SQL Scripts is an open-source collection of SQL scripts for querying and reporting on OSIsoft PI Asset Framework and PI Vision databases. These scripts help users extract valuable insights and perform advanced reporting not available through the standard application interfaces.

Features​

  • Retrieve PI Vision display inventories and metadata
  • Analyze Asset Framework structure and attribute usage
  • Generate custom reports for audits, compliance, or troubleshooting
  • Compatible with Microsoft SQL Server and other relational databases

Repository​

Explore the PI SQL Scripts repository.