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.

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

  • Type: Knowledgebase
  • Date changed: 11 months ago
Solution #00007394


ArchiveOne Enterprise, v7 or later



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.


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 <
    where XXX is the threshold number of days; any events older than XXX days will be deleted.