We use cookies on our website to ensure we provide you with the best experience on our website. By using our website, you agree to the use of cookies for analytics and personalized content.This website uses cookies. More Information
It seems like your browser didn't download the required fonts. Please revise your security settings and try again.
Barracuda ArchiveOne

How can I delete data from the PST history table in the SQL database?

  • Type: Knowledgebase
  • Date changed: 2 years ago
Solution #00007394

Scope: 

ArchiveOne Enterprise, v7 or later


Answer:

OVERVIEW

The C2CAOneConfig SQL database is used to store the history of events when processing PST files. You may wish to delete some or all of this data periodically to save storage for instance. Deleting this data removes the audit of events when processing a PST file; it doesn't affect the processing of the PST file itself.


HOW TO STEPS

In SQL Management Studio, connect to the SQL instance utilized by ArchiveOne.
  1. To remove all historical events for a specified PST, run the following query:
    USE [C2CAOneConfig]
    DELETE FROM PstHistory
    FROM PstHistory a
    INNER JOIN PstTable as b ON b.ID = a.PSTID
    WHERE b.Machine=<Client_Machine,,'ClientHostname'>
    AND b.File_Path=<PST_File_Path,,'E:\PathToPST\PSTFile.PST'>
    where ClientHostname is the hostname of the client machine where the PST file resides, and E:\PathToPST\PSTFile.PST is the file path of the PST file in question.
  2. To remove specified historical events based on age for all PSTs, run the following query:
    USE [C2CAOneConfig]
    DELETE FROM PstHistory
    WHERE Added <
    CAST(CAST(GETUTCDATE() AS DATE) AS DATETIME) - <Days_To_Delete,int,XXX>
    where XXX is the threshold number of days; any events older than XXX days will be deleted.