• State Verified Answer
  • Replies 2 replies
  • Subscribers 3 subscribers
  • Views 479 views
  • Users 0 members are here
Options
Related

Can I bulk retrieve point data using only Pointid?

James.Aylard

Using DataLink or PI Builder, is it possible to retrieve point attributes in bulk by providing only the pointid? I would like to retrieve the point name and ideally other attributes, but I do not see how to do this, in bulk, using only the pointid. Since PI logs often only include the pointid to identify a point with issues, it seems there must be some way to do this.

 

Thanks.

  • 0

    ​ PI DataLink is a client tool to retrieve time series data, whereas PI Builder is a client tool for configuration. Inherently they serve two different purposes. It seems you're better serve with PI Builder based on what I can infer from your question - I read that you're trying to do some sort of debugging with PI Points. However, your question is on "how" to do something and doesn't explain the "what" problem you're trying to solve.

     

    Given the lack of information of what problems you're trying to solve, I will attempt to describe what you can do with PI Point ID in PI Builder.

     

    First off, in the Tag Search dialog box, you can search by PI Point ID. To do this, go to the search bar (rectangular box really) and type in "PointID:XX" with XX being a number corresponding to the PointID of interest. The search will return the PI Point with that PointID. This is one way to find the PI Point corresponding to the PointID of interest.

     

    Secondly, create a blank Excel spreadsheet and select the "Headers" icon, select PI Point as your object type, then pick-n-choose the columns (headers) that you want on your spreadsheet, including the required columns. Once you have that, populate the PointID column with the PI Point ID of interest, then put "x" in the corresponding 1st column and populate the "ObjectType" column with "PIPoint". Now select "Retrieve" and you will get the PI Point configuration for all the PI Point ID that you have listed in the spreadsheet.

     

    Hope this helps.

     

  • 0

    Chiming in 2-years too late to this thread. But I stumbled across it only because a co-worker asked me a similar question today. I am one who rarely offers a contrary opinion to the respected Steve Kwan, but I can say YES you can use the Point ID in DataLink. I am going to extend Steve's answer with 2 other techniques, though I will admit that Steve's was very simple to use.

     

    I am assuming the reader is moderately experienced with DataLink and/or PI Builder.

     

    First, one thing to try it to lookup the tag names by point id using something like PowerShell. At the OSIsoft Portal (my.osisoft.com) there is a knowledge article titled "Generate Corresponding TagName for PointID Using Powershell". Search for that and follow the instructions. Note: I have not tried this yet myself. And technically, after that, you are then using the tag name in DataLink calls.

     

    The other thing can be used in DataLink and its a nice hack. I absolutely doubt this is a great technique in bulk or will yield high performance. But the hack is that putting a question mark in front of the integer pointid, which transforms it to a text string, can be used in place of the tag name.

     

    In the image below, column D is a lookup of the "tag" Property using column C. And Columns E + F also use column C.


    Hack using _pointid instead of tag name.png
     

    I use simple Excel functions to compose the Hack ID in column C:

    =CONCAT("?", $B2)

     

    Hope that helps anyone who needs it.

    -Rick Davin, Feb 2023