How to update fingerprint statistics such as the hit count and last hit date in Datacap

Fingerprint statistics can be very useful when auditing a system and determining which fingerprints are most frequently used. Metrics such as the number of times a fingerprint has been used in its lifetime and the last date it was used can be used to remove unnecessary fingerprints from the system during maintenance periods. This cleanup may improve performance when loading fingerprints and decrease the size of the setup hierarchy (unless FPXMLs are enabled) due to removal of fingerprint zones.

Solution:

Updating fingerprint statistics can be performed through application rules via the UpdateFingerprintStats action of the autodoc library. This action may be named UpdateFPStats in certain versions of the software. It updates the [Template] table of the fingerprint database by incrementing the tp_HitCount column's integer value and also updating the tp_LastHit column's date for the associated fingerprint ID.

Execution of UpdateFingerprintStats requires an open connection to the fingerprint database using OpenConnection action from the Lookup library, prior to calling UpdateFingerprintStats. It is recommended that any database connection be later closed, using CloseConnection or equivalent logic.