Unica Campaign cleanup utility syntax and options

The unica_acclean utility supports the following syntax and options.

unica_acclean {-d|-o <list file name>}
-w {flowchart | campaign | session | sessionfolder | campaignfolder | other}
-s <criteria>
[-u <user name>] [-p <password>] [-n <partition name>]
[-l {low|medium|high|all}]
[-f <log file name>][-D <datasource list>]
[-S <dataSource> -U <DB-user> -P <DB-password>]*

Run unica_acclean on each listener node, as needed.

The cleanup utility is non-interactive unless user name or password are not specified. If a user name is not specified, the utility prompts for user name and password. If a password is not specified, the utility prompts for a password.

Table 1. Unica Campaign cleanup utility (unica_acclean) options
Option	Syntax	Description
-d	`-d`	Deletes temp tables and files. All flowchart files are scanned. Based on the results, temporary files and tables are determined.
-f	`-f <log file name>`	Specifies the name of the file where errors are logged, located in the `<PARTITION_HOME>/logs` directory. By default, this file is named `unica_acclean.log`. You can modify the log file name but not the location.
-h	`-h`	Displays usage help. Any invalid command-line invocation also displays the help.
-i	`-i <clean file name>`	Specifies the file that lists the items to be deleted. Best practice is to use the same file generated by the cleanup tool, using the `-o` option.
-l	-l {low\|medium\|high\|all} [-f <`logFileName>`]	Specifies logging level and the log file name. If no level is specified, `medium` is used by default.
-n	`-n <partition name>`	Use this option to supply the name of the partition. If the partition name is not specified, the default of "partition 1" is used.
-o	`-o <listfilename>`	Outputs the list of tables and files to the specified file, but does not delete them.
-p	`-p <password>`	Must be used when the `-u` option is used. Use this option to supply the password for the user specified with the `-u` option.
-r	`-r`	This option can be used only with the `-w` option for either campaignfolder or sessionfolder objects. When a folder is specified for cleanup and the `-r` option is added, `unica_acclean` performs the operation for all subdirectories of the specified folder. If only the `-w` option is used with a folder, `unica_acclean` performs the operation only on the top-level folder.
-S	`-S <dataSource>`	Use this option to override the credentials stored in Unica Platform or provide authentication for data sources whose ASMSaveDBAuthentication is set to FALSE. Specify the name of the data source along with the `-U` <`database_user>` and `-P`<`database_password>` options. Note: `unica_acclean` acts on all data sources irrespective of the data source specified in the `-S` option.
-s	`-s` <`criteria`>	Used with the `-w` option, defines criteria for cleanup, specified as a SQL query. The SQL `LIKE` operator can be used to do a search based on wildcards. Any data table column for the specified object can be used as criteria: When a campaign folder or session folder is the object, criteria are based on columns in the UA_Folder table. When a campaign is the object, criteria are based on columns in the UA_Campaign table. When a flowchart is the object, criteria are based on columns in the UA_Flowchart table. When a session is the object, criteria are based on columns in the UA_Session table.
-U	`-U <DBUserName>`	Specifies the user login for the data source specified by the `-S` option. Use with the `-P` option, which specifies the database password for this database user.
-u	`-u <user name>`	Must be used when the `-p` option is used. Use this option to supply the Unica user name of the user running the utility.
-v	`-v`	Displays version and copyright information for the cleanup utility.
-w	`-w {flowchart \| campaign \| session \| sessionfolder \| campaignfolder \| orphan} -s <criteria> [-r]`	Searches for temp files and tables associated with the specified object type, based on the specified criteria, except when used with the `orphan` option. Only when used with `orphan`, searches for orphaned temp files and tables across the entire system. Requires `-s <criteria>` for all options except "`orphan`". Optionally use `-r` to recursively search subfolders.
-D	[-D <datasource list>]	Accepts single or multiple datasources separated by comma and enclosed in double quotes to search and delete orphan temp tables, orphan temp files, temp tables and temp files only from the specified datasource or a list of datasources. For example: `unica_acclean -o "log.txt" -w orphan -D "Test, UA_SYSTEM_TABLES"` The above command will list all the orphan temp tables and files by scanning through only test and UA_SYSTEM_TABLES datasources. `./unica_acclean -d -w Campaign -s "Name like '%Camp%'" -D Baseinfo` The above command scans and deletes the temporary files and tables only from the Baseinfo datasource.