Wincc Archive query

Utilites for Simatic Automation
Post Reply
tomtomtom
Posts: 11
Joined: Tue Oct 13, 2015 10:01 am

Wincc Archive query

Post by tomtomtom » Tue Dec 22, 2015 6:39 am

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!

almaz78
Posts: 107
Joined: Tue Dec 16, 2008 7:36 pm

Re: Wincc Archive query

Post by almaz78 » Thu Dec 24, 2015 3:32 am

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',
'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

Post Reply