The following examples show the usage for the database-utility.pl script.
-
database-utility.pl archive events all 14
-
database-utility.pl archive jobs 30
-
database-utility.pl archive revisions 5
-
database-utility.pl purge jobs 90
-
database-utility.pl purge events system 30
-
database-utility.pl prune revisions 10
-
database-utility.pl purge ra
-
database-utility.pl delete revisions '2 years' 10
This example retains 2 years of revision data and also maintains 10 revisions per device. It deletes all other revisions from the voyence schema.
-
database-utility.pl delete revisions '30 days' 5
-
database-utility.pl delete revisions '6 months' 5
-
database-utility.pl purge auditHistory 30
-
database-utility.pl retain latestRAAuditTrail
-
database-utility.pl delete revisions "2 years" 10
-
database-utility.pl delete revisions "30 days" 5
-
database-utility.pl delete revisions "6 months" 5
