Expose PI Integrator view statuses
Customers who plan to have a significant number of views need a better way to manage the status of their views other than periodically checking the PI Integrator UI.
There should be a way to obtain view statuses through other programs (custom or PI), so that users can receive alerts if a view goes into an error status.
Guy Acciai commented
Can you elaborate a bit more on your view construction sitting on the LogEntries table? - I'll familiar with that table, and I'm curious if you joined the ScanID back to the individual views in the IntegratorStats database to sort out the View name and the execution time?
Additionally, how did you deal with the "Stats" column, as it looks to be using some sort of compression - We tried a GZIP decoder, but didn't get very far -
Any hints on how to decode LogEnteries.Stats column, or the Stats column in the various view tables stored within the IntegratorStats DB?
Sharing some SQL code (or T-SQL if needed) on your view definition would be much appreciated.
We created a view in SQL server for this using the LogEntries table. It works well and gives us the information we need but it's something we need to be cautious on whenever a software update is released. Would certainly prefer to have it as part of the product.
Guy Acciai commented
Totally agree with the need for more visibility into view status, and my recommendation would be to push some of this (as well as last run statistics) into Perfmon, along with other Pi4BA performance data (CPU, Reads/Writes, Memory, Execution Time, per worker process). -
This allows me to trend run time into PI with Perfmon interfaces, do notifications via PiNotifications, etc. - Versus building a separate dashboard for view tool, just expose (RO) alot of what's stored in the PI4BA PiView AF Configuration DB into Perfmon
Bottom line, if Pi4BA is to become an enterprise tool, then it needs to expose more of it's operational status, and facilitate better monitoring, etc.
Definitely in need of this, especially if a company has to start running multiple instances of the Integrator to work around the 100k stream limit. I want to receive emails if a View starts getting errors and monitor run times to see if they start increasing, to troubleshoot any performance issues.