I can't seem to find a way to unacknowledge an event frame in the event frame tables. I'm assuming this is a intentional function to show that the dashboard was checked? Is it possible to un-acknowledge an event?
Nope, not possible. Acknowledge is a one-way street.
You would have to do it programatically - but here is where the table exists in AF (see the bottom left - you would have to clear those fields):
I would say: direct manipulation of the AF tables in SQLserver is a big No-No.
It will probably work without too many issues, but i would not consider this a sustainable option. Do you also update the change tracking tables that keep track of changes to the AFmodel if you remove this?
How it's possible someone coded the Create/Update in the AFSDK code but not the Delete is also beyond my comprehension...
I agree that I am not a huge fan of changing the PIFD tables, but if you have an event or two once in a while, it can be done. If this happens a lot, then upvote on Piotr's feedback link below.
As Roger said, it is currently not possible. I would not also recommend to modify PIFD database directly.
Kind of workaround could be recalculation, but I guess it is not a solution for multiple event frames or if it needs to be done frequently. Then, without any changes in Event Frame Generation analysis, Event Frame would be recreated as not acknowledged.
There is also an idea on our Feedback page about that feature:
Remove annotations and acknowledgements from Event Frames within Vision – User Feedback for OSIsoft Products and Service…
Out of curiosity why do you need to un-acknowledge an Event Frame ? I'm asking as I would create an enhancement for the AF SDK, as the isAcknowledge property is currently read only and this is the main reason why it's currently impossible. An AFEventFrame can't be un-acknowledged even programmatically (in a way OSIsoft supports).
I would recommend to never update the PI AF SQL database manually. If you make a mistake, which you may not catch right away, the only supported way to fix the mistake will be to revert from a backup. Consequently, you could put yourself in a situation were there would be some data loss. If Tech Support suspects that the database was altered manually, they will help you restore from backup, but they will not try to fix the database. Moreover, the schema of the DB changes from one version to another. An update query could work in one version without issues and not in another.
Retrieving data ...