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, 2017
Version 1Show Document
  • View in full screen mode

Article Content

Article Number000033280
Applies ToRSA Product Set: Archer
RSA Version/Condition: All
IssueThe database tables tblDataFeedHistory and tblDataFeedMessage store Data Feed history and run detail messages. These tables can become very large over time. How can 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.