Archive Retrieval

In Brief
The secure and reliable management of law enforcement and criminal justice data is of utmost importance to ensure public and officer safety. OpenFox® Archive Retrieval provides Administrators and/or Agency TACs with an easy-to-use system for automated, secure storage of transaction data for long periods of time. Accessing stored data is easy; users can quickly retrieve information by searching archived data using simple search commands. This database is an excellent source for investigative and court case support.


Document and Track Messages Easier

The central site component of the Archive Retrieval system allows users to store, log, and access message traffic processed by the OpenFox™ Information Broker / Message Switch System (OpenFox® System) or other product suite components. The Archive Retrieval Client software is a module running in the OpenFox® Desktop which allows users to access the stored data.  Our many years of experience developing systems for law enforcement and criminal justice have helped us identify and implement capabilities useful to the environment.


The Archive Retrieval database utilizes the latest version of Oracle or MS SQL Server to organize, store and retrieve the on-line data.

The Archive Retrieval System provides utilities that assist in the organization of the data both for on-line retrieval as well as restoration of extracted data sets to and from tape for extended management of accumulated data.

The Archive Retrieval application utilizes an indexing system based upon the most common data fields such as name, date of birth, state identification number (SID), operator’s license number, vehicle identification number, vehicle license number, social security number, serial number, owner applied number, user identification, station mnemonic, ORI, time/date, master reference index, etc., to provide quick searches. The system also provides the ability to search for text strings with full support for wild cards.

Archive Retrieval Operation

The latest version of Archive Retrieval utilizes a client module running in the OpenFox® Desktop environment to provide a method for System Administrators at the central site or TAC’s at remote locations to access the data base for retrieval, reporting, printing and forwarding functions.  Since the Archive Retrieval Client is a module running in the Desktop environment, it inherits all of the operating characteristics, such as single sign on, encryption, advanced authentication and other features designed to meet the CJIS and State Security Policies.

Query Transaction

While the graphical user interface (GUI) features plain, easy to use buttons and text boxes for data entry, the resulting returned data set will be familiar and easy to understand.  A typical search screen is depicted below.

ARC QueryTransactionInProgress

Search Screen

The results of the query are returned in a summary screen which shows the messages found during the query, allowing the user to quickly scan through the returned messages.

Detail Screen

A typical detail screen is shown below.

ARC DetailsWindow


Printing Summary

The Archive Retrieval System gives the user the ability to print a report of selected items from the Summary screen.

ARC PrintingSummary



The Archive Retrieval application includes several common reports such as an activity summary and an audit report.  Standard ODBC capable reporting tools and utilities can be used to generate statistics reports for the index and data stored in the database.  Report output can be saved in a variety of formats including text and pdf.

Download PDF Version