Archive Change History rule

---

Rule Description

This rule will automatically archive then cleanup Change History details by data age.

 

When to use this rule

Use this rule to archive the Change History database. You should specify SQL settings where the archived Change History database will be stored and schedule this rule to run daily.

 

Rule Settings

Query Section

Setting name	Description
Note: By default, all settings in this section are taken from Home > Configuration > Settings > Change History.
SQL Instance	Specify the name of the SQL Instance where the database with archived Change History will be stored. Use SERVER\INSTANCENAME.
SQL Credentials	Specify SQL credentials.
Database name	Specify database name where archived Change History data will be stored.
Table name	Specify the table name. The table will be created if it doesn't exist.

 

Action Section

Setting name	Description
Cleanup action	Specify the cleanup action: Archive to SQL instance and then delete  Delete without archiving
Delete records older than	This is the Change History record retention value specified in months. The number of months specifies how long the Change History will remain available in the web portal before it is archived and/or deleted.

 

Output Section

This section defines the output format of this rule.

To get more information about this section, please see the Output section article.

 

Enforce/Schedule section

This section defines the schedule for how often to run the rule.

To get more information about this section, please see the Enforce/Schedule section article.

 

---

Change History

Version	Notes
7.2.0	The rule is introduced in the product.