Kofax Front-Office Server 3.0 - Manual (Page 37)

Kofax Front-Office Server Administrator’s Guide
Kofax, Inc. 37
Retrieving All Scan Jobs
The following statement retrieves all scan jobs. The returned information includes the scan job ID,
user name, and device. Destination information is also included if provided.
select * from view_doctracking_20
Purging the Database
Old document tracking records should be purged periodically to prevent the Kofax Front-Office
Server database from growing too large and affecting performance.
Enterprise Installations
For Enterprise installations using Oracle or SQL Server databases, you can use an administration
tool to purge the desired records. You can, for example, purge records with older creation dates or
those with backenddocumentid entries which indicate the documents were successfully released
to the destination. You can delete records directly from the doctracking_scanjob table.
Departmental Installations
To purge the Departmental installation embedded database, you can use the KFS_db_cleanup.bat
file. You can specify a threshold for removing records (such as removing records older than three
days). The batch file is in the \OtherResources\DBCleanup folder where Kofax Front-Office
Server is installed, and it needs to be run from that folder. You can edit the file to change its
settings.
Note Allow sufficient time for the batch file to run. If you specified a large number of records, the
batch file could take time to complete.
X To prepare the batch file
1 Edit the batch file with a text editor, changing the lines indicated in Table 1:
2 Save and close the batch file.
You can now run the batch file to whenever you want to purge the database.
Table 1. Lines to Change in DES_db_cleanup.bat
Line Changes
DAYS_OLD_THRESHOLD
Indicate the number of days that you want to keep records. Records older than
the specified number of days are deleted.
If you set the purge.entries.days value to 0 (zero) or leave the value blank, the
default value of 30 days is used.
KFS_HOME
Change to the full Kofax Front-Office Server installation path if it is different
from the default.
echo
*:*:*:username:
password
Change username and password to the user name and password for the
embedded database administrator user account. You may need to change this
data if you upgraded from an earlier version of Kofax Front-Office Server that
uses a different user name and password for the database administrator.