AnsweredAssumed Answered

for rdbms interface, scan class of my distributor tag and the target tags are different. is it possible to write a sql query in this case??

Question asked by Smrutilipsa on Mar 16, 2020
Latest reply on Mar 17, 2020 by gmichaud-verreault

I am trying to create a distributor tag whose scan frequency is 30 sec. But the target tags under it have different scan frequencies like:

Target tag1 - 10 sec

Target tag2 - 15 sec

Target tag3 -  5 sec

Now the distributor tag will run the SQL query in every 30 sec. But in 30 sec, it may fetch multiple records/values at different time stamps for each target tag :

Example-

12:00:10 - Target tag1 - 10 (value)

12:00:20 - Target tag1 - 40 (value)

12:00:30 - Target tag1 - 55 (value)

 

12:00:15 - Target tag2 - 30 (value)

12:00:30 - Target tag2 - 40 (value)

 

12:00:05 - Target tag3 - 90 (value)

12:00:10 - Target tag3 - 11 (value)

12:00:15 - Target tag3 - 45 (value)

12:00:20 - Target tag3 - 10 (value)

12:00:25 - Target tag3 - 48 (value)

12:00:30 - Target tag3 - 56 (value)

 

Is it possible to use distribution tag concept in this situation? If yes then how should i proceed??

 

Outcomes