Archive Change History rule

---

Rule Description

This rule will automatically archive and then clean up Change History details by data age.

More about change history and what data it contains see here: Auditing Cayosoft Administrator with Change History and Execution History

 

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 the 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: all old records will be moved to MS SQL instance first and then removed from local storage. You need to have valid SQL settings in the Query section.  Delete without archiving: all old records will be removed without moving them to the archive database. In this case, you don't need to specify SQL settings in the Query section.
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/Console 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.