The OPC landscape is shifting away from DA/HDA and towards UA servers. A significant number of OPC client tools are being created that connect to OPC UA servers, and none of these are compatible with PI without the use of a third party UA wrapper since we only provide DA and HDA servers.114 votes
We have been gathering use cases and information about OPC UA Server functionality as it pertains to OSIsoft products.
There are a number of different requirements to consider, and as such we’re changing the status back to “UNDER REVIEW / RESEARCHING” to more accurately reflect the current status of the work.
At this time, we are not committing to bringing this capability to market.
We will update this thread if the status changes.
Add auditing or a view of statistics for the calls or requests done by each individual application. Allow a PI Admin to see which user or application is making a specific call and see how long it takes to complete to monitor performance and potentially resource intensive Web API calls.39 votes
We are researching and evaluating opportunities to expose PI Web API health, diagnostic, and basic telemetry data.
As a PI Web API user I want to know exactly what kind of Body Parameters (their defaults and description) are supported by PI Web API methods. The current sample requests are not sufficient because they do not describe the values for body parameter, though many parameters have unique restrictions.
Here is an example of desired content:
We have received a lot of feedback on this. We are looking at on-line help with better samples of queries and responses. We are looking at some web frameworks for offering a live “Try It” feature for PI Web API. We are also looking at comprehensive search within the PI Web API help system.
When the crawler fails on an incremental crawl, the index search must perform a complete rebuild of the index. It would be beneficial for there to be a way to revert to a previous built index just prior to the failed incremental crawl so that the index file is available. This is particularly useful for large data sources that take hours or days to crawl before they're usable again.27 votes
Add methods to retrieve messages from the local and remote PI Message Logs where remote can refer a PI Data Archive node or any remote PINS.
Because the EventLog Class in .NET Framework provides access to local and remote Event Logs, offering the AF (Server) Event Log through PI AF SDK is not necesarry.21 votes
As of now, we can get PINetMgr statistics via PowerShell command Get-PIConnectionStatistics. # of users familiar with AF SDK are more than with PowerShell.
It will be nice feature addition in AF SDK, and usability will also increased.19 votes
I would like the RTQP Engine to be able to read annotations.
My use case is the following :
I have user that enter manual values into PI along with these values the operator will specify the reason for this manual input.
The comment is stored in an annotations, there is currently no way to retrieve this information.
Retrieving a string would be sufficient for my needs.16 votes
When any time related functions need to be performed against timestamp columns in PI SQL Commander, one needs to utilize a significant amount of conversions to make this work. For example, if one needs to round timestamps to the nearest minute or the nearest hour, a CASE statement with multiple CASTs needs to be done to get this to work.
If T-SQL DATEADD and DATEDIFF commands were implemented, this would simplify the query by a significant amount. Similarly, in PL/SQL, the ROUND function is able to round the datetime value directly, which would fit perfectly to this scenario.16 votes
We are planning to add several functions that are equivalent to T-SQL functions. This will make it easier for the PI SQL products to integrate with the Linked Server in Microsoft SQL Server.
The ability to backfill an analysis using an end time in the future. This would read data from future inputs and write the results as future values.15 votes
I would like the ability to access event frame annotations using PI SQL Client, in the same way as in PI OLEDB Enterprise.14 votes
As a PI SQL Client OLEDB user, I would like to have the TIME(), DATE(), LOCALDATE() and TOLOCALDATE() functions available in order to construct datetimes for my queries.
These functions were available in PI OLEDB Enterprise, but are not available in PI SQL Client OLEDB.13 votes
The OPC DA Server service uses %PIPC%\PI_OPCDA2\Data\SavedNamespace.xml to load the tags and does not update the cache until the service is stopped and started again. If any new tag is added to the PI Server, it is not picked by the OPC DA Server. The service should periodically update its cache from the PI Server after the initial start.13 votes
I would like the ability to pass response values from one request into the body of a dependent request using the batch controller to avoid making 2 calls to the PI Web API.
Currently, I can only use Parameters in subsequent URLs, but not bodies.13 votesFrank Garriel responded
The idea still exists on our product backlog, but there are no plans in place to develop and release this functionality at this time.
As a PI Web API user, I would like a simple method to perform bulk deletes of a particular attribute or PI tag. Currently, a bulk delete requires 2 calls. One to retrieve the event I wish to delete and another to delete it.11 votes
Web ID 2.0 should allow you to compute the WebID of a resource without needing to make a call to PI Web API. With that computed WebID, you can make the single call to PI Web API to delete the resource.
Does this solution meet your needs? Have I understood it correctly?
As an end-user, I want to be able to see to which PI Collective member I am connecting to. I also want to be able to toggle programmatically from one PI Collective member to the other so I can make sure the informaiton I am seeing is aligned and in synch accross all PI Collective members without going into thick PI clients or through log files.10 votes
This is a novel idea for monitoring PI Collective health, but there are no plans to add this ability to PI Web API. What advantages do you see in using PI Web API here?
With Microsoft supporting .NET Core on Linux operating systems such as RHEL, SLES Ubuntu, CentOS, and Debian.
They are even supporting SQL Server on Linux OS'es.
I don't know the dependencies of the AF SDK nor the Web API, but if they can use .NET Core; it would be nice to have the AF SDK and Web API available for Linux based OS'es.9 votes
As a developer of custom applications that use the PI AF SDK, I'd like to be able to easily determine if an attribute based of an attribute template is configured for tag creation. Currently the AF Attribute Template class does not have this property. The current work around is to look at the configuration string which is less efficient.8 votes
Add a PI PowerShell cmdlet to find all installed PI software and which installation kit installed it
As someone tasked with upgrading PI environments, it would be nice if there was a tool such as a PI PowerShell cmdlet that would retrieve all of the version information for all installed PI software on a given machine, as well as which install kit was run to install it. This would help save time during the audit process, before upgrading many servers with the latest version of that install kit.8 votes
The ProgID of the 2015 PI OPC DA Server is OSISoft.OPCDA2.DA.1, while the ProgID of the 2010 PI OPC DA Server is OPC.DA.1.
Existing client tools that pointed to the 2010 PI OPC DA server will need to be reconfigured to point to the new ProgID after the PI OPC DA server is upgraded to 2015.
While this is done because of an architecture change between the 2010 and 2015 servers, potentially necessitating changes to be made to the client application, it is still desirable in some cases to point it to the new server without changing the ProgID.8 votes
Expose interfaces for asynchronous data method calls (ex. InterpolatedValues, PlotValues, RecordedValues, Summaries) that:
1. Take an asynchronous enumerable of
AFAttributes as input
2. Output an asynchronous enumerable of results
3. Throttle the calls made to PI Data Archive so that it does not overwhelm it
The use case is to be able to make end-to-end asynchronous data method calls on a set of AFAttributes.7 votes
- Don't see your idea?