To generate a list of files and tables selectively by object type and criteria

unica_acclean -o <list file name> -w {flowchart | campaign | session | sessionfolder | campaignfolder} -s criteria [-r]

Example: list temp files and tables by campaign folder

unica_acclean -o “JanuaryCampaignsList.txt” -w campaignfolder -s “NAME=’JanuaryCampaigns’” -r

This example generates a list of temporary files and tables associated with campaigns and flowcharts in the campaign folder named “JanuaryCampaigns” as well as all subfolders of “JanuaryCampaigns”, and writes it to the file JanuaryCampaignsList.txt.

Example: list temp files and tables by flowchart LASTRUNENDDATE

unica_acclean -o “LastRun_Dec312006_List.txt” -w flowchart -s “LASTRUNENDDATE < ‘31-Dec-06’”

This example generates a list of all temp files and tables with LASTRUNENDDATE earlier than December 31, 2006, in all flowcharts, and writes it to the file LastRun_Dec312006_List.txt.

Make sure that any date criteria are specified in the correct date format for your database.