When event frames have comments and reason codes added to them, what table in the PIFD SQL database are they stored in?
OSIsoft does not support direct access to the tables in SQL Server because the schema may change between releases. What is your reason for needing this information?
While I can't answer for the original poster, I can answer your question in terms of my past adventures.
I have worked on a reporting system where the data was consumed from event frames and fed into a data repository; I suspect the original poster is looking to either do the same or generate a report, possibly with SSRS.
There are established methods to obtain data in regards to event frames: PI Datalink and custom code.
Datalink is useful for ad-hoc queries or generating a report from a desktop, but personally, I try whenever possible to NOT have automated spreadsheets generating reports - I've seen to many issues in the past.
And for custom code, not all sites that may want a report have someone that can write custom code.
Since the schema is subject to change without notice, having a handful of OSIsoft generated and supported stored procedures to get data from the schema would be extremely beneficial. If the data was extracted to a local table, it could then be manipulated as needed.
See KB01254 - Direct reading or manipulation of the PI AF SQL Database (PIFD) is not supported.
You can use one of the supported Developer Technologies like PI OLEDB Enterprise to access information from the SQL database that is supported.
Retrieving data ...