How can we improve the manageability of OSIsoft suite of products?

Filling archive

As a PI admin I want to get notified if a tag is overfilling my Archive, maybe due to missconfiguration of ex/Comp. Setting.

5 votes
Sign in
Signed in as (Sign out)

We’ll send you updates on this idea

meierke1 shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

4 comments

Sign in
Signed in as (Sign out)
Submitting...
  • meierke1 commented  ·   ·  Flag as inappropriate

    Hi vincent,
    thanks for this usefull PI SQL query.
    Was very usefull
     
    Kevin!

  • Vincent Kaufmann commented  ·   ·  Flag as inappropriate

    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'

  • meierke1 commented  ·   ·  Flag as inappropriate

    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.

  • Hahnming Lee commented  ·   ·  Flag as inappropriate

    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.

Feedback and Knowledge Base

Posted ideas will have one of the following statuses.
Full definition of these statuses can be found on the Home Page.
No status
NEEDS MORE DISCUSSION
RESEARCHING/EVALUATING
DECLINED
PLANNED
STARTED/IN DEVELOPMENT
IN BETA
COMPLETED