Total number of PI Event Frames : Acknowledged vs Not Acknowledged

Dear Experts,

We are working to build a dashboard based out of PI Vision - to pull out the list of event frames for the time bar duration (say 7 days).

We get the details of events from Create Event Tables; however, I want to know if there is any way can we get the count (number) of events that are acknowledged or not acknowledged.

I might be missing something here but appreciate your guidance.

--

Cheers,

TM

  • I can't think of a native way to do that other than using a custom data reference or custom PI vision symbol.

  • (Missing Content)​ The proper solution would be a custom symbol that queries the PI Web API and does aggregation. It would be possible to build a custom service that queries the information and then stores it in PI for visualization, but that typically requires architecture reviews & approvals.

     

    However, a simple quick and dirty table could be queried via SQL using the following (just not usable in Vision without a custom SQL symbol):

    SELECT 'Not Acknowledged' AS [State], COUNT(*)
    FROM [PIFD].[dbo].[AFEventFrame]
    WHERE [acknowledgedby] IS NULL
    UNION
    SELECT 'Acknowledged' AS [State], COUNT(*)
    FROM [PIFD].[dbo].[AFEventFrame]
    WHERE [acknowledgedby] IS NOT NULL