More queries - PI SQL query compendium solution

PI SQL Commander Lite includes an extensive collection of sample queries in a ready-to-use solution. It consists of two sample PI Asset Framework (PI AF) databases NuGreen and PIOleDbTest that you can import into your system with PI System Explorer. The files are located in the following directory:

[PIHOME]\OLEDB\Tools\PI SQL Commander Lite\MyProjects\PI SQL Query Compendium

Note: [PIHOME] is the directory to which you install PI client applications and interfaces. For example, C:\Program Files\PIPC.

Open the solution PI SQL Query Compendium in the PI SQL Commander Lite Solution Explorer and follow the guidelines given in the project file ReadMe.txt. There are also comments in the query project files found in the Queries folder: