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

Question

I would like to ask the following:

1. Identify the list of tables, which are updated when tag values are modified or new tag is inserted into the system.

2. 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.

Answer 1

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.