000033280 - How to remove old data feed history messages from the database in RSA Archer

Document created by RSA Customer Support Employee on Jun 10, 2017Last modified by RSA Customer Support on Sep 18, 2019
Version 2Show Document
  • View in full screen mode

Article Content

Article Number000033280
Applies ToRSA Product Set: Archer
IssueThe database tables tblDataFeedHistory and tblDataFeedMessage store Data Feed history and run detail messages. These tables can become very large over time. This article explains how these tables be cleaned out so that they only store data for a certain length of time.
ResolutionThe attached SQL script deletes data feed history and run detail data older than 90 days. The notes included in the script provide instructions for changing the retention period.

Set up a SQL Agent job in SQL Server Management Studio to run the script periodically, such as once per week.

 

Outcomes