Trend function TrnGetTable

Hi Mark ,

The TrnGetTable only retrieves data from the connected Trend Servers. You can specify the Cluster the Trend Server belongs (optional). See the online help for more details:

gcsresource.aveva.com/.../TrnGetTable.html

If you are looking to get data from a Historian, there are a few options depending on your situation:

- Data Exchange (ActiveX control) could be one approach.

- Process Analyst can get data from Citect Historian (unfortunately no support for Wonderware Historian at this time)

- SQL (https://gcsresource.aveva.com/Citect/WebHelp/citect2018R2/Content/Cicode%20Reference/Content/SQL_Functions.html) assuming your Historian supports this, there are some examples of this cicode usage in Example project.

Kind regards

Olivier

Thanks Oliver. I will try using the SQL method. I was searching for any documentation for the SQL database of the historian and could not find any. I dont know which table it stores the data.

Hi Mark,

What Historian product are you using? If it is Wonderware Historian, it might be worth posting the question over at the Wonderware product forum.

Kind regards

Olivier

Hi Mark,

What Historian product are you using? If it is Wonderware Historian, it might be worth posting the question over at the Wonderware product forum.

Kind regards

Olivier