Asset schema queries
- Last UpdatedSep 29, 2022
- 1 minute read
- PI System
- PI OLEDB Enterprise 2019
- Developer
This section provides SQL statements that demonstrate how to retrieve data for PI OLEDB Enterprise from:
-
The Element hierarchy
-
Element attribute recorded values
-
Element extended properties
Related Links
- Retrieve elements of element hierarchy as it exists at a certain date
- Retrieve children elements of current element hierarchy
- Retrieve subtree of current element hierarchy
- Retrieve subtree part of current element hierarchy
- Retrieve element attributes
- Retrieve element attributes and optional UOM
- Retrieve elements and specific attribute values when present
- Retrieve element attribute recorded values
- Retrieve element extended properties
- Retrieve element attribute recorded values using Simplified Asset Database E-R Model
- Search for elements by attribute values using Simplified Asset Database E-R Model