Work with Point Created snapshots

To delete a Point Created (Pt Created) snapshot value one point at a time:

Use the Archive Manager tool in PI System Management Tools. For more information, see Archive Editor.

To export points with snapshot values of Pt Created and delete those values from the snapshot table:

1. Create a piconfig script file called gettags.txt. Include the following commands in the file:

   @table pisnap
   @select status = Pt Created, tag = *
   @ostr tag, time
   @output snap_to_delete.txt
   @ends

2. Save and close the gettags.txt file.

3. Open a command prompt.

4. Go to the PI\adm directory.

5. Run piconfig, redirecting the previously created script file. (If you used a different path or filename for your script file, substitute the actual path and file name of your script file for c:\gettags.txt in the following example.)

   Piconfig < c:\gettags.txt

6. Open the snap_to_delete.txt file from the PI\adm directory to verify which points have Pt Created value in the snapshot. Edit the file to remove any points that you do not plan to backfill.

7. Save the snap_to_delete.txt file.

8. Run piconfig with the following commands:

   @table piarc
   @mode edit, t
   @istr tag, time
   @modi mode = remove
   @input snap_to_delete.txt
   @ends

   Note: If the Snapshot_DoNotReplacePTCreatedOnOOO tuning parameter is not set to 1 (the default is 0), skip this procedure.

Find and manage past Pt Created events

To manage both current and past Pt Created events, create and run separate piconfig scripts for snapshots and historical data, substituting the appropriate file names and commands as needed.

9. Modify the piconfig script file to target historical data. Create a new script file called getpasttags.txt. Include the following commands in the file:

   @table pisnap
   @select status = Pt Created, tag = *
   @ostr tag, time
   @output past_snap_to_delete.txt
   @ends

10. Save and close the getpasttags.txt file.

11. Open a command prompt.

12. Go to the PI\adm directory.

13. Run piconfig, redirecting the previously created script file. (If you used a different path or filename for your script file, substitute the actual path and file name of your script file for c:\getpasttags.txt in the following example.)

    Piconfig < c:\getpasttags.txt

14. Open the past_snap_to_delete.txt file from the PI\adm directory to verify which points have Pt Created value in the snapshot. Edit the file to remove any points that you do not plan to backfill.

15. Save the past_snap_to_delete.txt file.

16. Run piconfig with the following commands:

    @table piarc
    @mode edit, t
    @istr tag, time
    @modi mode = remove
    @input past_snap_to_delete.txt
    @ends