[SOLVED] Identify list of tables which are updated, when Tag values are modified or inserted into Wonderware Historian server

Identify list of tables which are updated, when Tag values are modified or inserted into Wonderware Historian server

I would like to ask the following:

Identify the list of tables, which are updated when tag values are modified or new tag is inserted into the system.
What SQL query should I run to retrieve the list of updated tags including their latest value, old value, updated time etc at any point in time?

Please let me know about it.

Solution

While tightly integrated with SQL Server, Wonderware Historian does not actually store the real-time tag data in SQL Server. Instead all tag data is stored in a proprietary file system. The data is expose within SQL Server as views via a proprietary OLE DB provider. The following pdf will give a better understanding of the WW Historian architecture:

http://iom.invensys.com/EN/SoftwareGCC14Presentations/Wonderware/WW%20INFO-07%20Valuable%20Information%20From%20WSP%202014%20R2.pdf

The following pdf will provide more detail as to what features and functions that is supported by the OLE-DB provider, this includes query options, versioning etc.:

https://www.logic-control.com/datasheets/1/Historian/HistorianConcepts.pdf With regards to retrieving the latest values for each of the tags you can query the “Live” table / view.