Skip to Main Content
AVEVA Product Feedback


Status Declined
Categories Notifications
Created by Guest
Created on Aug 20, 2022

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.
  • ADMIN RESPONSE
    Aug 20, 2022
    We have reviewed this idea, and it’s not something we plan to implement at this time. Even though we are declining this idea for now, it is still open to comments. We do want to hear your opinion. Thank you for the feedback, and please, keep sharing!
  • Attach files
  • Guest
    Reply
    |
    Aug 20, 2022
    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.
  • Guest
    Reply
    |
    Aug 20, 2022
    Hi Hahnming, 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.
  • Guest
    Reply
    |
    Aug 20, 2022
    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 FROM [piarchive]..[picount] WHERE tag = 'sinusoid'      AND calcbasis = 'EventWeighted'      AND time BETWEEN '*-1mo' AND '*'      AND timestep = '1d'
  • Guest
    Reply
    |
    Aug 20, 2022
    Hi vincent, thanks for this usefull PI SQL query. Was very usefull   Kevin!