Data rolloff in Insight through command line utility

As there is often no need to retain control execution results online beyond a certain time period, Administrators can roll off, or delete, unwanted control executions automatically and manually.

Please Note: All roll-off is permanent, and cannot be undone.

The Data Roll-Off command line utility removes older control results, history, and reports from the database. As a maintenance feature, this command line utility prevents the database from getting unnecessarily large. As an efficiency feature, the command line utility removes unwanted results and reports from control views.

Path : Infogix/Insight/Infogix/server-util/default/rolloff.sh(.bat)

Command syntax
Use this command to roll off results, history, and/or reports by control for executions up to and including a specified date. Issue the Rolloff command in the directory where the Infogix command line utilities have been installed. Use the following case-sensitive syntax.

Windows

rolloff -ct {"control name1" "control name2" "all"} -r {"reference name1" "reference name2" "all"} -date YYYY-MM-DD [-username <user name> -password <password>]

UNIX

rolloff.sh -ct {"control name1" "control name2" | all } -r {"reference name1" "reference name2" "all"} -date YYYY-MM-DD [-username <user name> -password <password>]

Note: When you roll off data (by control name, reference name, all or date) containing control executions that are associated with cases, the data will not be rolled off for all the control executions.

Examples

If the specified date is 08/22/2006 for controls named Amount Due and Amount Paid, the roll-off command would be:

Rolloff  -ct  "Amount  Due     01 "  "Amount  Paid    02 " -date 2006-08-22This will remove all results (and all history and report data for Infogix ACR controls) for those controls named Amount Due and Amount Paid prior to and including an execution start date of August 22, 2006 and a start time up to and including one second before midnight (23:59:59) on that date.

Rolloff  -r all -date 2006-08-22

This will remove all results (and all history and report data for Infogix ACR controls) for controls with execution start dates and times prior to and including one second before midnight (23:59:59) on August 22, 2006.