Notification if a tag is overfilling my Archive
As a PI admin I want to get notified if a tag is overfilling my Archive, maybe due to misconfiguration of ex/Comp. Setting.
thanks for this usefull PI SQL query.
Was very usefull
Vincent Kaufmann commented
This doesn't really handle the notifications part, but you could use a PI SQL solution to discover which tags are writing the most events to your archives and then act accordingly. This query could easily be turned into an automated report of some kind which you can then action on.
SELECT tag, value
WHERE tag = 'sinusoid'
AND calcbasis = 'EventWeighted'
AND time BETWEEN '*-1mo' AND '*'
AND timestep = '1d'
for me it would be sufficent to see how many % or mB diskspace each singel Tag is requiring in each Archive.
Once I have this available - together with the archive age, I can identify easier miss configured Tags.... and prevent overfilling with data.
Hahnming Lee commented
What is overfilling an archive? % of space taken in an Archive as compared to total PI count? Since fixed archives are time based, I would think it's natural for some tags to have more data than other tags.