Reconciliation of NAS_TRANSACTION_LOG table entries post table purge

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)
• CA Unified Infrastructure Management On-Premise (Nimsoft / UIM)
• CA Unified Infrastructure Management SaaS (Nimsoft / UIM)

Issue/Introduction

After purging a lot of data/older entries from the nas transaction log table, customer wanted to check to make sure the oldest data had been purged and date/timestamps lined up with the nas retention settings.

Environment

• Release: 20.4

Resolution

• Checked nas_transaction_log table and the oldest data using the query below:

          select top (1) time from nas_transaction_log

          2023-04-01 23:47:58.000

• Entries displayed going back to April 1st as expected post-nas transaction log purging.