It seems like your browser didn't download the required fonts. Please revise your security settings and try again.

Attention

Starting May 1st, 2018, we will no longer offer the ArchiveOne family of products. This includes all editions of ArchiveOne, ArchiveOne for Files, Max Compression, and Access Security Manager. If you currently hold a maintenance and support contract, you will continue to receive our award-winning support until your contract expires, or until May 1st, 2019, whichever occurs first. The license for ArchiveOne is perpetual; therefore the software may continue to be used independently without any updates or support indefinitely.

How to Delete Data from the PST History Table

  • Last updated on

This article refers to the Barracuda ArchiveOne versions 7.0 and higher.

The SQL Server database stores PST file processing events. You can select to delete some or all of this data periodically to save storage. Deleting this data removes the audit of pst file processing events but does not affect PST file processing.

Open SQL Management Studio and connect to the SQL instance utilized by ArchiveOne, and then select from the following options:

Option 1. Remove All History Data for a Specified PST File

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 client machine hostname where the PST file resides, and E:\PathToPST\PSTFile.PST is the file path of the PST file in question.

Option 2. Remove History Data Older than X Days for all PST Files

To remove historical data older than a specified number of days for all PST files, 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 is deleted.