The following are the required arguments for the <ARGUMENTS> value, when using the perl database-utility.pl script.

  • The events type requires two arguments:

    • Type of event (device, system, security, or all)

    • Number of days to retain (for example, 1, 2, 3)

  • The jobs type requires one argument:

    • Number of days to retain (for example, 1, 2, 3)

  • The revisions type requires one argument:

    • Number of revisions to retain per device (for example 1, 2, 3)

  • If the <COMMAND> <TYPE> is delete revisions, it needs two arguments:

    • Time interval for saving data enclosed in quotation marks. For example:

      • Linux: ‘2 years’ or ‘3 days’

    • Number of revisions to retain per device (for example 1, 2, 3).

  • If the <COMMAND> <TYPE> is purge ra, no arguments are required.

  • If the <COMMAND> <TYPE> is retain latestRAAuditTrail, no arguments are required.

    • This option deletes all the old Audit Trail records from RA tables like cm_rpt* and retains only the latest Audit Trail record.

  • If the <COMMAND> <TYPE> is purge auditHistory, it needs one argument:

    • Number of days to retain the audit data (for example, 1,2,3)

      Note:

      Event Pruning retains last Nx24 hours of events, whereas Job Pruning retains last N days of jobs.