Hii All,
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!
Wincc Archive query
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:
here is query that will probably work for you:
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 typeThe 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',
'TIMESTEP=15.261'"