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 the vRealize Automation system to retain data in the IaaS SQL Server database before archiving or deleting it. By default, this feature is disabled. To enable data rollover or configure settings, modify the data rollover settings on the vRealize Automation Global Properties page. When enabled, this feature queries and purges data only from the following SQL Server database tables.

  • UserLog

  • Audit

  • CategoryLog

  • VirtualMachineHistory

  • VirtualMachineHistoryProp

  • AuditLogItems

  • AuditLogItemsProperties

  • TrackingLogItems

  • WorkflowHistoryInstances

  • WorkflowHistoryResults

If the data rollover DataRolloverIsArchiveEnabled feature is set to True, archive versions of the tables are created in the dbo schema. For instance, the archive version of UserLog would be UserLogArchive, and the archive version of VirtualMachineHistory would be VirtualMachineHistoryArchive.

When enabled, the data rollover workflow runs once a day at a predetermined time of 3 a.m. according to the vRealize 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 archive is set to True, data older than that specified in the DataRollover MaximumAgeInDays is moved to the archive tables. If archive 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 property to 300 or greater to ensure that enabling data rollover feature does not impact system performance.

Procedure

  1. Log in to vRealize Automation as a vRealize administrator.
  2. Navigate Infrastructure > Administration > Global Properties.
  3. On the Global Properties page, locate the Data Rollover section of the table and review and set properties as appropriate.

    Property

    Description

    DataRollover IsArchiveEnabled

    By default this property is set to True and it moves the data to the archive tables.

    Note: If you set this property to False, all data older than that specified in the DataRollover MaximumAgeInDays field is permanently deleted.

    DataRollover MaximumAgeInDays

    Specifies the maximum number of days that the system retains data in the database before moving to archive or purging. By default this property is set to 90 days.

    DataRollover Status

    By default this property is set to Disabled. To enable this feature, set the DataRollover Status property to Enabled. If you disable this feature 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 property.

    The Value field for the applicable property 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.