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