Uploaded image for project: 'Jira Service Management Data Center'
  1. Jira Service Management Data Center
  2. JSDSERVER-8706

Create a cleanup mechanism to Assets Object History

XMLWordPrintable

    • 46
    • We collect Jira Service Desk feedback from various sources, and we evaluate what we've collected when planning our product roadmap. To understand how this piece of feedback will be reviewed, see our Implementation of New Features Policy.

      Problem Definition

      Insight currently keeps a history whenever there is an update to any of the objects' Attributes (with a NEW Value), a new row will be added to AO_8542F1_IFJ_OBJ_HIST table.

      This table can increase dramatically in size.

      Suggested Solution

      Possibles solutions:

      • May be a service retention period or cleanup mechanism in Insight to allow users to specify the criteria for deletion.
      • May be a feature to exclude an attribute or object type from recording history. This would be very useful on objects or attributes that are updated automatically by automated imports with very large data.
      • May be a feature to allow admins to limit the number of characters or size within a TextArea attribute in Insight, it might help to reduce Object's History table size

      Workaround

      Currently, to remove/reduce Object's History table size, a Database query to delete rows from the AO_8542F1_IFJ_OBJ_HIST table needs to be run.

      Detailed workaround is published in this KB: Insight - How to delete Object History logs

              Unassigned Unassigned
              9f03f4114502 Pablo Bartolome
              Votes:
              60 Vote for this issue
              Watchers:
              34 Start watching this issue

                Created:
                Updated: