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.


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.

Database Tables

  • Last updated on

In the following database tables, all fields are varchar text unless otherwise stated.

Table 1. Results stores the results of policies which correspond to the columns in the raw data of the results.

IDUnique Row Identifier

Name of the store the item was found in – this can be a mailbox, PST or public folder

PathPath where the item is found
SubjectSubject of the item
AttachmentThe names of the attachments on the item found
NumberOfAttachmentsThe number of the attachments on the item found
SenderThe sender of the item found
RecipientsThe recipients of the item found
DeliveryTimeThe delivery time of the item found
MessageSizeThe size of the item found in bytes

The time the item was deleted – only relevant if searching the dumpster

PolicyRunIDIdentifier of the policy run the item was found on


Table 2. PolicyRunDetails stores the details of the policies when they are run.

IDUnique Row Identifier

Name of the policy that ran

DetailsThe details of the policy which was ran
RunTimeTime the policy ran


Table 3. C2CVersion stores the version of the database format.

VersionStores the version of the database format
Last updated on