Trim Statistics DB deletes all MOVEit Automation audit records older than a certain number of days, and optionally saves them to tab-separated files.
By default, MOVEit Automation has a pre-installed task that uses this script with parameters set to specific values. If you want to create your own task using this script, note the required parameters.
Input Parameters
\Program Files\MOVEit\MICStats\Logs
. If you do not want debug and error logs, set this value to blank. \Program Files\MOVEit\MICStats
. If you do not want deleted records archived to a text file, set this to an empty value.\Program Files\MOVEit\MICStats\Logs
" (or the value of DirLog) are deleted. Use this setting carefully, because deleted files are not put into the Recycle Bin.This parameter applies to the Task Runs and File/Folder Activity tables in the database,
Notes
Use this built-in script as the only step of a task. Process-level per-file or once-after-all-files settings will be ignored.
Over time, the statistics database can accumulate many records, slowing performance and using excessive amounts of disk space. To prevent this, MOVEit Automation is typically configured to run this built-in script periodically, optionally saving them to a file or another database before deletion.
Example #1
Bob has noticed that the various task history dialogs in MOVEit Automation have been sluggish lately and asks Ipswitch for some advice. Ipswitch notices that Bob has more than two hundred tasks that poll FTP servers every five minutes, all day long. Most (98%) of these polls do not yield files, but MOVEit Automation continues to log this information during each poll. Over the course of a single day, this means that more than 55,000 "no xfer" actions are logged to the database. Bob knows that "no xfer" information can be of value in debugging, but Ipswitch would prefer that he remove them after a few days and only retain "success" or "failure" audit entries for long periods of time. Bob and Ipswitch decide to retain one week of "no xfer" records, and to keep 60 days of "success" and "failure" logs in the database. The "no xfer" records will not be saved to the longer term archive logs.
To accomplish this with MOVEit Automation: