Mar. 22, 2015
The ICA Log database (ICLDB) utility is a database command-line utility used to manipulate the session recording database records. This utility is installed during the SmartAuditor installation in the drive:\Program Files\Citrix\SmartAuditor\Server\Bin directory at the server hosting the SmartAuditor Server software.
The following table lists the commands and options that are available for the ICLDB utility. Type the commands using the following format:
icldb [version | locate | dormant | import | archive | remove | removeall] command-options [/l] [/f] [/s] [/?]
|archive||Archives the session recording files older than the retention
Use this command to archive files.
|dormant||Displays or counts the session recording files that are
considered dormant. Dormant files are session recordings that were not
completed due to data loss.
Use this command to verify if you suspect that you are losing data. You can verify if the session recording files are becoming dormant for the entire database, or only recordings made within the specified number of days, hours, or minutes.
|import||Imports session recording files into the SmartAuditor database.
Use this command to rebuild the database if you lose database records.
Additionally, use this command to merge databases (if you have two databases, you can import the files from one of the databases).
|locate||Locates and displays the full path to a session recording file
using the file ID as the criteria.
Use this command when you are looking for the storage location of a session recording file.
It is also one way to verify if the database is up-to-date with a specific file.
|remove||Removes the references to session recording files from the
Use this command (with caution) to clean up the database. Specify the retention period to be used as the criteria.
You can also remove the associated physical file.
|removeall||Removes all of the references to session recording files from
the SmartAuditor Database and returns the database to its original state. The
actual physical files are not deleted; however you cannot search for these
files in the SmartAuditor Player.
Use this command (with caution) to clean up the database. Deleted references can be reversed only by restoring from your backup.
|version||Displays the SmartAuditor Database schema version.|
|/l||Logs the results and errors to the Windows event log.|
|/f||Forces the command to run without prompts.|
|/s||Suppresses the copyright message.|
|/?||Displays help for the commands.|