Skip to Main Content
AVEVA™ PI System™ Feedback Portal

Welcome to our new feedback site!


We created this site to hear your enhancement ideas, suggestions and feedback about AVEVA products and services. All of the feedback you share here is monitored and reviewed by the AVEVA product managers.

To start, take a look at the ideas in the list below and VOTE for your favorite ideas submitted by other users. POST your own idea if it hasn’t been suggested yet. Include COMMENTS and share relevant business case details that will help our product team get more information on the suggestion. Please note that your ideas and comments are visible to all other users.


This page is for feedback specifically for AVEVA PI System. For links to our other feedback portals, please see the tab RESOURCES below.

391 VOTE
Status Evaluating
Created by Guest
Created on Aug 19, 2022

Ability to search for PI Points used by PI AF attributes

As a user, I want to be able to search for specific PI Points used by PI AF attributes, so that I can easily find where the PI Points are being used.
  • Attach files
  • Tyler Engelhardt
    Reply
    |
    May 30, 2024

    One of the core items missing from this is not only finding attributes that directly use a PI Point, but also finding any non-PI Point DRs that reference that same PI Point. In systems with 5-8 million+ attributes, building our own recursion process to find these references becomes a pain. The solution provided needs to identify every reference.

  • BradR
    Reply
    |
    May 15, 2023

    This request occurs multiple times in this enhancement request list. It has been requested in multiple tools. The total votes across each request is several thousand. Please address this.

  • Marcelo Botti
    Reply
    |
    Apr 12, 2023

    I would kill for this feature!
    As an admin and user support of 10 sites, I spend a lot of effort any time I have to look for this reference. In my case, I normally starts from a tag and I need to get the element name and database. Thx, M.

  • emetzler
    Reply
    |
    Oct 11, 2022

    I agree -we're struggling to maintain AF without this feature

  • tammyreigle
    Reply
    |
    Sep 14, 2022

    I agree being up to search for PI Points, Elements etc. in AF would save a lot of time

  • Guest
    Reply
    |
    Aug 19, 2022
    Not only search PI Points but the ability to search for a value of a PI AF attributes. Example if an attribute is an asset type such as a pump, a fan, an agitator, etc. It would be possible to find all the elements that would have an attribute value of "fan".
  • Guest
    Reply
    |
    Aug 19, 2022
    I want to search AF element or its child attribute based on PI point. If I know PI point I can search its linked element and attributes in AF. In pallette option "search by tag" this feature should be provided.
  • Kelsey Bobeck
    Reply
    |
    Aug 19, 2022
    This would be very helpful. Currently, I'm doing a Tag Name child attribute so it can be found using the Attribute Search's filter. However, this is very cumbersome.
  • Kenneth Barber
    Reply
    |
    Aug 19, 2022
    In the meantime, I would suggest making a query table in Excel that uses PI OLEDB Enterprise to get the same information. Then you only need to refresh the table to update it rather than import the information all over again.
  • Kenneth Barber
    Reply
    |
    Aug 19, 2022
    In the meantime, I would suggest making a query table in Excel that uses PI OLEDB Enterprise to get the same information. Then you only need to refresh the table to update it rather than import the information all over again.
  • Kenneth Barber
    Reply
    |
    Aug 19, 2022
    In the meantime, I would suggest making a query table in Excel that uses PI OLEDB Enterprise to get the same information. Then you only need to refresh the table to update it rather than import the information all over again.
  • Guest
    Reply
    |
    Aug 19, 2022
    Now I used PI Builder (in Excel) to download the AF structure and search where tags are used. I would like to suggest an update / addin for System Explore that would allow you find tags and where they are used in the AF structure
  • Guest
    Reply
    |
    Aug 19, 2022
    Customer would like the ability to search in PI System Explorer for a tag, and find all references (attributes linked to that tag) in the database.
  • Guest
    Reply
    |
    Aug 19, 2022
    Here is a similar use-case for those who are trying increase their AF adoption: Create a way to search for PI Points that are NOT represented anywhere in AF. Here is an example: https://pisquare.osisoft.com/thread/37080
  • Guest
    Reply
    |
    Aug 19, 2022
    Native way to search in Pi System Explorer if a PI Point is used and where it is used would be very useful.
  • Guest
    Reply
    |
    Aug 19, 2022
    This is a very needed feature to find all the assets that are using a particular tag.
  • Guest
    Reply
    |
    Aug 19, 2022
    Searching PI points used in PI AF elements/attributes is very needed feature.
  • Kenneth Barber
    Reply
    |
    Aug 19, 2022
    I encountered a similar situation, except that I was trying to see which tags I still had to add to PI AF (I started with a bunch of tags and a completely empty PI AF). My solution was to use PI OLEDB Provider in Excel to get a list of all tags on the PI Data Archive. I used PI OLEDB Enterprise in Excel to get all attributes in PI AF and their associated tag, if any. With these 2 tables in Excel, you can use lookup functions to check if each value in one table is in the other.
  • Robert
    Reply
    |
    Aug 19, 2022
    This is sorely missed. Some of the databases are huge and it can take a long time to figure out where a tag resides in the structure. Also, in my experience when we have new employees it is one of the first features they request when they are learning AF.
  • taterhead247
    Reply
    |
    Aug 19, 2022
    I feel the pain! For those interested (and those not afraid to break the rule of not querying PIFD directly!) I came up with a SQL query you can run against PIFD. You copy your PI tag name into line 3 and it searches the SQL database for everywhere it's referenced. So far it's proven reliable. The way it's written it only searches one tag a time - I'm sure it's possible to search multiple. -- Paste your PI Point name in the 'SET' line. It has to be exact. DECLARE @PIPoint VARCHAR(MAX) SET @PIPoint = 'RAWHIDPT.Cryo Unit.NGL.C2Rec (Simulated)' -- Do not modify anything below this SELECT ep.path As 'Element Path', ep.name As Element, ta.path AS 'Attribute Path', ta.name As Attribute, adr.configstring, 'Yes' As Template, CASE WHEN ta.fkparentattributeid IS NOT NULL THEN 'Yes' ELSE 'No' END As 'Is Child Attribute' FROM AFElementAttributeDR adr INNER JOIN AFElementTemplateAttribute ta on ta.rid = adr.fkattributetemplateid INNER JOIN AFElementVersion ev on ev.rid = adr.fkelementversionid INNER Join afelementpathA0 ep on ep.elementversionid = ev.id WHERE adr.fkattributetemplateid IS NOT NULL AND ep.primarypath = 1 AND adr.configstring like '%\' + @PIPoint + '?%' UNION SELECT ep.path As 'Element Path', ep.name As Element, ea.path AS 'Attribute Path', ea.name As Attribute, adr.configstring, 'No' As Template, CASE WHEN ea.fkparentattributeid IS NOT NULL THEN 'Yes' ELSE 'No' END As 'Is Child Attribute' FROM AFElementAttributeDR adr INNER JOIN AFElementAttribute ea on ea.attributeid = adr.fkattributeid INNER JOIN AFElementVersion ev on ev.rid = adr.fkelementversionid INNER Join afelementpathA0 ep on ep.elementversionid = ev.id WHERE adr.fkattributetemplateid IS NULL AND ep.primarypath = 1 AND adr.configstring like '%\' + @PIPoint + '?%'
  • Load older comments
  • +291