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.133 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.52 votes
We are researching and evaluating opportunities to expose PI Web API health, diagnostic, and basic telemetry data.
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.43 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 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.29 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.24 votes
I would like the ability to access event frame annotations using PI SQL Client, in the same way as in PI OLEDB Enterprise.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
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.18 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.
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
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.15 votes
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
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.14 votes
As an PI administrator I need to monitor the health of the index files created by the PI Web API Crawler. In particular, if the last crawl date has not been updated recently or other errors show up. This is currently done by manually visiting the PI Web API database page. A performance counter that reports things like "the number of databases who have not been updated in 1 hour" or "the number of databases in error" existed, we could store that info in tags and act on the crawler getting in a bad state in a proactive manner.13 votes
Please add support for .NET Core to the AF SDK. Currently only full .NET Framework is supported.11 votes
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.11 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?
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 a PI system administrator I want to specify where search index files are stored or make sure that the index files are not consuming space on an OS drive , so that I can manage/optimize the disk usage on my server machine.11 votes
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.10 votes
Please add PI TagMedian function in AF analysis like PI TagAvg and PI TagMean. Currently Median function is available but it cannot be applied for archive values of PI Tags during particular time range10 votes
Planned for 2018 R2. The Median function will support analytics array introduced with the 2018 release.
- Don't see your idea?