plcforum.uz.ua

International PLC Forum
It is currently Wed Sep 20, 2017 9:09 pm

All times are UTC + 3 hours




Post new topic Reply to topic  [ 2 posts ] 
Author Message
 Post subject: Wincc Archive query
PostPosted: Tue Dec 22, 2015 9:39 am 

Joined: Tue Oct 13, 2015 1:01 pm
Posts: 10
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!


Top
 Profile  
 
 Post subject: Re: Wincc Archive query
PostPosted: Thu Dec 24, 2015 6:32 am 

Joined: Tue Dec 16, 2008 10:36 pm
Posts: 91
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


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 2 posts ] 

All times are UTC + 3 hours


Who is online

Users browsing this forum: No registered users and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
Jump to:  
Powered by International PLCforum® Forum Software © PLCforum
Mobile version