Skip to main content
Kofax

SQL Query for Deleted Batch Information

3014809

Question / Problem: 

Query to find information about a batch that was deleted by a user when having access to the Kofax Capture database and User Tracking is enabled

Answer / Solution: 

If “User Tracking” is enabled then it is possible to query Kofax Capture database by combining the data from table StatsBatch and StatsBatchModule.

 

StatsBatch table will provide the batch name and will show the module to determine the last module run with the user. StatsBatchModule will supplements the other columns to determine if a batch was deleted.

 

The following query provides a base to find the information about the batch and by whom was deleted:

SELECT c.ExternalBatchID, c.BatchName, d.ModuleName, d.StartDateTime, d.EndDateTime, d.BatchStatus, d.Priority, c.CreationUserID, c.CreationUserName
FROM StatsBatch c
JOIN StatsBatchModule d ON c.BatchGUID = d.BatchGUID
WHERE c.BatchName = 'BATCHNAME'
ORDER BY c.EndDateTime ASC

 

If “User Tracking” is not enabled, the only way to find will be Kofax delete logs located in \\servername\CaptureSV\Logs\Log_YYMM.txt . However, the log will only have the batch but it doesn’t provide a username.

 

Applies to:  

Product Version
CAPTURE 10.0
  10.1
  10.2
  11.0

 

 

  • Was this article helpful?