ChrisPope (Customer) asked a question.

March 6, 2025 at 11:46 AM
How to view/access archived data in the UI after Data Archive

In our non-Prod 8.0 P05 environment, we are testing the Admin > System > Data Management > Archiving.

 

On page 99 of the 8.0 Admin Guide, (https://community.rsa.com/s/article/RSA-Governance-Lifecycle-Administrators-Guide-8-0) it states, "...archived data is available in the current schema itself, as History tables, and can be accessed or viewed within the RSA Governance & Lifecycle".

 

However, after running the Archive, requests which matched the criteria are not visible in the UI. I've looked all over and cannot find how can archived data be viewed. Any help would be greatly appreciated.

 

Thank you in advance.

  • 5 answers
  • 219 views

  • Najeeb Peracha (RSA)

    New "combined" views have been created to combine data from both current and history tables (reference page106 of the 8.0 Admin Guide). You can create reports against those new views. There are two out-of-the-box sample reports available (see screenshot below) that you can review and then create your own reports as needed.

     

    image 

    And finally, note that 8.0 P05 introduces the option to "Clean a Data Archive" which lets you export the archived data (which then gets purged from the db). Reference section "Clean a Data Archive (for v8.0 P05, onwards)" on pages 106-107 in the 8.0 Admin Guide.

    Expand Post
    Selected as Best

  • Boris.Lekumovich (RSA)

    You can query the DB to retrieve the needed information.

     

    "data that meets the archive criteria is backed up to History tables (suffix '*_HST') "

     

    image

  • OverthinkerDave (Customer)

    Maybe a stupid question: I thought you had to restore the archived data, and the it would be available in the GUI (searchable).

     

    But ok, Boris could be right that the data ACTUALLY is not deleted, just marked ".HST", and that in itself would make the system "feel" like it was purged.

     

     

    Get a feeling I will have to test this archiving functionality in 8.0 again, now when it is said to work (or in other words it has not worked that well in 7.x).

    Expand Post

  • ChrisPope (Customer)

    Once again, @Boris.Lekumovich (RSA)​ and @OverthinkerDave (Customer)​ you guys are on it! I appreciate the replies.

     

    I have to admit though, I am still a bit confused...because in the Admin Guide that I referenced, it states that the archived data "...can be accessed or viewed within the RSA Governance & Lifecycle." This implies, at least to me, that the data is available to view in the UI after the archive. Is this not true? I was wondering how this would work because I cannot understand how performance would be improved by simply moving data from the "live" table to an "HST" table. If anything, it'd probably make performance worse. Unless there was a separate UI experience exclusively to view Archived data, separate from non-archived data...and I can't see RSA doing that.

     

    Also, just a little later in the Admin Guide...it states, "Restoration Limitation: Data cannot be restored to its original tables once archived." So, @OverthinkerDave (Customer)​, once it's Archived it cannot be restored.

     

    So then...am I correct that:

    1. Archived data is not viewable in the UI once it's been archived
    2. It is available to query on the .HST tables
    3. It is not restorable to the original "non-HST" tables
    Expand Post

  • Najeeb Peracha (RSA)

    New "combined" views have been created to combine data from both current and history tables (reference page106 of the 8.0 Admin Guide). You can create reports against those new views. There are two out-of-the-box sample reports available (see screenshot below) that you can review and then create your own reports as needed.

     

    image 

    And finally, note that 8.0 P05 introduces the option to "Clean a Data Archive" which lets you export the archived data (which then gets purged from the db). Reference section "Clean a Data Archive (for v8.0 P05, onwards)" on pages 106-107 in the 8.0 Admin Guide.

    Expand Post
    Selected as Best

Don't see what you're looking for?