000033246 - How to update all RSA Archer Subscription Notifications to use the Current Version Only option

Document created by RSA Customer Support Employee on Jun 14, 2016Last modified by RSA Customer Support on May 1, 2019
Version 5Show Document
  • View in full screen mode

Article Content

Article Number000033246
Applies ToRSA Product Set: RSA Archer
RSA Version/Condition: Any
IssueGoing to Administration> Notifications > Manage Subscription Notifications, the Any Version option is selected and there are many notifications that need to be updated.

How to run a SQL script that changes all Subscriptions Notifications to Digest Content Published: Current Version Only option.  This will force Archer to check that notifications still meet the criteria before being sent out.

User-added image
ResolutionChange only Subscription Notifications that have the option Daily, Weekly, Monthly, or Quarterly.  It changes all Active and Inactive Notifications.
  1. Perform a SQL Backup of the Archer Instance database
  2. Run the following SQL command against the Instance database. 

UPDATE tblNotificationTemplate 
SET latest_content_version_filter=-1
WHERE interval_type_id=3 AND format_id=2