• devdata.osisoft.com Certificate is expired.

    devdata.osisoft.com Certificate is expired. Gregor Beck could maybe check ?   ps i created also a ticket - 00785081  
    last modified by WolfgangPurrer
  • How to access the AF tables

       I developed a CRUD using HTML, CSS, JavaScript and Node which I will access through PI VIsion. However, I am a beginner in the PI environment and do not know how to access the AF tables, moreover I n...
    last modified by EricFarias
  • Writing data back using PI SQL Client

    Hello everyone, I would like to use PI SQL Client Technologies in order to write data back to the Archive Server. It seems to be today only possible though the PI SQL DAS OLEDB service. Is there a way to write back...
    last modified by Thomas_Bernier
  • PI Web API queries

    I am new to PI Web API and am trying to stream data from PI Web API. I have to read the values from my AF solution. Current I am using the streamset functionality at element level. Below is the http call -  ht...
    last modified by Kiran324
  • Personalized functions

    Hello..I want to drop by and ask a technical question about PI AF, it is possible to make your own function on PI AF (not via Analysis Template), function configured like Abs, coth...etc. ? Thanks 
    last modified by anabaoui
  • Web API Digital State Table Access?

    Does the Web API expose the Digital State table anywhere?
    last modified by jdtubb@aep.com
  • OMF v1.1: An AF element template is created for each PI tag

    Hi,    We have been exploring OMF with PI web API. This results in an AF element template to be created for each PI tag.   Message formats are as shown below followed by the screenshots of AF template...
    created by Jyotig02
  • Connecting PI Processbook with SQL Server Automatically

    Good morning there!   Is there any way to immediately sign in to a protected database when opening a PI display?   Right now I have PI Calculations performing sql queries and pulling back specific TOP 1 ...
    last modified by PeteHerz
  • Connecting Processbook VBA with SQL server

    Hi All,   It is possible to use Processbook(VBA) to connect to get data from SQL Server and display in Textbox of Processbook.   If yes, any example to assist me. 
    last modified by Tigerhoe
  • I want to build a list in ProcessBook VBA and export to an Excel file?

    I would like to create a list of tagnames on a display and export them to an Excel file.  I suppose a generic .txt file would work too.  I cannot figure out how to open Excel via ProcessBook VBA however, muc...
    last modified by gfmalek
  • PI Generic Names Installer Needed By PI SMT?

    I am not installing PI ICU with PI System Management Tools 2015 R2.  Do I still need to install PI Generic Names .MSI (PI GenericNamesSetup.msi)?
    Marc Dunivan
    last modified by Marc Dunivan
  • What happens behind the scenes when you change the Point Type of a long established Point?

    Hypothetical situation:   Lets say you have a Pi point that has had a Point Type of Int32 since it's creation X months ago and you change that Point Type to Float32 in the PI SMT; what happens behind the scenes?...
    last modified by Ahlywog
  • PI OLEDB regarding

    PI OLEDB   We are still using PI-OLEDB-Enterprise_2012_.exe. With reference to upgrading Windows to 2012 in our company, was trying to download PI-OLEDB-Enterprise 2017 but it  shows as   ...
    last modified by Maitreyi
  • Which bitness version of PI SQL programs does 32-bit Excel use on 64-bit Windows?

    I have spreadsheets that use Power Query in Excel to get data from PI using PI OLEDB Provider, PI OLEDB Enterprise, and/or PI SQL Client. I use 32-bit Excel on 64-bit Windows. When I refresh the queries, is Power Quer...
    last modified by Kenneth_Barber
  • Powershell script for Backfill/Recalculate

    I've been told by quite a few people in tech support that PowerShell is very ... powerfull and can do a lot of different things.  I'm trying to teach myself the capabilities but it seems hard to find good documen...
    last modified by taterhead247
  • Help with Python and PI Web API for a batch call to update PI Tag attributes

    I am working on automating this workflow rather than append in Excel. I have to set point and data security for some set of users or provide access to Analysis service. Got a great head-start from OSIsoft's Github. Ad...
    last modified by jagdish.konathala
  • PI Web API Unresponsive for Some PI Tags

    Hi all,   I encountered an issue on PI Web API and below is the issue description.   Whenever I try to plot a trend on PI Vision -2019 for Sinusoid Tag, I could browse and and Plot as usual but whenever I ...
    last modified by PAVAN_HEMAPAVAN
  • How To Loop Through The Values of AF Table Using AFSDK

    Greetings to my fellow PI Geeks:   I need some help looping through an AF Table. I am not finding answers doing a variety of searches on this topic. In C# I am able to connect to the default AF database and i...
    James Devine
    last modified by James Devine
  • Compare 2 DB for differences

    Is there a method to compare 2 DBs for the differences. For example, let's say this databases are the same but there may be new elements. How I can compare these two to find the elements that are one database that are...
    last modified by SantiagoVeraTorres
  • AF SDK :FindElementsByTemplate call and element versioning

    Hi,      We have a custom code that uses FindElementsByTemplate AF SDK call to retrieve elements by template.  We have around 25 templates with 100's of elements based on each template. The p...
    Arti Rajagopalan
    last modified by Arti Rajagopalan