I want daily event count of 2000 tags for last couple of months.
Is there any easy or less time consuming method to do this?
If you use any of the PI OLEDB providers, you can do a query like this in SQL Commander
SELECT tag, value
WHERE tag = 'sinusoid'
AND calcbasis = 'EventWeighted'
AND time BETWEEN '*-1mo' AND '*'
AND timestep = '1d'
This will return the number of events per tag you have selected in the query over the time range you specify
I don't know why but it is not working, it is giving 86400 output for every tag per day. Even if it is a calculated tag with one value per day. Please suggest.
Sorry, it will do a time weighted count by default which is the number of seconds in a day. I edited my original post to correct for event weighted counts.
It is working now
Retrieving data ...