plcforum.uz.ua
http://plcforum.uz.ua/

Wincc Archive query
http://plcforum.uz.ua/viewtopic.php?f=31&t=23466
Page 1 of 1

Author:  tomtomtom [ Tue Dec 22, 2015 9:39 am ]
Post subject:  Wincc Archive query

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!

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:

Quote:
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',
'TIMESTEP=15.261'"


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
http://www.phpbb.com/