Hi, I used PI System Management Tools 2012 SP1
I would like to know if there is an easy way to know the number of record for a period
Thanks for your support
Emmanuel DE KOKER
+33 6 65 34 01 41
Using SMT, the easiest is: GoTO Data - Archive Editor and find the tag you need.
Start date 1-1, end date * (now) and go..... The event count shows the number of record of the tag.
Thanks for your quick reply, but my question is not for one tag but for all. The target is to define number of event by years for all the system.
The only way I know, is pull all your tags in Excel (hopefully not to many in the system ) and use the function:
Calculate data, select all tags, start and end time (start slowly !!!! and not 10 years - wont work)
Calculation mode: Count and under advanced options: Calucaltion basis - EVENT WEIGHTED..
I'm just curious, why do you want/need this information?
I use the Calculation mode: Count - Calucaltion basis - EVENT WEIGHTED for short period interval (max 1 day) to detect tags that are writing potential CRAP (an event every 0,1 sec) due to bad Compression settings... and tweak them...
2nd option you have is using DATALINK for Excel.
Function: Compressed Data - Select 1 or more Data items (Tags)
Select start and End time
And Presto..... you are done
As Robin Verhoek demonstrated, it's easy for 1 PIPoint. But to do it for all tags in your systems is neither easy nor will be quick, since you are basically asking to completely crawl over all your archives. SMT is not a good tool for this.
A PowerShell script might be possible, but again it is thrashing against all tags in your archives. An event-weighted summary count could be used, but for an entire year could cause timeouts, particularly if you have high frequency data.
I am a developer, and I could write something that could do exactly what you want, but even still, I would not do this if it were assigned to me. Instead, I would find a few sample tags, maybe based on some combination of polling frequency and interface, and then gather yearly counts for those few tags. I would then multiply the counts based on the number of other tags in the same category of interface and polling frequency.
Not 100% how records relate to PI Point values, but you could try piartool -al? That gives recordcount per archive. But my knowledge fails me to explain the difference between archive records and PI Point Events ('values')
Then sum up all archives for your target period. It depends on the accuracy you need how much work you need to put into this. E.g. splitting archives on exact year start and end, etc.
Could not let go of this question, but found a good answer here: https://customers.osisoft.com/s/knowledgearticle?knowledgeArticleUrl=How-do-you-determine-which-points-are-archiving-the…
A fast and simple method for identifying high data rate tags is to perform an archive integrity check using the pidiag utility. Not only does this check for archive errors, but it returns a list of every tag in the archive along with the total number of events. The result of the archive integrity check may then be analyzed to pull out a list of tags with high event counts.
..\PI\ADM>pidiag -archk <path> > output.txt
Retrieving data ...