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

Kofax Front-Office Server Administrator’s Guide
36
Kofax, Inc.
3
Save and close the file. For the changes to take effect, stop and restart Kofax Front-Office
Server.
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
Destination
User
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.