|Wincc Archive query
|Page 1 of 1|
|Author:||tomtomtom [ Tue Dec 22, 2015 9:39 am ]|
|Post subject:||Wincc Archive query|
Please give me solution as i stucked on site.
i have to generate excel report from 500 ms tag logging of different time stamp that is 10 min , 30 min & 1 hour.
How can i query archive tag so i can get data of different time difference!
Please help me in it!
|Author:||almaz78 [ Thu Dec 24, 2015 6:32 am ]|
|Post subject:||Re: Wincc Archive query|
Take a look at WINCC/Connectivity pack manual. they have few examples there.
here is query that will probably work for you:
The following query uses the <TimeStep> parameter and returns all values of ValueID "1" and
"2" - starting from start time "TimeBegin" till 2 minutes later in intervals of "15" seconds with
the aggregation type "261" = "Average value with linear Interpolation".
"TAG:R,(1;2),'2004-10-13 17:00:00.000','0000-00-00 00:02:00.000',
It sound little strange to me that your customer wants to see data in different time stamps. from my experience they more interested in logging average or max/min values at different intervals. Anyway you can get this info with the above query by simply specifying aggregation type
|Page 1 of 1||All times are UTC + 3 hours|
|Powered by phpBB® Forum Software © phpBB Group