Which table/column to retrieve pi tag (address) & static element Attribute Value

Discussion created by ChewCheeLim on Mar 8, 2012
Latest reply on Mar 21, 2012 by bperry

Hi, there: I would like to retrieve Pi Tag address & static element attribute value by using pi OLEDB Ent. Which table/column should I query?


Pi Point Address like so,


Static attribute Value example: MANUFACTURE : DELL


And for a given ElementAttribute, is there a flag to tell me if it's a pi point?  Like so,

AfAttribute.DataReference.Name ==



"PI Point"


p/s: I am reading Pi OLEDB Enterprice R3 user guide doc downloaded from vCampus.. hoping to find some description on  columns. Only see some column type definition. Not description. Please let me know if there is a doc has this information.


Thanks much!