It is possible to count how many times a PI tag has been accessed over a period of time?
@Eduardo: I don't think this is possible. How would you differentiate if it is the same application refreshing the value or if it is a new access. Also, if you have a PI Collective it would be very difficult to keep the count right.
Could you share with us the use case you have in mind?
Mathieu, I was asked if there was a way to do this just to eliminate unused tags and improve the performance of the network and interfaces.
You can use the PI SMT to find out this information. Please open this product and choose Data-->Stale and Bad Points. Setting up the stale options properly will return the unused tags.
Hope it helps!
another way to find out how often an TAG wa read is to use the AAA (Archive Activity Grid) Please refer to techsupport.osisoft.com/.../KB00335
The stale and Bad Points add-in to PI SMT helps you identifying points that are not used anymore.
To identify busy tags, candidates with potential to improve Exception- and Compression-settings, the Archive Activity Grid is a good tool. Please make sure to pay attention to the performance related note in KB00335.
You can also use PI OLEDB (Classic) Provider to count events over a period of time but please take caution. To avoid running into a timeout, I suggest a) to filter by tag name and b) keep the query period small e.g. 1 hour.
SELECT tag, value, pctgood FROM piarchive..picount WHERE time BETWEEN '*-1h' and '*' AND tag like 'C%' AND calcbasis = 'EventWeighted' ORDER BY value DESC
Florian / Gregor:
I think that I'm looking for.
Thanks for the help
Retrieving data ...