hello community,
I need to get the values in a table (which have an the trending activated) but from some moments in the past. As I need 3 values from a table of 400 lines, I can’t use the normal trend display for this without loosing days of work.
Is there a way to get these information with some SQL query or a magic function in Dataminer?
P.S. We are running your DMS with Cassandra.
Kind regards
Romain
Hello,
another could be option is the GetTrendDataMessage call
Class GetTrendDataMessage | DataMiner Docs
Hi Romain,
You can open DevCenter (located in C: –> Program Files –> Cassandra) and write a query.
You need to query the elementdata table belonging to the sldmadb keyspace :
DataMiner general database – NoSQL Database – Cassandra | DataMiner Docs
A sample query : select * from sldmadb.elementdata; would list all columns of this table. You will then need to alter the query based on DMAID, element ID, timestamps by looking at the columns of the elementdata table.
Using this, you can find the value of a parameter at any previous point.
Hi Romain,
A possible option is using GQI queries to get historic data. You could use the data source ‘Get parameter table ID‘ and enable the box ‘History’. Below an example:
You can export this information to a CSV file. In case you would like to generate this export in a scheduled base, you could use Data Aggregator.
Hope it helps.