Tracking document activity, Accessing the embedded database – Kofax Front-Office Server 3.0 User Manual

Page 36

background image

Kofax Front-Office Server Administrator’s Guide


Kofax, Inc.


Save and close the file. For the changes to take effect, stop and restart Kofax Front-Office


Tracking Document Activity

Information about the following document activity is stored in the Kofax Front-Office Server

database in the table doctracking_scanjob:


Documents scanned with an MFP


Scanned documents sent from an MFP to a destination


Documents sent from the Web Client to a destination

This information can be used for chain of custody tracking or to determine which records are no

longer needed and can be purged. The database records information related to creating and

releasing documents. This information includes the following:


Device name


Form type






Creation and release times

The following entity diagram shows the view into the Kofax Front-Office Server database, with

the columns and primary key (PK). Bold text indicates columns for required data.

Figure 8. Entity Diagram: Kofax Front-Office Server Database View

Retrieving Information from the Embedded Database: Examples

This section provides information about accessing the embedded database, and an example of a

SQL statement for retrieving information from the database.

Accessing the Embedded Database

For a new installation, you access the embedded database by using the user name and password

you specified for the database administrator during installation.

This manual is related to the following products: