1 Reply Latest reply on Nov 3, 2011 4:32 PM by mhalhead

    Where is PIBatch "event" data stored?

    TEL1

      Hello:

       

      We are using v3.4.375.80 and PIBaGen to generate batch data.  We then use BatchView in Excel to call up our process data by batch.  This works well, however, we are thinking of moving last years archives offline (not deleting).  But, if we need to retrieve some data we would want to do it by batch, not time. 

       

      So, if someone asked me to retrieve old data for batch X123 how would I know what archive(s) to retrieve and register?  It seems if I remove the archive, I've removed the batch data as well.  This kind of request, hopefully, will be rare.  Any other options?

       

      Thanks!

        • Re: Where is PIBatch "event" data stored?
          mhalhead

          TEL1,

           

          Far as I know the batches information is stored as PI Points. If you look at your points you will see a bunch of points named with a GUID. Some of these will be you batches; as far as I remember the PIBatch does add a descriptor to the points indicating that they are batch points. One thing to bear in mind is that a number of OSIsoft modules use a similar method.

           

          The batch structure is stored in the module database dat file.

           

          To restore a batch you would need to restore the archive which has the batch data; therefore you would need to know the approximate date range.

           

          Last daft question. Why are you think of archiving the "old" data? Harddisks are cheap and the old data doesn't impact on the performance of PI.