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