You can enable and configure vRealize Automation data rollover settings to control how your system retains, archives, or deletes legacy data.

About this task

Use the data rollover feature to configure the maximum number of days for vRealize Automation to retain data in the IaaS SQL Server database before archiving or deleting it. By default, this feature is disabled.

Configure data rollover settings on the vRealize Automation Global Settings page. When enabled, this feature queries and removes data from the following SQL Server database tables:

  • UserLog

  • Audit

  • CategoryLog

  • VirtualMachineHistory

  • VirtualMachineHistoryProp

  • AuditLogItems

  • AuditLogItemsProperties

  • TrackingLogItems

  • WorkflowHistoryInstances

  • WorkflowHistoryResults

If you set DataRolloverIsArchiveEnabled to True, archive versions of the tables are created in the dbo schema. For example, the archive version of UserLog would be UserLogArchive, and the archive version of VirtualMachineHistory would be VirtualMachineHistoryArchive.

When enabled, the data rollover feature runs once a day at a predetermined time of 3 a.m. according to the vRealize Automation appliance time zone configuration. Using the DataRollover MaximumAgeInDays setting, you can set the maximum number of days that you want to retain the data.

If DataRollover IsArchiveEnabled is set to True, data older than that specified in the DataRollover MaximumAgeInDays is moved to the archive tables. If DataRollover IsArchiveEnabled is set to False, data is permanently deleted and no data archiving occurs. Deleted data is not recoverable.

Note:

Consider existing system data and the potential impact on system performance before enabling data rollover. For example, if you enable this feature one year after vRealize Automation began running in your environment, verify that you have set the value of DataRollover MaximumAgeInDays to 300 or greater to ensure that enabling data rollover feature does not impact system performance.

Procedure

  1. Log in to the vRealize Automation console as a system administrator.
  2. Select Infrastructure > Administration > Global Settings.
  3. On the Global Settings page, locate the Data Rollover section of the table and review and configure settings.

    Setting

    Description

    DataRollover IsArchiveEnabled

    Specifies whether to move rollover data to archive tables after the maximum number of days is reached.

    By default this value is set to True.

    If you set this value to False, all data older than that specified in the DataRollover MaximumAgeInDays setting is permanently deleted.

    DataRollover MaximumAgeInDays

    Specifies the maximum number of days that the system retains data in the database before moving it to archive or permanently deleting it.

    By default this value is set to 90 days.

    DataRollover Status

    Specifies whether to enable data rollover.

    To enable data rollover, set the value to Enabled. By default this value is set to Disabled.

    If you disable this workflow while it is running, the current workflow is not impacted, but the next workflow is disabled.

  4. Click the Edit icon (Edit icon) in the first table column to edit a setting.

    The Value field for the applicable setting becomes editable and you can place your cursor within it to change the value.

  5. Click the Save icon () in the first table column to save your changes.